ok thanks I have changed the errors it the procedure . Im trying to create a procedure that if either one of the parameters are null then the other one...

Thankyou thats the logic I needed SSCoach

Yes these are the only tables that I had to make

yes I wont lie to you it is homework. I was given a task to design a employer student coop database where an employer s match a student with a...

Eirikur Eiriksson when i try the query that way i get an error saying dbo.orders.customerid is invalid in the select list because

it is not contained in either an aggregate function...

I appreciate the effort you took to show me examples The last one worked for me thanks so much

i will certainly check that out but the requirement was to experiment with the cast function so i will keep trying thankyou

Thanks it worked like a charm 🙂