Viewing 15 posts - 13,666 through 13,680 (of 14,953 total)
The only thing I can think of doing in this case would be a proc that inserts the desired data, one table at a time, into a temp table. ...
May 16, 2008 at 8:38 am
SSMS launches very rapidly for me. Second or two of splash screen, then straight to server selection and login data.
May 16, 2008 at 8:35 am
Nope. Never seen that one. Did it have any lasting effects, or did it just go away on its own?
May 16, 2008 at 8:30 am
Instead of "Update Table1", use the alias you use in the From clause. That's how I do it (otherwise, it doesn't know which instance of Table1 you want to...
May 16, 2008 at 8:28 am
I guess it depends on how you define "quality".
From the business point of view, I'd rather have code with a solid ROI than "consistent", "standard", "well layed out" code that...
May 16, 2008 at 8:05 am
Matt, he's not talking about getting a running total. He's talking about "pull up the next row if the ID for that row is a set interval higher than...
May 16, 2008 at 7:20 am
Did you look at the startup proc idea I wrote up? That doesn't require any outside process, nor SQL Server Agent.
May 16, 2008 at 7:17 am
Matt Miller (5/15/2008)
Phil Factor (5/15/2008)
May 15, 2008 at 11:55 am
Rudolph Davidge (7/3/2007)
The newbies were impressed by thispost because it was written to impress newbs. Thissaid little that hasn't been said (often) before...and by people who write a lot better...
May 15, 2008 at 7:24 am
I think this may be a case of "mashed potatoes statistics". Lots of just about any demographic group are musicians, or at least want to be and play at...
May 15, 2008 at 7:09 am
I believe it stores the login data and password (encrypted). You'd need to update that.
I always set up an account named something like "SJobs" (yeah, there's a joke in...
May 15, 2008 at 6:59 am
antonio.collins (5/14/2008)
May 14, 2008 at 12:52 pm
As an aside, there are Edit and Delete buttons on your posts that you can use. You should be able to delete the empty post and then edit the...
May 14, 2008 at 12:49 pm
I don't know of a T-SQL way to do that precisely.
This might be something a CLR could do without a transaction. You'd need to get help writing it, but...
May 14, 2008 at 12:48 pm
CypherOz (5/13/2008)
The real life issue is more complex. There are 23 attributes (columns) of which any 1 or more can be overridden at the lower level.
A...
May 14, 2008 at 12:43 pm
Viewing 15 posts - 13,666 through 13,680 (of 14,953 total)