Allen-

Thanks for your response. I tried this already. It did not change anything. I am running Windows 2003 and SQL Ent edition. SQL patched to 3a....

jxflagg- I thought about this option. But was wondering, with this approach, how to I dynamically pass the file name as a parameter to the DTS job?

set @sql='update pivot '

+'set date_'+cast(@cnt as varchar(3))+'=@date+'_,flow'+cast(@cnt as varchar(3))+'=@flow,'

+'storagewater'+cast(@cnt as varchar(3))+'=@storagewater '

+'where pivot.division=@division and pivot.district=@district and '

+'pivot.FacName=@FacName'

gljjr- Thanks for the help. My problem got solved when I replaced the @@IDENTITY with the SELECT SystemId FROM INSERTED.

Thanks again

I am convinced, I still need to have the data/index/log/tempdb on separate arrays even if it is a SAN. I will do some more study on the SAN and...

Thanks a lot for your responses. Our infrastrucutre team made a new decision today that they would be getting SAN for all the servers (including my DB server). ...

HI Skrilla99-

Thanks for your time. I was talking about error handling in T-SQL and not in the application program. I went through the articles you sent...

Guys, thanks for the help. We figured it out at last. It is the issue with Firewall. The port which we configured for SQL Server to listen...

Thanks for the responses. I cannot connect with the IP either. And on one of the client machines, I put the static IP in the hosts file. ...

Neil- Someone else suggested the same to me. I will look into distributed views and get back to the forum. Thanks for the direction.

Thanks for your time SQLBill. So I have to do this in every query, for every table. That is going to be a nightmare for the developers. ...

I found the necessary information on MSDN. Not sure how to close the thread. So please ignore my question.

Thanks

Thanks for the reply. The number of users is not an issue in our situation as there will be at the most 3-4 users at any instance.

Thanks a lot for the responses. There are some other reports that need similar queries. So I created a table with the dates and I am left-outer joining...

Thanks a lot Chris. This table was what I was looking for.