Viewing 15 posts - 2,251 through 2,265 (of 2,443 total)
Once it's linked, you can just add the server name on the front.
UPDATE [serverName].dbname.author.table
SET ....etc.
Not sure how you do that if you have to look up the names...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 13, 2008 at 8:49 am
Peso (11/13/2008)
I know Itzik Ben-Gan has demonstrated this lately.
The...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 13, 2008 at 8:22 am
gregarobinson (11/12/2008)
They do not, they exist on 3 different servers.
Each row in the temp table...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 13, 2008 at 8:18 am
Look up datetime in BOL for an explanation of why, it's actually returning a value that is compared to 1/1/1900 00:00:00.
You should either pick a different default date...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 13, 2008 at 7:56 am
Jeff Moden (11/10/2008)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 11, 2008 at 7:35 am
do you really need to name the variables differently depending on the parameters? can't you just call it @param1, @param2, @param3, and let the data figure out what's in what?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 7, 2008 at 12:28 pm
rbarryyoung (11/7/2008)
This may well be the "Worst use of SQL, in 20 lines or less" that I have seen in quite some time...
We should post that as a...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 7, 2008 at 12:05 pm
I think you're trying to create too many levels between what you're attempting and dynamic generation of queries and variables.
You also have double quotes around ''@dr_'' just before adding...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 7, 2008 at 11:41 am
toward the end of your code you have this:
'set @DRname = ''@dr_'' + @target_variable2' + char(10) +
'PRINT @DRname '
which is setting @DRname to the string...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 7, 2008 at 5:56 am
technically you would only need len(ltrim(someString)), len ignores trailing whitespace.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 7, 2008 at 5:45 am
rbarryyoung (11/4/2008)
Select V.[Vendor ID], CY.TotalBags as [Bags Last Year], LY.TotalBags as [Bags This Year]
From Vendors V
Left Join...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 6, 2008 at 3:42 pm
Grant Fritchey (11/4/2008)
I'm well and thoroughly confused by what business problem we're hoping to solve here. Or are we just engaged on an entertaining, though useless, mind excercise?
http://www.sqlservercentral.com/articles/Editorial/61757/
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 4, 2008 at 8:10 am
thanks, I couldn't find it either.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 4, 2008 at 6:26 am
Any chance you feel like translating for 2000? I have the same issue, although I'm playing with diagnoses instead of specialty, but I can convert that part.
Like the OP, I...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 4, 2008 at 6:06 am
Grant Fritchey (11/3/2008)Sometimes a programming language lets you do something confusing or counter-productive, but that doesn't mean you should.
dang, there goes my whole philosophy of programming . . .
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 4, 2008 at 6:01 am
Viewing 15 posts - 2,251 through 2,265 (of 2,443 total)