Viewing 15 posts - 1,591 through 1,605 (of 4,080 total)
Be advised that UNION ALL will only help you if the header/trailer rows have identical layouts. The whole header/trailer idea is totally alien to the way SQL...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2010 at 10:41 pm
Dynamic SQL is likely your best bet. You can use however many values are in your table to generate parts of your WHERE clause. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2010 at 10:34 pm
Just some peanuts from my section of the gallery. I'm not sure how I vote yet.
I think we all agree that it's a good thing to be able...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2010 at 10:16 pm
Given that the question is a beginner's question, I think its safe to assume that reading execution plans isn't something Neliii is prepared to do yet.
Nelliii, please read Jeff's article...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2010 at 9:33 pm
If you only have READONLY permissions to a database, you can't create objects in the DB. In the future, talk to your DBA about your needs before you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2010 at 8:58 pm
It's highly possible that the interview question was simply designed to draw out your knowledge of views and stored procedures. If I was conducting an interview 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
May 12, 2010 at 4:18 pm
Sometimes you can make code literally hundreds and sometimes thousands of times faster simply by dividing the code up and maybe storing an interim answer in a Temp table. You...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 11, 2010 at 10:19 pm
Views are more flexible, because you can query them for subsets of rows and columns just like tables. On the other hand, I've seen disasters where developers used...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 11, 2010 at 4:24 pm
afaik? = "As far as I know?"
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 7, 2010 at 10:07 am
thin question authors
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 4, 2010 at 11:13 pm
certificated
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 4, 2010 at 11:12 pm
Just a thought. You still have to do the second step where you update the rows that matched the keep condition. Read up on the MERGE...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 1, 2010 at 8:23 pm
Like table names in a SELECT statement, the audit specification name probably can't be a variable.
Try doing this with dynamic SQL instead.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 1, 2010 at 7:46 pm
I assume your function is returning an integer, so I will ask why you can't define the incrementing column in the destination table as an IDENTITY column. I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 1, 2010 at 12:24 am
You're welcome, Squidder.
Please take a moment to look at how I set up the problem. When you take the time to post...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 30, 2010 at 11:13 am
Viewing 15 posts - 1,591 through 1,605 (of 4,080 total)