my mistake, appologies

Hi

I think we are talking cross purposes here and its probably down to my explaination skills (or lack of)

This is a request for a hospital and i have to identify...

Thanks for your reply,

this only gives me the the adm_no's where admission_date and discharge date are the same.

For Example: i need to look at previous admissions for each...

many thanks for that.

Thanks for your advice, I think that has sorted the issue. i changed your >= and <= to >= and <= and it seem sto have worked.

I have sorted this now, thanks for you advice.

Hi, many thanks for that, works fine.

i now need to put something in place so that if the date is >= 30 mins ago then a stored proc will...

Many Thanks, I posted a thread a couple of days ago about this but i think i over complicated the matter. Have a look if you want, you will...

Sorted now, Cheers

Many Thanks for your helps. Have sorted the issue now with the original source file.

Cheers, this works a treat, exactly what i was after. I wont be getting an A as this is for work, we are installing a Data Warehouse and I'm fairly...

thanks for your reply. all sorted now.cheers.

He is my boss and asked me to reaseach also. Small world.

Sorted now Thanks anyway. I have a new question if you want to take a look:-):-):-)

http://www.sqlservercentral.com/Forums/Topic988072-392-1.aspx

Cheers