Hi All,
Can someone suggest how to insert default values in Columns when the select query returns NULL Values?
Currently I'm using the below script:
INSERT INTO [dbo].[Test] ([time1])
SELECT isnull(c.[time2],'1753-01-01 00:00:00.000') from [dbo].[Test1] c
where [time2] allows Null values and [time1] does not allow Null values.
but I have 100's of fields and multiple tables which is taking too much off time.
Thanks in Advance,
Srinivas Maddula.
