Viewing 15 posts - 1,456 through 1,470 (of 4,080 total)
Wow, a nice technical discussion on The Thread.
Who'd have thought?
SACRILEGE!! HERESY!! CURSORS!! :w00t::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
August 5, 2010 at 8:26 am
Good eye, Howard.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2010 at 8:23 am
I think that may be looking at a terminology difference, Jeff. What you can't do (at least according to my reading) with a PIVOT table is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2010 at 7:31 am
I'm assuming their is a unique index or a constraint on MAIN_TABLE. If you have duplicate values for those two columns you have a problem....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2010 at 9:27 pm
If I understand you correctly, you want a column for each input date without having to specify the dates in advance, like excel will do. The...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2010 at 9:00 pm
BBQ diplomacy. You gotta love it.
Unless of course you're vegan.
I apologize to all fundamentalist vegans.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2010 at 10:56 pm
I think whoever hired Ms. Placas should be applauded for going above racism.
It took courage to make such a decision, knowing that a large segment of their...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2010 at 1:26 pm
sql-troubles (7/30/2010)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2010 at 3:44 pm
though, as far I know, a dynamic script can't be run from an inline table-valued function because neither EXEC nor sp_executesql could be called from a SQL Server UDF of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2010 at 1:39 pm
I haven't saved them, no. Some might be a year or more older. I'll see if I can search for a couple.
--------
Edited:
You can find...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2010 at 1:19 pm
What prevents dynamic SQL from either (A) making use of an existing inline table valued function, or (B) dynamically creating a subquery equivalent to the inline table valued function and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2010 at 12:22 pm
dbowlin
I am not completely clear on the sp_executesql and how it prevents SQL Injection, so you have given me some more studying to do as well.
Using sp_executeSQL, queries don't...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 30, 2010 at 9:16 am
I've been out for weeks. Thanks for checking, Gail.
:crying:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 28, 2010 at 2:31 pm
Problem?
I see no problem.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 28, 2010 at 12:44 pm
Can I borrow a cup of reality? I need it to for a homemade BBQ sauce recipe....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 28, 2010 at 12:37 pm
Viewing 15 posts - 1,456 through 1,470 (of 4,080 total)