Experts..

I am struggling to fix...can any one please help....?

It works. I just checked. just copy from here and paste in your code.

EXEC('Insert into temptable1'+ @sp_id + ' values (10,''XXXXX'')')

Try and let me know.

--Prasad

Hi,

It's a minor mistake. you might overlooked at it.

change the code to

EXEC('Insert into temptable1'+ @sp_id + 'values (10,''XXXXX'')')

It works. by mistake, you have removed 1 in the insert...

As per the recent experience i had with one of projects, After loading to production one procedure started taking more than 9 minutes to return result set. when i checked...

--Sorry..the Script provided by me is to find out the spaces of Databases..hence am rolling back my posting.. ---

Nope tomm..The query can do much more than just getting max..

By replacing 1 with 2 in that query will fetch second maximum,

By replacing 1 with 3 in that query will fetch...

I got the solution...Its started working after i altered the DB

ALTER DATABASE Deals

SET ARITHABORT ON

GO

One more point to be added...

Recently i have added a column in the main table and that column was derived column and wil concatenate the two columns values to popualte....

Try using this from QA.

Declare @vchrBulkCmd varchar(500)

SET @vchrBulkCmd = 'BULK INSERT TblCsv

FROM ''c:\Testcsv.txt''

WITH ( DATAFILETYPE=...

Can you paste the code here..

YOu can use the following sample code:

am not sure about  the query you are using, but when navigations required from one page to another, have another column in the table with auto increment, then when you...

This way we are explicitly dropping FK constaraint before dropping the column..This is always possible. but if you see th example i have quoted in my first post, In oracle,...

Use master

select name,filename from sysdatabases

Starnge..Its working fine in 2000 when i tried. can you try running the query again?

The code i tried is

Declare @NAMEX varchar(100)

Set @NAMEX = 'S'

Select @NAMEX = @NAMEX +...