neat, i will check that out,

thanks a bunch!!!

and yes, i check my previous post and still dont know how to post a table as a table here and not as code :doze:

i meant i didnt know how to create a table as a table here :-D:-D

not a table in sql...

anyhow i double checked and it was not exactly what i...

i wrote this, what do you think?

Select

t.dates, t.customer, t.ind_1, t.ind_2, t.ind_3, t.ind_4,

ind_1_yearafter=(

...

this is the result i need

i have attached an excel cause i dont know how to make a sample of a table to show it.

thanks but this is not what i am looking for

no no, it is not a year from today, it is within the year of that date, the table is huge so i just wrote the sample

so if the date...

i asked a similar question way back.

here is my post and how it got solved

i hope it helps.

http://www.sqlservercentral.com/Forums/Topic1435292-391-1.aspx

thanks!!!

I know the dateadd(HOUR, 3, getdate()) :-D:-D:-D

but is that the correct when you add dates automatically ?

Hi,

sorry for the delay, i think i was having a type or something cause i did run the code again and it works now.

the issue with using a company id,...

the insert into is working, that is not my issue, the values is the issue, i am having issues passing them, and still getting the same error :w00t:

the first version is a guess, more or less, when i run the second version i get

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'Finiti'.

i do have...

shame on me shame on me, my problem was a math problem, i didnt write the the date i wanted to get :doze:

thanks everyone for all the help!!!

i know what my error is, i just don't know how to fix it. :w00t: