Best (10/19/2007)

---

I have two tables

Table A

Table B

Both tables have the following four columns

School Code

School name

Grade

Year

i want to insert values from table B into table A

Table B has the following...

My apologies about that. I will make sure this doesnot repeat.

Your frontend (Visual Basic) would not really know whethere you have used a temp table or if you are fetching data from the original table. Its all inside your stored...

What do you mean by your local account. Are you talking of Windows authentication mode? Also make sure the user is member of the users defined on your remote server...

You can definitely restore a 2000 database backup on SQL Server 2005. While restoring go the options tab and check if you have defined the correct locations for creating mdf...

Why don't you modify your stored procedure to accept the filter date and run the sp and display the retrieved data on the report. Sorry if I am missing anything...

Abhijit, Hope you got what John meant, you need to have your dynamic order by column as an item your SELECT statement as you want to retrieve DISTINCT rows grouped...

Abhijit Just make sure you use

EXEC(@sql)

OR EXEC sp_executesql @sql

in the above syntax.

I don't think braces would really matter. It should work even without braces. But as a safety you can try it with braces.

Hello David,

Thank you for the solution. However I completed it using a cursor and Select statement and seems to be performing fine. I know that Cursors kill performance however I...

Thanks for the reply. I actually did it using a cursor and charindex. However I am wondering if this could be accomplished without using a cursor.

Are you looking at something like

select c.Id,

c.[name],

c.active,

a.[name] as attribute

from

component as c

join

attribute as a on c.attributeid = a.id

inner join

(select max(c.id) as cid ,c.[name],a.[name]...

I concur with Lowell, Editplus is very decent tool for code and it has templates integrated which can be customized aswell. Trial out the trail edition of Edit Plus.

Yes, first check if your user has the execute rights on the stored procedure. Second you just need to give the name of your stored procedure and define your paramters...

Thank you David.