[font="Verdana"]

SELECT

ACCT.CUST_ACCT_ID,

('SHAW') AS SOURCE_SYS ,

(CASE WHEN (SUBSTRING(ACCT.OPR_ACCT_NR,14,3) =...

[font="Verdana"]

Try this...

declare @i varchar(100)

set @i = '''as400'',''cps'''

select * from t_system where systemcode in (@i)

Mahesh

[/font]

[font="Verdana"]I got the answer. At 1st occurance Temp Table does not have data, so it obviously going to Scan the table.

Mahesh[/font]

[font="Verdana"]Solution given by Michael is correct. You must be missing something. Check it out.

Mahesh[/font]

[font="Verdana"]

sachinthamke (6/18/2008)

---

Thanks for u r replay

I m using the stored procedure for storing usp_InsertMaster,usp_InsertDetail. the detail sp used to store the items for sending the XML parameters there is...

[font="Verdana"]Such temporary objects gets stored into TempDB database. you will get it from there.

Select * From sysobjects where Name = '{temp table name}'

Mahesh[/font]

[font="Verdana"]OPENXML will help you in such case.[/font]

[font="Verdana"]

stacya (6/12/2008)

---

I need to be able to import a CSV file into a table via a stored procedure. It would be nice if I could pass the file name...

Jeff, Michael might have intent...

[font="Verdana"]Have you tried nText datatype, I am not sure but it might help you.

Mahesh[/font]

ll take care in future

[font="Verdana"]fyi...

Editor's Note: Link removed.

Mahesh[/font]

[font="Verdana"]Search for PIVOT in BOL.

Mahesh[/font]

[font="Verdana"]Run SQL Profiler, through which you can get all the information you desired.

Mahesh[/font]

[font="Verdana"]I doubt, this is possible through TSQL. Better you go and check the File object (I am not sure, under which Namespace it comes) in ASP .Net. You will surely...