Actually I do not have the permission to the server remotely. Because it's a database server I won't get access to the folders in the server to store .tbl files.

How do we get the sql server agent service account...I mean in which way we can it

Could you please send to my email ID.

asabnavees@gmail.com

Can any one answer me please.....

Thank you ver much...I am looking to modify the query as below

select distinct t1.ServerName, t1.[Application ID], t1.[Application Name], t2.VP1, T2.VP2, T2.SVP, T2.[DC2015 Move Group], T1.[System Type],

T3.Line, AppServerSource =...

Hi..Once again thanks for all your support. but my lead ask me to modify the query like below. I tried it but it giving error. Could any one modify it...

Awesome......I use inner join instead of Left join

Now its working fyn...Thank you very much

Please check this below one more time ...i give clearly

It is taking the one first row it should be take entire rows.

UPDATE T1 SET [September 2012 Billing File] = CASE...

Please check this below one more time ...i give clearly

UPDATE T1 SET [September 2012 Billing File] = CASE WHEN T2.[Application ID] IS NOT NULL AND T2.[ServerName]

IS NOT NULL AND...

Hi All,

Can anybody help me out from the above issue.

Hi,

Thaks for you prompt Reply. Please check the below script. I execute the script by batches but during the below single statement tlog is getting full.

''update tblGatewayPersons SET ImportDataXML_NT =...