I have to add also that after microsoft realized that processing XML on the back end could not be as efficient as processing it in the middle tier they included...

can you print the resulting sqlvariable before executing it ?

I would not use a temp table if the final result is

Pupil 1, 6, Teacher A, Teacher B , ...

You Can construct the Teacher A, B, .. into One Column...

bcp uses a format file to handle schema configuration as long as you pass an appropriate format file in the command line it should be ok

sorry I was not very clear. you should cross join students table with the Numbers Table (NO COLUMns are linked!!) the end result is the CARTESIAN product of both tables,...

the reason for which the Mapped drives won't work is because sharing information is PROFILE related and the account you are using (SQL SERVER) is a SERVICE account so that...

I have to admit that i like the tabbing idea but is going to be a little complicated is there are NULLs on the way and the number of columns...

VERTICAL tab = CHAR(11)

horizontal tab = CHAR(9)

some bad news for you here sqlserver stardard or enterprise won't install on windows 2000 Pro!

you would have to use the developer edition just $50

HTH

Make the Qry so that it maps a global variableto a parammeter like

Update tasble set x= 'a' where y = ?

then map ? to a global variable

AFTER...

Actually you want to convert EACH record into 75 !

that is easylly accoplished with a Numbers table that contains numbers from 1 to 75

Select StudentID as Student,

...

couple of suggestions:

First your code:

quote:

---

 

DECLARE@Count int,@ID intSELECT @ID = ID FROM MyTable WHERE blah, blah, blah...

because the date part is missing Access is setting it as 1899-12-30 and sql will do the same using 1900-01-01

if you don't care about the date part just dont use...

Sure just install connectivity only from the setup or mdac with the appropriate version!!