Actually ExhibitorReport is a view and it selects lot many columns event if CompanyId is int type this view has other columns who have data more that 8 k. is there...

Hi,

Solution Worked.

Thnaks For The Support

Hi,

"select convert(char(10),getdate(),8)"

Good enough, but I need Am/Pm associated  and do not want to use Left or right function

Hi,

If Data is non numeric :

Insert your record without PK_CatId and create a trigger for insert which will update newly inserted record with [logical] Id.

If Data is numeric : Create The...