Forum Replies Created
Viewing 15 posts - 136 through 150 (of 4,080 total)
-
RE: Bones of SQL - Practical Calendar Queries
Jeff Moden (10/13/2016)
ScottPletcher (10/13/2016)
Btw, Thanksgiving is the fourth Thursday of the month not necessarily the last Thursday (see year 2012, for example).I missed that on the first read. Thanks,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: DATE DIFF from previous row
Thanks for the explanation. Without seeing a column for "Barn" we have no way of knowing that. But my previous set of options remains...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Which of the 2 queries is better in terms of performance
Not today. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Which of the 2 queries is better in terms of performance
You should be ashamed, Lynn. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: DATE DIFF from previous row
First I'd make sure that your data was correct and that somebody hadn't fat-fingered a flock number.
You have a number of options as I see...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
Good read, Chris. Thanks.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
Define cascading please. Output from itvf_1 becomes input to itvf_2 ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
WHOA !! THOSE ARE LARGER THAN LIFE !!!!! :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
Eirikur Eiriksson (10/3/2016)
Luis Cazares (10/3/2016)
Jeff Moden (10/2/2016)
The Dixie Flatline (9/30/2016)
Fortunately, I only need around 300, not thousands. 😀Thanks guys.
Just curious.... what are you doing that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: DUPLICATING ROW TABLE BY A VALUE IN A COLUMN
Hope you get an A....
declare @input table (ID int, Schedule int, ISCI varchar(10), rotationnumber int)
insert into @input
values
(1, 100, 'abc', 9),
(2, 200, 'cod', 5),
(3, 450, 'xay', 1)
select N.*
from @input...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
While we're on the subject, does anyone know of a reason there could be a performance hit from doing all these cross applies? I'm assuming it makes...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
This is part of an ETL process I'm having to work on replacing. The existing process has rather complicated logic governing when columns can be updated in...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
One more thing. One of the reasons I've always loved SSC as a resource is that you guys went to the trouble of writing the code to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
Fortunately, I only need around 300, not thousands. 😀
Thanks guys.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Maximum number of CROSS APPLY functions
Oh that's a BIG help.
I guess it will tell me when I've gone too far.
Thanks anyway, Drew.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 136 through 150 (of 4,080 total)