When you do the insert:

INSERT INTO faster.SAttribute (sashusername)

SELECT @shusername

you don't insert a value for SATable, yet you are looking for a value in the second update. It won't find...

Change the port it listens on then firewall off that port?

Remove the last comma on the line above the 'where'.

NOOOOOOOOOO! I have them plastered all over my cubicle. I use them as teaching aids for end users. (OK, read the comic. This character is you and...

It's very probable that what you are seeing is data left on a page which has been marked as re-usable, but is part of a larger allocation unit (extent) which...

I am quite surprised. I've never heard of anyone who could open a backup file and read it in notepad. Where did you learn how to trace the...

And what happens if the Status is NULL? Does your code deliver the correct answer? That's all Jeff was trying to point out. He's trying to make...

Just leave the date off if the date column is nullable. If it's not nullable, you should specify a default for it.

10.0

6

1 SQLCHAR 0 100 "\t" 1 Agent SQL_Latin1_General_CP1_CI_AS

2...

If all you want are rows that match, change the outer join to an inner join.

Are you executing this in SSMS or some other tool? Can you run a profiler trace when you execute this so you can see what the server is actually...

How are you executing the batch? It wouldn't, by any chance, be dynamic sql? If it is, you might want to make sure that the variable that holds...

Is @logicaldate defined as a datetime? If so, shouldn't the convert be:

convert(nvarchar(256), @LogicalDate, 102)

You have to change all of those *= to ANSI join syntax LEFT OUTER JOIN (or RIGHT OUTER JOIN as the case may be.

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/931d668b-d02b-4b0d-abda-b9dcaa689d62

Doesn't really look like there are any...

DOUBLE is a floating point datatype which is approximate.

http://msdn.microsoft.com/en-us/library/ayazw934.aspx

If you declare it as numeric or decimal, it may work more precisely.

In the description column, are the words you need delimited by something? If you have:

ford, 4-door, all wheel drive, etc....

you could parse the list by the comma and put each...