Transact-SQL
TSQL challenges? This is the place for advice and discussions
Filtering and SortingUse these options to narrow down the question and discussion list.
- 9157

Update query using Case?
Srikanthd5 Monday, May 20, 2013 10:48 AM - 687

Nested CASE in ORDER BY
John 09 22 hours 43 minutes ago - 683

subquery
Dynamo70 22 hours 37 minutes ago - 4105

shall we convert the below update query into OpenQuery.
RoyalM Monday, May 20, 2013 9:11 AM - 488

How to capture the decimal value
MarkAravind 23 hours 30 minutes ago - 246

date convert to German format failing
Vaishu Tuesday, May 21, 2013 2:23 AM - 3103

Grouping with Case or If in TSQL
karon1980 Monday, May 20, 2013 8:29 PM - 170

select top 1 salary from each department
tsql_new Monday, May 20, 2013 11:32 PM - 261

Want to calculate in meters with geography::Point
Kashif Chotu Monday, May 20, 2013 10:26 PM - 665

Pick dollars and cents
dlchase89 Monday, May 20, 2013 9:19 PM - 13122

Insert Trigger
srisql Monday, May 20, 2013 2:28 PM - 5245

Need help with the TSQL.
NguyenBL Friday, May 17, 2013 9:10 PM - 492

How to Convert the DateTime Value into the Fiscal Year ???????
Wazid Ali Monday, May 20, 2013 4:02 PM - 6175

SELECT data from preceding row of result set when the current row has a NULL
Lee Markum Friday, May 17, 2013 3:35 PM - 368

Query to sum values from dynamic columns
TruncatedHype Monday, May 20, 2013 3:36 PM - 158

Recently executed quires on a table
Koteshwarg Monday, May 20, 2013 6:54 PM - 13134

SQL Union Statement does not work as expected
z0802361 Monday, May 20, 2013 3:21 PM - 5103

What Happens Behind the Scenes With PIVOT?
Nathon Dalton Monday, May 20, 2013 3:25 PM - 4119

bad example or lack of understanding??
dob_xml Monday, May 20, 2013 12:40 PM - 10197

What's the best way to compare two numbers
Lin215 Monday, May 20, 2013 6:49 AM

