Forum Replies Created
Viewing 15 posts - 1,396 through 1,410 (of 4,080 total)
-
RE: Are the posted questions getting worse?
Apostrophes are also good for accenting sounds which are unpronounceable by human mouths.
Ph'nglui mglw'nafh Cthulhu R'lyeh wgah'nagl fhtagn
__________________________________________________
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: Are the posted questions getting worse?
Alvin Ramard (9/17/2010)
CirquedeSQLeil (9/17/2010)
But what does the null represent?Same as you get when you cross an elephant with a rhinocerous. Elephino. 😛
__________________________________________________
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: simple SELECT query takes ten seconds to return 5000 rows - can I optimize?
Paul: I wasn't aware this was a Speed Phreak challenge. 😀
8kb: If you're willing to change the clustered index structure to 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 -
RE: simple SELECT query takes ten seconds to return 5000 rows - can I optimize?
In the example below, a CROSS APPLY technique manages to run a hair faster with an execution plan that goes directly from an index scan into a clustered index seek,...
__________________________________________________
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: simple SELECT query takes ten seconds to return 5000 rows - can I optimize?
On my laptop, I'm getting subsecond response time using data generated by your script and no additional indexing. But I'm testing by writing to a temp table....
__________________________________________________
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: To insert a value from a table into a warning statment
The VALUES clause is one source of data to be inserted, but a SELECT clause can also be a source of data for an INSERT.
See 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 -
RE: To insert a value from a table into a warning statment
only scalar variables are allowed in an insert
Pardon me, are we talking about something other than T-SQL?
I ask because in T-SQL there is no...
__________________________________________________
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: Are the posted questions getting worse?
What's humour? You hanging out with Brit's in TN?
Brit's what? That's what I want to know.
Brit himself is a pretty decent fellow.
__________________________________________________
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: Are the posted questions getting worse?
No!!
I disappeared!! :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: To insert a value from a table into a warning statment
The CHAR(4) is a datatype, as opposed to INT or VARCHAR or DATETIME, etc. It indicates that the 4 digits of the years are being stored as...
__________________________________________________
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: Are the posted questions getting worse?
ALZDBA (9/16/2010)
CirquedeSQLeil (9/16/2010)
BTW - at the pace you guys are on with this thread - 20K should be easy peezy lemon squeezy.21k may be attainable 😎
A single printout may even...
__________________________________________________
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: Are the posted questions getting worse?
CirquedeSQLeil (9/16/2010)
Did Bob change his Avatar again?Avatar? What avatar?
I see you, Jason.
__________________________________________________
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: To insert a value from a table into a warning statment
avi-631555 (9/16/2010)
To insert a value from a table into a warning statmentmy script currently is as
Update table A
Set RptStatement = ' watever you comapnyName @2010'
where (...
__________________________________________________
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: Are the posted questions getting worse?
WayneS (9/16/2010)
Alvin Ramard (9/16/2010)
I give up. How can I expect to win when I'm dealing with people that do not appreciate good humour? 😎But we do appreciate...
__________________________________________________
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: Are the posted questions getting worse?
GilaMonster (9/16/2010)
CirquedeSQLeil (9/16/2010)
And is that a bit threaded towel to be thrown in?*groan*
If I can get away in time to drive up to Memphis for Alvin's SSIS presentation, I promise...
__________________________________________________
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 - 1,396 through 1,410 (of 4,080 total)