Thanks for your help. Its working 🙂

I've tried with left join to get the detail and got the results. Is this correct?

CREATE TABLE [#Employee](

[EmpID] [int] NOT NULL,

[EmpName] [varchar](50)...

Hi,

Here the txt file will be created in server. Is it possible to create a file in local machine?

Hi,

Thanks for your reply. But dont have a network connection to the local machine.

Is it possible to create a file in local machine using batch file?

Thanks

Ram

Hi i think u missed the dbname and owner name please try the following query.

exec master.dbo.xp_cmdshell 'bcp "SELECT * FROM [dbname].dbo.customer for XML auto, ELEMENTS XSINIL" queryout...

Thanks David,

Actually the XML file is

<Is>

<I D="122334" DFmt="mm/dd/yyyy" ExpM="4545" N="" ExtD="09/17/2010" Id="1" />

</Is>

Now i only i got the correct format. Thanks for your help again.:-)

Regards,

Ram

Hi all

Thanks for your post. Could you please try with the following data..

I couldnt get the expected result using the above queries.

select 1, 'Excel',2000, 13 union all

select 2,...

Hi,

Thanks for youy replay. I am using sql server 2000.

Hi All,

Thanks for your precious solution.

Regards,

Ram

Hi,

Thanks, This query is working fine but i cant use this query. Because my table having only "total_seconds" column and this table contains the values as follow

...

Hi,

Thanks for your replay. I have the total seconds.

sum(datediff(second, '01/15/2010 10:35:51', '01/15/2010 11:05:51'))

Using this second i have to display like '0:50'

Regards,

Ram

Can u try this one!

select

a.courseId,

a.trainingId,

"nomFR" = case when coalesce(a.nomFR, '') = '' then b.nomFR else a.nomFR end,

"nomEN" = case when coalesce(a.nomEN, '') = ''...

Hi,

Thanks for your help. Its working fine.

Regards,

Ram

Hi,

Thanks for your reply. Your qury is working fine. But I've used to the same query with replace function.

declare @l_store_list varchar(50)

...

Hi,

Thanks for your help. Its working fine.

Thanks for ur reply.

It will work for the below string

eg:...