Hi and thanks for ur reply i managed to get this working in Query Analyser but i was hoping to use the code in a

Function and i am getting...

thanks for ur reply but its actually ok now i managed to figure it out i just changed the case statement to be

case

when rr.ReferralID is not null then 'View'

when...

thanks for your reply but do you know how or where to go about doin this in C#

that second one solved the problem perfectly

thanks alot its very much appreciated

Tim

nice one that date with the time has solved another problem of mine, your a gentleman thanks very much for taking the time to give me a bit of an...

i reckon thats its thanks very much guys that was fast im impressed

how come u joined the season table instead of using the dates the way i did it?????

thanks...

perfect thats exactly what i need its a simple as selectin a season(past and present) and squad then the players that are mapped to the squad for the season are...

thats actually the way its workin at the moment(fine by me) but some smart man thought to check last seasons players and that list includes this seasons players aswell which...

nice one thanks alot man

ya i def should have know that ill def have to check in here more regularly so and try and get an education

ok cool thanks again man

BOL??? even tho i know im gonna kick myself when u tell me

well im impressed guys theyr both perfect thanks a million its really appreciated...... this query will just be displayed in a datagrid on page fairly basic stuff except for the query

so...

any ideas how i could work out which cols i need to make invisible

im thinkin(hopin) it can be done using c# because all i have to do is display the results in a datagrid

no afraid not

to be honest folks i dont think this can be done usig sql as i need to specify the columns at the start of the statement so how can...