Craig & Michael, yup inserting a NULL in datetime clmn returns a NULL and empty string returned 1900-01-01 00:00:00.000.

So what I need is to replace all 1900-01-01 00:00:00.000 with NULL,...

I have a column of type datetime.

Many of its value are NULL's but in the column it appears as 1900-01-01 00:00:00.

I know that 1900-01-01 00:00:00 is the default for datetime...

Kevin, thank you so much. It works great. I've learnt something new today thanks to you.

Hi Kevin, Im going to give you a code a try .Thanks

Thanks Sean, thats what I have started doing.Wanted to make sure that I did not miss on any other alternatives on doing this.

Our data is incredibely specific to only those data types. I have taken care of the insertion to Table B based on DT_ID column from Table C in another...

Thats really wierd. Coz Im getting the following error message

Results Tab

IDDt_ID

11

Message

Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to float.

Ive even dropped all 3 tables...

Hi BitBucket, Totally agree its not easy for one to help if one does not have the schema and sample. I have attached it.

Kindly advice.Thank You

Anybody has any Ideas? Im stuck on this and cant proceed.Plz Advice

Yes Dan I am aware of that but I have no control on the design of the table.

I got it to work

SELECT a.NAME,d.[Type],t.[Out_Type] FROM A a

INNER JOIN D d

ON a.Name=d.Name

INNER JOIN [TYPE]t

ON t.[In_Type] LIKE '%' + d.[Type] + '%'

SELECT a.NAME,d.[Type],

CASE

WHEN t.[In_Type] LIKE '%' + UPPER(d.[Type])...

Hi Dan, Thanks for your prompt reply.Could you show how this can be done ?

You can try this, Still figuring out the dbRole column

SELECT

[Login Type]=

case sp.type

when 'u' then 'WIN'

when 's' then 'SQL'

when 'g' then 'GRP'

end,

sp.Name as srvLogin ,

sp2.Name as srvRole,

dbp.Name as dbUser,...

What about this ?

DECLARE @i INT

SET @i =0

WHILE (@i <=6)

BEGIN

SELECT DATENAME(DW,DATEADD(dd,+@i,GETDATE())) + ' ,' + CONVERT(VARCHAR(50),DATEADD(DD,+@i,GETDATE()),101)

SET @i=@i+1

END

Results as

Thursday ,04/07/2011

Friday ,04/08/2011

and ....

There is a Send Mail Task in SSIS which might be able to help you deliver the SSRS file [.rdl], In the Mail tab,

browse to the location of the rdl...