Viewing 15 posts - 51,121 through 51,135 (of 59,078 total)
antonio.collins (4/14/2008)
LEAD()/LAG() give access to next/prior rows in an ordered set without needing a self join.http://www.oracle-base.com/articles/misc/LagLeadAnalyticFunctions.php
Thanks, Antonio.
Heh... "Ordered Sets" in an RDBMS... I use them a fair bit but what...
April 14, 2008 at 10:44 am
Temp table???? What temp table????
April 14, 2008 at 10:35 am
Greg... stupid question on my part, but have you tried using RTRIM to get rid of the trailing spaces?
April 14, 2008 at 10:35 am
TheSQLGuru (4/14/2008)
On a side note, I personally despise views!! As a consultant they REALLY confound my efforts to examine/tune my client's queries!
Hear here! I second that... wasn't going...
April 14, 2008 at 10:31 am
David.Mizelle (4/14/2008)
April 14, 2008 at 10:28 am
david.buncle (4/14/2008)
TEST? This datatype isn't recognised for SQL Server 2000... Did you mean TEXT?, if so this is invalid for a local variable.
... and, although you can't declare a local...
April 14, 2008 at 10:24 am
david.buncle (4/14/2008)
TEST? This datatype isn't recognised for SQL Server 2000... Did you mean TEXT?, if so this is invalid for a local variable.
Yes... TEXT... coffee deprivation while typing. Thank...
April 14, 2008 at 10:23 am
Derek Dongray (4/14/2008)
Both Jeff's and Peso's queries do not eliminate pairs where the status stays the same.
Sorry... with all the other stuff, I missed that requirement altogether.
Additionally, as Peso...
April 14, 2008 at 10:22 am
I wonder which would work more quickly? I think the CLR might win this one because it uses implicit functions...
April 14, 2008 at 9:54 am
GilaMonster (4/14/2008)
CREATE TRIGGER On_Delete
ON tblActivityArchive
AFTER DELETE
AS
BEGIN...
April 14, 2008 at 9:49 am
Thanks, guys... I appreciate the feedback...
Gus, did you test for rounding errors?
April 14, 2008 at 9:45 am
T-SQL is absolutely NOT the place to format currency. This should be done in the GUI so that local currency formatting may be allowed to prevail. Also, you...
April 14, 2008 at 6:58 am
There's a thousand posts on this... search for "Convert rows to columns".
Also, why do you want to do this? What if a Department has 1,000 employes? How would...
April 14, 2008 at 6:32 am
You don't need XML for this... you can just do an INSERT with the understanding that there is no real good way to return the UniqueIdentifiers to the GUI without...
April 14, 2008 at 6:30 am
You could use replication for this but I suspect you're trying to build a "Gold Set" or something similar one table at a time. You could use SELET/INTO which...
April 14, 2008 at 6:24 am
Viewing 15 posts - 51,121 through 51,135 (of 59,078 total)