For the main statement the data is on a SQL Server 2005 for the other on its on a MYSQL Server.

sorry if thats not what you needed. iam still trying...

thanks, will give that ago

OK, so iam not starting another post i thought i would ask this here.

the following code returns studentID and some other fields

-------------------------

DECLARE @sql varchar(1000) DECLARE @stat varchar(10) DECLARE...

thanks for all the help. seams to be working now

just need to figure out how to use the id it returns in a...

Sorry about this. Iam still trying to figure out how all of this works (haves done anything like this for over a year)

did u mean do this?

------------------------------

DECLARE @sql...