You really have not supplied enough information for us to help. We would need to see the code from the report as well as the complete stored procedure. ...

This works if your data is always 1 and 0.

Declare @table table(id int, colA int, colb int, colc int)

Insert into @table

Select

1 , 1 , ...

Where does the list reside? Do you ever have a middle name/initial or Suffix? Ideally the database design would change to have separate columns for first, middle, and...

So were you running the update against the table while the SSIS package was running?

I'd use varchar(max) or nvarchar(max) not text/ntext. If it fits on the page SQL Server will keep it in the table, if not it will store it off the...

No one can accurately answer this question without seeing the code you are using.

Make sure you do Select Object_name(object_id) in the database you have the deadlock in. It returns NULL when you execute in a database other than the one the object...

Can you post the .NET code as well? There doesn't appear to be a problem with the SQL.

Yes, I would have expected that which is why I used the "[]" around the linked...

Was the omission of schema a typo or is it missing?

Can you do a Select * from [DEV001\SQL2005DEV].myDataBase.SCHEMA.myTable across the linked server?

Is this a linked server? If not you do not need the server name. You are also missing the schema in the 4 part naming. You need...

You need to put the t2.col1 is null in a where clause not in the join condition like this:

SELECT DISTINCT t1.Col1, t2.Col1

FROM Table1 t1 LEFT OUTER JOIN Table2 t2

...

I don't know query syntax for teradata, but you need to use an expression in your query. Something like this:

="Select columns from tables " & IIF(Parameters!State.Value = "ALL", "",...

Please see the links in my signature to see how to post to get better answers. Some DDL for the tables would be helpful. I think you are...

Well you can't do this in a case:

WHEN '3' THEN ...