No announcements
-
0 VotesWho will be announced as the next Transact-SQL Guru? Read more about May 2018 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance ...Sticky | 1 Replies | 224 Views | Created by pituach - Tuesday, May 01, 2018 7:04 AM | Last reply by [Kamlesh Kumar] - Thursday, May 10, 2018 7:51 AM
-
0 Votes
POSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you're asking for ...
-
0 Votes
Decimal conversion
Hi, Please help create table temp ( amt ...Unanswered | 2 Replies | 38 Views | Created by Antonioy - 1 hour 31 minutes ago | Last reply by saravanatn1 - 47 minutes ago -
0 Votes
Dynamic SQL with Inner Join
Hi experts, How can i use Dynamic SQL with Inner join and Pickup in the Select Please see my below code declare ... -
0 Votes
How to do sum of a recordset without looping
Hi there, I need to sum of some records which is more than 1500, its already stored in rs.recordset with select all query. I ...Unanswered | 3 Replies | 39 Views | Created by nebuMATHEW - 3 hours 22 minutes ago | Last reply by Visakh16 - 2 hours 38 minutes ago -
0 Votes
"Paging Style" query is stupendously slow on last page - ideas to fix?
'EXH02435362' The Exhibit table contains about 3 million records, and the Location table about 50,000. WITH temp1 (C_Code) AS ( SELECT ...Unanswered | 5 Replies | 71 Views | Created by Kevmeister - Friday, May 25, 2018 2:22 AM | Last reply by Erland Sommarskog - 2 hours 54 minutes ago -
0 Votes
Difficult Pivot
Hi, So I have this code that will go thru all the databases and retrieve a list of users and the database roles they are members of, it uses dynamic SQL and sp_MSForEachDB and it ...Unanswered | 6 Replies | 75 Views | Created by Michael MacGregor - 16 hours 8 minutes ago | Last reply by Visakh16 - 4 hours 42 minutes ago -
0 Votes
Check if database is mirror.
Hi Experts, How to check and redirect my code using tsql Example; I have a TSQL that connects directly to a database to select a certain data. ...Proposed | 1 Replies | 41 Views | Created by kai012 - 9 hours 0 minutes ago | Last reply by Shanky_621 - 6 hours 29 minutes ago -
0 Votes
BUG in sql server when handle dynamic SQL script nvarchar(max)?
Hi all, I am working on optimize the dynamic SQL script from reporting system. I have found that SQL Server has problem to run the dynamic SQL in below ...Proposed | 1 Replies | 48 Views | Created by Meng Zhilin - 12 hours 46 minutes ago | Last reply by Tom Cooper - 9 hours 58 minutes ago -
0 Votes
Three different tables only two has relation
Hi Support, I am new to SQL SERVER , I know my way around standard Select, Update, Insert and DELETE statements, however I am really in need of some help just ...Unanswered | 4 Replies | 61 Views | Created by los hanne - Thursday, May 24, 2018 10:44 PM | Last reply by Aalamjeet Rangi - 15 hours 57 minutes ago -
0 Votes
EXISTS vs. IN
I'm having a real hard time with EXISTS and trying to visualize it. Like I get IN because it's actually comparing a key to a derived list. But how does EXIST function? In lay man terms...and are there ...Unanswered | 2 Replies | 43 Views | Created by ITBobbyP - 16 hours 44 minutes ago | Last reply by Visakh16 - 16 hours 12 minutes ago -
0 Votes
PIVOT with out sum
Hi All I want to PIVOT three columns but i do not want a SUM from the below code, how can i do that. I want the new_value and old_value to populate.please ...Proposed | 3 Replies | 69 Views | Created by AmyBI - Thursday, May 24, 2018 2:07 PM | Last reply by Aalamjeet Rangi - 16 hours 27 minutes ago -
1 Votes
Parameter for either a list or range in stored procedure
I am looking for a way to have one parameter be able to handle a list of values or a range. So a user can type in either 1,2,3,4 or 1-4. How would I build the logic for that in my ...Answered | 2 Replies | 41 Views | Created by FLSojourner - 18 hours 42 minutes ago | Last reply by FLSojourner - 16 hours 36 minutes ago -
0 Votes
Transact-SQL
Hello all, This is possibly a rather simple Q, but nevertheless a challenge for me. I have table in MS SQL Server 2008 in following ...Proposed | 6 Replies | 108 Views | Created by Red987 - Thursday, May 24, 2018 6:49 PM | Last reply by Aalamjeet Rangi - 17 hours 0 minutes ago -
0 Votes
How to get a list of encounter that has multiple values
Hi I have a visit flag table with columns 'Encounter_Number', 'Visit_Flag' I need all encounter number that has the following visit_flag ...Proposed | 1 Replies | 37 Views | Created by sumancv - 19 hours 48 minutes ago | Last reply by Visakh16 - 19 hours 21 minutes ago -
2 Votes
How to convert 2018-05 to Datetime
I have a SQL Table that has values like 2018-04, 2018-05 etcc.... How do I convert that to datetime. i need to use that field in a dateadd function and hence require it to be ...Proposed | 9 Replies | 136 Views | Created by Desigal59 - Wednesday, May 23, 2018 8:56 PM | Last reply by Brian Tkatch - 23 hours 17 minutes ago -
3 Votes
Archiving data from on premise SQL Database to Amazon Glacier
Hi , I am archiving tables data from on premise instance to amazon glacier and Our requirement is to maintain two years old data on ...Proposed | 3 Replies | 74 Views | Created by ESQL5 - Friday, May 25, 2018 8:15 AM | Last reply by Leon Laude - Friday, May 25, 2018 11:25 AM -
0 Votes
SQL Server and Domain User
This server is not in our domain!!! Thank you in advance.Discussion | 2 Replies | 57 Views | Created by Azura Mos - Thursday, May 24, 2018 7:45 PM | Last reply by Olaf Helper - Friday, May 25, 2018 7:16 AM -
0 Votes
SQL object dependancies
Hi, I have multiple databases on my SQL instance. How can I find ALL objects that reference 1 (one) particular table? Also, how can I find the ...Answered | 4 Replies | 65 Views | Created by RonTech1 - Thursday, May 24, 2018 11:00 AM | Last reply by Erland Sommarskog - Thursday, May 24, 2018 10:04 PM -
4 Votes
T-SQL GROUP BY n minutes
= '2011-01-04') Select [timestamp], Cast(Avg([TA]) As decimal(12,2)) As AvgTA From tmp Group By [timestamp] Order By [timestamp]; i have the problem that i ...Answered | 11 Replies | 21995 Views | Created by TomTom1234 - Wednesday, January 05, 2011 7:30 AM | Last reply by SebNChill - Thursday, May 24, 2018 8:42 PM -
0 Votes
Slightly Challenging question -- Query system Tables to find Unique Columns
Hello, I need to combine 6 tables to have a union all. Each Table has more than 200 columns and its a tedious job to manually compare ...Proposed | 4 Replies | 77 Views | Created by arc2013 - Thursday, May 24, 2018 3:34 PM | Last reply by Alambir Sandhu - Thursday, May 24, 2018 5:31 PM -
1 Votes
There are no SQL Server instances or shared features that can be updated on this computer
There are no SQL Server instances or shared features that can be updated on this computerAnswered | 4 Replies | 4187 Views | Created by GENESTOF - Monday, April 01, 2013 6:59 AM | Last reply by JEFF DEL - Thursday, May 24, 2018 5:25 PM - Items 1 to 20 of 89722 Next ›
No announcements
