What's wrong with #tables?

You can populate one or more tempopary tables and call any SP on any database within the same server. These tables will be visible for that SP.

If...

I know.

I mentioned in this thread that my split function using loop was 10-15% faster than Jeff's option using table Numbers.

But it's still - single user approach.

Remember: when you run...

Robert, to exclude any doubts do SELECT ... INTO #SomeHashTable.

No time on passing data spent in this case.

Igor, you did not mentioned which year technology used for you HDD.

I guess...

You can update any kind of view if you have appropriate INSTEAD OF trigger on it.

Actually in such case UPDATE will not do anything but invoke the trigger code.

What will...

It's so nice to get an answer from someone really smart!

Wanna know REAL reason?

Just to prove the point that normal-minded developers can design and run a data centric system without yours, bloody annoying SQL geek, stupid suggestions and intrusions, the...

If the whole point is to find some use for XML then, well, it's quite useful.

But if you are looking for best solution then using of XML does not make...

Jeff, there is no reason to get mad.

Just change your attitude.

As for me, I open topics from this nick only when I feel...

I believe this would be cleaner and faster option:

Delete mt

From mainTable mt

inner join deleted d on d.formID = mt.formID

inner join drugMap dm on dm.synonymID = d.synonymID AND mt.drugID = dm.drugID

inner...

Why SUM???

Why not simple COUNT?

And you don't need ISNULL for COUNT.

To make thing even worse for you lets try to perform second arithmetic operation:

declare @fOne float, @fThree float, @fFraction float, @fSeventeen float

declare @dOne decimal(12, 6), @dThree decimal(12, 6), @dFraction decimal(12,...

msalomon,

try this:

declare @fOne float, @fThree float, @fOneThird float

declare @dOne decimal(12, 6), @dThree decimal(12, 6), @dOneThird decimal(12, 6)

SET @fOne = 1 SET @fThree = 3

SET @fOneThird = @fOne / @fThree

SELECT @fOneThird...

If you use FLOAT for calculations the result could not be more precise than FLOAT precision.

So, when you're storing FLOAT result as DECIMAL you fool yourself.

Yes, DECIMAL pleases your eyes...

Little correction:

select @NameList = isnull(@NameList + ', ','') + Name from Customer

and you don't need the next statement cutting off last comma.

You know, I would not probably mention this "minor improvement" if I would not see (with my own eyes) Reserved Space = -400MB.

Quite useful information, right?