Cool, It worked! Thanks

Thanks,

Also I noticed the interface has changed. Can you help me with the editor. what set of tags should I use for displaying code ?

it used to be ...

What do you think of this ?

ALTER TABLE <Table_Name>DROP CONSTRAINT <constraint_name>

--Then alter the size of the column 
ALTER TABLE [DataExtract].[dbo].[ControlSetting] ALTER COLUMN...

Done!

IF OBJECT_ID('tempdb..#Hospital') IS NOT NULL DROP TABLE #Hospital;

Create table #Hospital ( mem VARCHAR(100) , vd VARCHAR(8) );

INSERT INTO...

Folks.. No need to reply... All set, I just modified the code a bit , it works.. Allows you to group by ID

if object_id('tempdb..#t')...