Viewing 15 posts - 2,191 through 2,205 (of 2,443 total)
blandry (1/6/2009)
---------------------------------------------------------
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."
January 6, 2009 at 6:48 am
Jeff Moden (1/1/2009)
Piotr Rodak (1/1/2009)
Not earlier than yesterday I said to myself 'one day I have to get those dateadd-datediff calculations...
---------------------------------------------------------
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."
January 5, 2009 at 6:23 am
In case someone's reading this and doesn't have the U.S. English default set on their instance, don't forget to check @@datefirst to make sure which day starts your week.
You'll...
---------------------------------------------------------
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."
December 31, 2008 at 9:38 am
Can I ask why you're doing this?
Is this a one-time y/n determination (in which case, why add a new column, just check as previous poster showed whether something exists)...
---------------------------------------------------------
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."
December 31, 2008 at 7:11 am
Thanks for the blog post Gail, I don't use error-checking and transactions as much as most, since I can't write to anything but Tempdb, but wasn't aware of these issues...
---------------------------------------------------------
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."
December 31, 2008 at 7:05 am
OR . . . . (you guys are making this harder than it needs to be)
Copy . . .
Paste . . .
😀
---------------------------------------------------------
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."
December 23, 2008 at 7:03 am
Scott Arendt (12/23/2008)
I bet there are a large number of people who bowl regularly who have no idea how to score a game by hand.Scott
Score by hand? 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."
December 23, 2008 at 7:00 am
Two comments -
Steve - interesting model of the solar system you have posted in the article, haven't seen that one before 😀
Everyone else (except Darth & Ninja, you guys...
---------------------------------------------------------
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."
December 22, 2008 at 7:04 am
blandry (12/19/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."
December 19, 2008 at 6:25 am
Chris Morris (12/19/2008)
Someone said beer I swear...Nicest beer this week was Blue Moon wheat beer from Denver, CO, purchased from Sainsbury's, Reading, UK.
My sister-in-law is crazy about that stuff. Can't...
---------------------------------------------------------
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."
December 19, 2008 at 6:24 am
I'm partial to the displays and computers seen in Final Fantasy: The Spirits Within, built from lifeforce.
While fictional, it does seem to me that it could be not-so-far off...
---------------------------------------------------------
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."
December 19, 2008 at 6:01 am
Thanks, gotta run tonight, but I'll try Profiler tomorrow. Haven't actually used it before, so that'll be fun, I enjoy learning new tricks.
Thanks for the suggestions, I'll let you...
---------------------------------------------------------
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."
December 18, 2008 at 3:25 pm
It'd be a long shot, that's a table for a termed vendor, on whom I'm doing analysis, it didn't exist in the tempdb before I ran the script, and 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."
December 18, 2008 at 12:54 pm
Bummer, there goes my grand scheme. 😉
just running inserts, sample below (minus the data)
INSERT INTO ##UCHP (status,[Name],Provider,DOS,[Claim Amt],[Paid Amt],[Paid Date],[Check Number],[Claim Number],[Payor]) VALUES ( ... )
---------------------------------------------------------
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."
December 18, 2008 at 11:59 am
Well isn't that a nice, fuzzy thought? All I did was
DECLARE @chaos varchar(max)
SELECT @chaos = replicate('DROP DATABASE ' + (SELECT name FROM sys.databases WHERE ID = N) + '...
---------------------------------------------------------
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."
December 18, 2008 at 11:38 am
Viewing 15 posts - 2,191 through 2,205 (of 2,443 total)