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)
Temp Table 'vs' Table Variable 'vs' CTE.  
Rated 4 stars based on 1 vote
IN_Sandeep 50 100,830 Wednesday, August 24, 2016 9:51 AM
Last Post By: Matt Miller (#4)
Hot Topic (New Replies)
Invalid use of a side-effecting operator 'INSERT EXEC' within a function:  
Using "openquery" method to get info from a "linked" server within a "function"::
126 Has Attachments!
John Esraelo-498130 52 34,738 Monday, August 22, 2016 5:03 PM
Last Post By: Lynn Pettis
Topic (New Replies)
selecting top rows by counting a variable total  

louise 28346 9 269 Thursday, August 18, 2016 2:53 PM
Last Post By: drew.allen
Topic (New Replies)
I need the list of those left and right side members list in binary tree along with sum(Amount Invested under his left and right side).  

mcasuman2004 7 752 Wednesday, August 17, 2016 1:57 AM
Last Post By: chintangandhi007
Topic (New Replies)
help with effective dating logic  

is250sp 5 99 Wednesday, August 10, 2016 3:33 PM
Last Post By: is250sp
Topic (New Replies)
Using Charindex  

sam 55243 3 72 Wednesday, August 10, 2016 12:41 PM
Last Post By: Alan.B
Topic (New Replies)
Select from two tables, side by side  

mannaggia 7 3,721 Friday, August 5, 2016 2:53 AM
Last Post By: dindinudin
Topic (New Replies)
Each GROUP BY expression must contain at least one column that is not an outer reference.  

Anamika 7 58,033 Thursday, July 28, 2016 9:30 AM
Last Post By: PringleEater
Topic (New Replies)
Given a date, return nth weekday of month?  

analoglife23 5 3,339 Wednesday, June 29, 2016 3:47 PM
Last Post By:
Hot Topic (New Replies)
Getting the VARBINARY data into a VARCHAR field  
Danspojken 15 17,197 Tuesday, June 21, 2016 1:36 PM
Last Post By: Sergiy
Topic (New Replies)
Insert Same rows Multiple times  

CrazyMan 8 2,707 Saturday, June 18, 2016 2:15 PM
Last Post By: durga.palepu
Topic (New Replies)
Locking during Transactions  

sam 55243 2 188 Wednesday, May 18, 2016 5:03 AM
Last Post By: John Mitchell-245523
Hot Topic (New Replies)
Using CTE Common table expressions with SELECT CASE statement  
How to use CTE's with a conditional clause
_UB 12 6,001 Tuesday, May 17, 2016 2:52 PM
Last Post By: drew.allen
Topic (New Replies)
How do I capture the active Stored Procedure Name to use in an error message  

jpgillum 3 249 Wednesday, May 11, 2016 7:22 PM
Last Post By: Sergiy
Topic (New Replies)
Converting Hex String to Int  

AK007 7 4,841 Tuesday, May 10, 2016 9:09 PM
Last Post By: Sergiy


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