"Dummy" column in SELECT

[djj55]

Hello,
I would like to add a column to a select statement that is smalldatetime but I want it initialized it to null.

SELECT DISTINCT myCol1, myCol2, NULL AS NEW_SDT 
INTO #Temp 
FROM mytable

as NEW_SDT would not be a smalldatetime this does not work.

I can create the table before the select but would rather know if there is a way to create the column on the fly.

Thank you,

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[gmmastros]

Did you try converting the null to DateTime?

Select Convert(DateTime, NULL) As NEW_SDT

I don't know if this will work, but it's worth a try.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Use cast or convert function to convert NULL to the appropriate type.

PluralSight Learning Library

 

[djj55]

Thank you, works great.


djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!