Here is the syntax to get the values you are looking for. Essentially using a CTE to get last year and this year. Since this is using a...

This is a double post. Please reply to original post.

http://www.sqlservercentral.com/Forums/Topic1053496-149-1.aspx

Do you have any table layouts, sample data and expected outcome that you can provide? That will make it easier for us to help you

I took a stab at what you were looking for. I'm not sure what you are expecting for results in the first query, but to get the orphans, you...

Ravi,

in the environment variables edit the Path and move the SQL Server paths in front of the Sybase paths. BCP will find the SQL Server version first that way.

You...

Lutz, I tried your approach, but it took alot longer than the original. When Using OpenXML and shredding into a table variable the result took .073 ms. ...

Thanks, Lutz. I'll try it. I don't need the rownumber. I'm using the identity column from the record just inserted into the header table to stamp each...

Could you post your solution? If anyone finds this thread in the future, they will have a solution. Thanks and I'm happy to hear you found your answer

How about supplying table scripts and data?

I think it has to do with floats. Why are you using floats? If you change them to decimal(10,2), does it work?

How do you determine that these 2 are the same company?

is sybase installed on the machine? If so, check the path, it may be finding that bcp instead of the one from SQL Server.

Your going to have to modify the OLEDB connection to use an expression. Then you can use variables. If you provide the code/package, it would be easier to...

The user is also the owner of the schema. Change the owner of the schema, then you can drop the user.

ALTER AUTHORIZATION ON SCHEMA::[Testuser] TO [dbo]

GO

You can alias the tables for ease of use, but you need to use the correct aliases. For clarification, you should use the 3 part naming convention on all...