putting "\" before and after my value worked for me as well.

SOLUTION: UPDATE STATISTICS on key table used within the query. My query returned in < 10 seconds where before I was killing it after 10, 20, 30 minutes...

One more solution without case statement found in another forum,

SELECT stuff(stuff(replace(str(run_duration,6,0),' ','0'),3,0,':'),6,0,':') FROM sysJobHistory

How to find the edition, service pack installed information for Analysis Server 2000 version?

Thanks,

Jagga

Thanks Adi,

This is what I was looking for.

Thanks for the answer.

Thanks Chris, but this will create new table not inserting into a existing table.

Regards

I tried the below one.

SELECT  RS.*

FROM

 ( SELECT

  DISTINCT EmployeeId

 FROM

  EmployeeBill ) AS EB

CROSS APPLY

 (

 SELECT TOP 3

  E.EmployeeId,

  E.EmployeeName,

  E.EmployeeAdd,

  BILL.BIllId ,

  BILL.BillAmount ,

  BILL.BillMonth

 FROM

  Employee E

 INNER JOIN

  EmployeeBill BILL...

I come up with a solution (writing single SQL Statement) using CROSS APPLY Operator available on 2k5.

(The APPLY operator allows you to invoke a table-valued function for each row returned by...

Hi,

Try this,

Exec matser..xp_cmdshell '"\\Directory Name\BatchFile.bat"'

Let us know if this works for you.

Regards,

Jagga

 Would in be possible to import these files into the DB ?

It is possible. I hope you are using data pump task to load the data into the DB. What...