Viewing 15 posts - 14,941 through 14,955 (of 18,923 total)
Bingo :
SELECT dbo.sysobjects.name AS TableName, dbo.syscolumns.name AS ColName, dbo.systypes.name AS DateType, dbo.systypes.xtype
FROM dbo.systypes INNER JOIN
...
July 14, 2005 at 2:53 pm
Can't really help you without the structure and sample data. Have a look at DateDiff, between, , DateAdd in the books online for a start.
July 14, 2005 at 2:41 pm
To see the rest of this thread :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=201273
July 14, 2005 at 2:20 pm
That's an easy fix
.
Declare @id
set @id = 0
Update dbo.table set @id = FakeIdent = @id + 1
Done
.
July 14, 2005 at 2:07 pm
Got it... change the in to inner join
>>
SET SHOWPLAN_TEXT ON
GO
Select PkADP, ADPname from dbo.ADPS A INNER JOIN (Select EachId from dbo.fnSplit_Set...
July 14, 2005 at 2:05 pm
Well this I'll have to find out another time.. thanx for the info.
July 14, 2005 at 1:54 pm
They are talking about the function ISNULL not the operand "is null".
July 14, 2005 at 1:53 pm
Here's another plan : Add the identity field directly to the main table to avoid generating it on the fly... You just saved yourself from a full table insert. ...
July 14, 2005 at 1:52 pm
I would have to see the execution plan.. if it's not a cast then you might have to force the optimizer to choose another route. This is a case...
July 14, 2005 at 1:49 pm
No offense, but this seems like a lot of overhead for such a simple task... Maybe it's just me but xml reminds me of 1950s flat file dbs... don't see...
July 14, 2005 at 1:47 pm
Viewing 15 posts - 14,941 through 14,955 (of 18,923 total)