"sh0t2bts" <sh0t2bts@hotmail.com> wrote in message
news:Ok1UhOHZEHA.556@tk2msftngp13.phx.gbl...
> Hi,
>
> I am importing data from different tables the table don't have any the
> current days date on them or any date that I can use, what I want to do is
> assign a date to a field / column for each imported row so that I know
what
> date the data was imported.
>
> I did try to use the below code but a view would not allow this "I know
> relies why" so how could I assign the current date to a columns for each
row
> I import from the other tables?
>
> DECLARE @MyDate DATETIME
> SET @MyDate = { fn CURRENT_DATE() }
>
> Select @MyDate, next_field
>
> Hope this makes sense
>
> Cheers
>
> Mark
>
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:OK5Bb0HZEHA.2388@TK2MSFTNGP09.phx.gbl...
> Try using GETDATE(): SET @MyDate = GETDATE()
>
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "sh0t2bts" <sh0t2bts@hotmail.com> wrote in message
> news:Ok1UhOHZEHA.556@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I am importing data from different tables the table don't have any the
> > current days date on them or any date that I can use, what I want to do
is
> > assign a date to a field / column for each imported row so that I know
> what
> > date the data was imported.
> >
> > I did try to use the below code but a view would not allow this "I know
> > relies why" so how could I assign the current date to a columns for each
> row
> > I import from the other tables?
> >
> > DECLARE @MyDate DATETIME
> > SET @MyDate = { fn CURRENT_DATE() }
> >
> > Select @MyDate, next_field
> >
> > Hope this makes sense
> >
> > Cheers
> >
> > Mark
> >
> >
>
>