Viewing 15 posts - 16,711 through 16,725 (of 18,926 total)
Then this answer doesn't need to be typed
.
June 15, 2005 at 12:20 pm
I think you'll have to come up with both versions of the code and see which runs faster.
My guess would be that 3 derived tables joined with the facility id...
June 15, 2005 at 12:15 pm
Case cannot return 2 different values. You must use this technic :
Order by
Case when @sort = 'Col1' Then Col1 ELSE NULL end
, Case when @sort = 'Col2' Then...
June 15, 2005 at 12:07 pm
Maybe but since it won't be in our accepted target answers you'll have to rethrow it untill you get it right.
June 15, 2005 at 12:00 pm
Not exists would be faster than not in for this task.
June 15, 2005 at 11:58 am
Double posting no, it's like spam and we don't need that.
Right forum, I guess you can point out the fact once, and then they have to do it themselves
June 15, 2005 at 11:46 am
Lucky b@$t@rd. My vacations are in one month.
June 15, 2005 at 11:44 am
Let's decide this one with a quarter.
Heads I win, tails I don't lose.
June 15, 2005 at 11:42 am
Sure, but if we don't see that post, how are we supposed to tell them that?? ![]()
June 15, 2005 at 11:34 am
I meant : Can't you simply copy the query from the vb package and use it on the server?
June 15, 2005 at 11:31 am
That's why I was asking for clarifications
.
Are you back from vacations? Looks like you've been away forever.
June 15, 2005 at 11:30 am
(from db1)
Insert into [db1.]dbo.TableName (col1, col2)
Select Col1, Col2 from db2.dbo.TableName2
June 15, 2005 at 11:29 am
Simple solution :
Copy the images on a shared drive on the server.
Save the path each the said pictures in the database. Send the path along with the rest...
June 15, 2005 at 11:26 am
Can't find anything on global variables that would ressemble @@isolation.
June 15, 2005 at 10:20 am
Viewing 15 posts - 16,711 through 16,725 (of 18,926 total)