Multiply by -1.

It looks like you are attempting to insert the comma separated values from your variable into the temp table correct? If so, this is a great job for a...

I would say the best place to start would be in BOL. Type in Stored Procedures and you'll get a myriad of topics to look at. Start with the...

It also really depends on what you mean by valid? You could look at the dependencies to make sure they all exist for that SP.

select object_name(so.id), object_name(depid)

from sysdepends sd

...

Yes, Jo. You can use the /3GB switch and set the Max Server Memory to use 3 GB without enabling AWE.

Wow, I'll try to keep the ranting to a minimum. Erin, you as the development DBA are the data storage and retrieval expert. That is the value you...

I agree with Gail here. That is why I asked the question initially. The simple fact is that 'if it's not broke, don't fix it'! You could...

What is your server OS? If you have Windows 2000 Advanced Server or greater, run sp_configure to set your max server memory to 3 GB. The /3GB switch...

Try a FULL OUTER JOIN:

DECLARE @Table1 TABLE (Col1 int)

DECLARE @Table2 TABLE (Col1 int)

INSERT INTO @Table1

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5 UNION ALL

SELECT...

Is this a one-time operation or a process that will be reused often? How large of a file are you looking at?

Here you go Mark:

SELECT t1.Name, t1.Date, t1.Value

FROM Test t1

INNER JOIN (

SELECT name, MAX(date) as...

A bookmark lookup means that SQL Server must read from the data pages to handle the query. The only way to avoid a bookmark lookup is to use a...

Yep, I second Grant. At least give us your first stab at this and tell us which requirements you are having a problem handling. Help us help you...

You are correct. There are 10 ways to skin a cat. I've just skinned enough cats to prefer the fastest way because their guts stink real bad. ...

Who did you say was nit-picking?? 😀 We all know that your solution works for you cuz you told us so more than once. I am simply...