July 20, 2012 at 11:48 am
Hi all,
I want to import a set of data into a table daily, and I want to be able to create a new field during the import which has a default value. For example, I want to create a field called "Reporting_Date" which just sets a default date of 1st of the current month (07/01/2012) for every row in my data.
How do I achieve this?
Thanks
July 20, 2012 at 11:56 am
Alter table <TableName>
Add Reporting_Date datetime not null default(dateadd(month,datediff(month,0,GETDATE()),0))
July 20, 2012 at 12:45 pm
You want to add a new column every day? Or do you want to change the default every day? Seems like it would be easier to do this in your import script instead of changing the table every day.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply