So far so good!

thanks again guys.

Old Hand... i think you did it!!!!!

i just tested it and got what i want... i will keep testing and let you know.

you guys are the best!

thank you

Labneh

SSC Rookie,

Thanks a lot for your reply.

i tried to use your update statement but i don't think it is doing what is supposed to do.

here what is happening

RecNum Patient_ID Patient_FirstName...

Jeffry and Jeff, you guys and everyone here are the BEST

THANKS SO MUCH. 🙂

Man, you are THE MAN!!!

Oh my god, that is exactly what i need.

just a question, what if one of the users doesn't have an extension, so there will be no...

Ramesh,

Thanks man for pointing it out, now i have to redo my query 🙁

Thanks Lynn Pettis.

I'm sorry for not posting it the right way.

i got it... didn't have to use row_number... here it is in case someone is in a crunch

SELECT T1.*

FROM TableName as T1,

(...

would someone help me with this please?

i have been trying but no success.

thanks.

Sorry, it is been a long time but i just got back to work on this project...

when i remove skill_id from the view, execute the statement

SELECT dbo.GRADUATES.ID_NUMBER, dbo.GRADUATES.EMAIL, dbo.GRADUATES.FULLNAME,...

I got it. right click on DTS that you want to execute and click "schedule package" and hit ok.

go to jobs, locate the job that you just created then properties,...

Thanks Jeff,

I figured out how to do it in SQL job by using the "operating system command (CmdExec)"

Now i just need to know how to add another DTS package to...

Adi

thanks alot... removing skill_id worked!!!!

thanks a lot again 🙂

here is the query

SELECT dbo.GRADUATES.ID_NUMBER, dbo.GRADUATES.EMAIL, dbo.GRADUATES.FULLNAME, ...