Viewing 15 posts - 181 through 195 (of 1,048 total)
AS Koen said Please provide the actual execution plan then only we can provide you some suggestion...
September 11, 2013 at 11:25 pm
Amit Raut (9/11/2013)
SELECT * FROM Table AINNER JOIN Table B
WHERE LEFT(A.UserName, 7) = B.ID -- RELEVANT FIELD FROM TABLE B
Its not a good practice to use functions like LEFT, RIGHT...
September 11, 2013 at 11:18 pm
good one Mark 🙂
September 11, 2013 at 7:00 am
T-sql is the language which is used to write scripts.
SQL server is the engine
September 11, 2013 at 6:28 am
Please provide the tables structure and desired output.....
you can check the link in my signature about posting the question
September 11, 2013 at 6:26 am
Your requirement is not clear to me...
On what basis you are doing rhis thing-
for Grp 20, dated 05-11-2012, it needs to be compared to the max date for Grp 10...
September 11, 2013 at 6:13 am
It will be good if you use BETWEEN to specify date ranges... I have made some changes in your SP and placed BETWEEN in where condition..
Please run and let us...
September 11, 2013 at 5:33 am
adb2303 (9/9/2013)
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[myproc]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[myproc]
GO
+1 🙂
September 11, 2013 at 5:22 am
SQLTestUser (9/9/2013)
IF EXISTS(
select 1 from Xlog where LogDATE >= cast(getDate() as date) -- should this be datetime if i have Sql server...
September 11, 2013 at 5:20 am
Ryan1 (9/10/2013)
It makes a lot more sense when I see it written out in English.
I still don't get pivot views entirely. I can write out the...
September 11, 2013 at 5:15 am
Danny Ocean (9/10/2013)
handkot (9/10/2013)
I got an error: "String or binary data would be truncated. The statement has been terminated."(0 row(s) affected);-)
Just because of "Steppenwolf" having length 11. So insert...
September 10, 2013 at 11:17 pm
Viewing 15 posts - 181 through 195 (of 1,048 total)