Viewing 15 posts - 3,871 through 3,885 (of 4,080 total)
I can't run this to look at your query plan, or even the results of all your subqueries,
but here's something to try in your update. It looks...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 11:50 am
Kiran:
"Full-text search delivers enterprise search functionality" is just marketing hype ("hype" NOT "hyper") that means all users can use it (if you have first built full text indexes and queries...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 11:16 am
At least this one didn't have URGENT URGENT URGENT in the topic header. 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 11:12 am
Applause... thunderous applause.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 10:24 am
I may have to apologize at this point. For the last 20-30 minutes, I've been browsing through your extremely procedural code. I can only say 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
December 29, 2008 at 9:30 am
Thanks, Kenneth. Maybe it's holiday silliness, but I kind of like the idea of a post topic being simply "Can we?"
Yes, we can.
Bob (the Builder)
P.S. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 9:02 am
.... and if I could pick numbers, I would be retired and skiing in Park City or Alta right now, so you would have never seen me on this forum....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 8:53 am
Matt: It's a gift. I am but a tool of a Higher Power 😉
If you see my post above, we just had a touch of asynchronous communications....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 8:51 am
Dave, sorry I was editing my post when you looked a minute ago. The cut and paste of the code looked really squirrelly because of tabs settings. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 29, 2008 at 8:34 am
Sure. The technique below works fast for concatenating values in any column. The cte isn't required, it just makes the final query a little easier 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
December 29, 2008 at 8:19 am
SQL 2005 supports TRY and CATCH logic.
BEGIN TRY
SELECT TOP 500 Results.VPath AS URL
FROM OPENROWSET('MSIDXS', 'PSAJournals';''; '',
'SELECT Rank, VPath FROM...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 26, 2008 at 10:00 am
Are you trying to select the detail for whichever row has the max date? If so, you first need a CTE or subquery that does a summary query...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 26, 2008 at 9:49 am
Since you are doing this in dynamic SQL, you should also be capable of writing the dynamic SQL to create a variable for each column your are selecting from, 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
December 26, 2008 at 9:35 am
You're welcome, Rich.
Dynamic SQL is the only option I know of to handle variable table names, including identical table names in separate DBs. Good luck.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 23, 2008 at 9:47 am
All any of us know is what you post 😉 I did notice the declaration in block 2, and was in the process of revising my...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
December 23, 2008 at 9:27 am
Viewing 15 posts - 3,871 through 3,885 (of 4,080 total)