Topics
Started by
Posts
Last post
hi pros, hope every thing goes well, SET STATISTICS IO ON SET STATISTICS TIME ON DECLARE @…
6 replies
Hi all, I need some help here. I posted in the wrong forum and i appreciated the help received, bu…
6 replies
hi all, I have this rather generic function that executes a stored proc with a bunch of parameters:…
2 replies
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
Viewing 15 topics - 3,211 through 3,225 (of 10,647 total)
You must be logged in to create new topics.