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. ...

SSMS launches very rapidly for me. Second or two of splash screen, then straight to server selection and login data.

Nope. Never seen that one. Did it have any lasting effects, or did it just go away on its own?

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...

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...

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...

Did you look at the startup proc idea I wrote up? That doesn't require any outside process, nor SQL Server Agent.

Matt Miller (5/15/2008)

---

Phil Factor (5/15/2008)

---

As you know, Steve, I'm a 60's blues (and folk) guitar player, though now I tend to specialise in playing the Uke. Perhaps I ought to...

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...

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...

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...

antonio.collins (5/14/2008)

---

Personally, I'd keep it simple and add primaryTicker to the Firm table. Then a simple fkey relationship will meet your business rules and it should be dead simple...

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...

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...

CypherOz (5/13/2008)

---

Thanks for the input.

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...