Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On


T-SQL (SS2K5) Expand / Collapse
TitleStarted ByRepliesViewsLast Post
Hot Topic (New Replies)
get the first Sunday and last Saturday  
how to get the first Sunday and last Saturday of a month
jagadeeps 22 14,141 Tuesday, May 10, 2016 6:17 AM
Last Post By: Lowell
Topic (New Replies)
Help with select statement when WHEN Clause involving multiple databases  

skb 44459 3 171 Thursday, May 5, 2016 5:27 AM
Last Post By: Lowell
Topic (New Replies)
Charindex in inner join affects the perfomance  

kore.sid 9 320 Tuesday, May 3, 2016 10:18 AM
Last Post By: Luis Cazares
Topic (New Replies)
Read and parse XML -- tsql  

sam 55243 3 170 Monday, May 2, 2016 4:17 AM
Last Post By: Eirikur Eiriksson
Topic (New Replies)
Case Pivot Table inside Function  

fergfamster 7 217 Friday, April 29, 2016 10:19 AM
Last Post By: fergfamster
Topic (New Replies)
Row Group Totals at the end of the page  

shyamhr 0 136 Thursday, April 28, 2016 5:14 AM
Last Post By: shyamhr
Topic (New Replies)
sp_executesql : Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.  
Getting error while using sp_executesql

antonyvijayan 7 50,018 Wednesday, April 27, 2016 1:15 PM
Last Post By: Doug-107928
Topic (New Replies)
Sum with Isnull  

TeenaR 8 373 Wednesday, April 27, 2016 12:30 AM
Last Post By: TeenaR
Topic (New Replies)
How to dynamically determine how many columns and their names that are in a work table  

jpgillum 5 225 Monday, April 25, 2016 2:40 PM
Last Post By: jpgillum
Topic (New Replies)
how do i capture the result set from a query into a variable @SQLstr so I can exec(@SQLstr)  

jpgillum 1 159 Monday, April 25, 2016 1:45 PM
Last Post By: Lowell
Topic (New Replies)
Query to get Last month's Data  

ssismaddy 8 14,899 Wednesday, April 20, 2016 9:37 AM
Last Post By: Jacob Wilkins
Topic (New Replies)
MSG 444 - Select statements included within a function cannot return data to a client.  

ajwilliams504 6 324 Wednesday, April 20, 2016 9:01 AM
Last Post By: Luis Cazares
Topic (New Replies)
The USE command and variables  
Trying to use the USE command with a variable

Andrew Ryan 9 12,985 Wednesday, April 20, 2016 3:32 AM
Last Post By: Sgar...
Topic (New Replies)
Deleting All Characters before 2 Set Characters  

les.61 4 230 Monday, April 18, 2016 7:17 AM
Last Post By: Luis Cazares
Hot Topic (New Replies)
need help about procedure  
hangnt90.hanu 12 1,859 Monday, April 18, 2016 3:56 AM
Last Post By: rigo_ibis


Permissions Expand / Collapse

Topic Key Expand / Collapse
Topic (New Replies)  Topic (New Replies)
Topic (No New Replies)  Topic (No New Replies)
Hot Topic (New Replies)  Hot Topic (New Replies)
Hot Topic (No New Replies)  Hot Topic (No New Replies)
Poll (New Replies)  Poll (New Replies)
Poll (No New Replies)  Poll (No New Replies)
Closed Topic  Closed Topic
Moved Topic  Moved Topic