Topics
Started by
Posts
Last post
if you have the following code (where temptable does not exist): BEGIN TRAN BEGIN TRY PRINT …
6 replies
I am familiar with how to group my query results by year, month, week etc. But what is the best wa…
12 replies
hi, i've a query that's used to build a delta set between two tables and for some reason i'm getti…
7 replies
Dear friends, I have to do a calcuation for field Duration using the formula as below- (Temporary A…
2 replies
How can i find the exact no. of months between two dates? select DATEDIFF(dd, '2013-08-05 00:00:00…
2 replies
When setting my @sql statement to FROM SATXFPMetrics WHERE [Date] >= CONVERT(datetime,'''+ @S…
6 replies
Hi All, I have a series of strings in a variable @buyer 3, RRRRR 4, SSSSS 5, DDDDDDDDDDD 6, AAAA 7,…
4 replies
I walked into a project where they are re-writing old SQL 2000 code from the ground up but making l…
3 replies
I have two tables with the following columns: Table 1 customer_id 1 2 3 4 5 6 Table 2 id, cust…
6 replies
ShortTypeOutstandingShort_Id Long 2333.121 Short 2333.121 Long…
3 replies
Hi, I have this query that is giving me a Incorrect syntax near the keyword 'SELECT' error It's …
2 replies
My client has an application which also creates summary reports. My task is to improve those report…
7 replies
I have an excel sheet being imported with 8 columns. One column (say name)has comma delimited strin…
4 replies
I cant understand why these two statements gets different result for me. Statement with NOT IN gets…
4 replies
I'm making some changes to a report written with a while loop, and thought I would look at some per…
1 replies
Viewing 15 topics - 3,211 through 3,225 (of 10,636 total)
You must be logged in to create new topics.