I will try that... Thanks!!!!! something to start with for sure...

anyone have an example of this?

I need to take two tables, two columns and have it output a third with all possible combinations.

Neither appear to be working.

Adams appears to return no data.. no errors, but no data

with GAils I put her where statement but it was erroring out on the...

well it appears that neither are working....

With Adams, It appears to run but I get no results. I put the DECLARES at the top and then the Where...

thank you both... will have to test and confirm the results! But THANKYOU again for the info... greatly appreciated

forgive my ignornace but will that work through out the year where it will only grab the previous montn and the current month of data?

Thanks again

Rob

actually need to add the YEAR value in there to where it only goes back two months... as this year was the first on the DB so in 2008 when...

Issue is because of the change from 2007 and 2008.. where the MONTH returns a 0 and there for ALL applydates are greater than or equal to 0 so we...

thanks for the info.. will give it a try with my DB.

Thanks again

RM

convert(char(12),GETDATE()-1,101)

just takes the GET DATE ( todays date 08/23/2007 hh:mm:ss ) and converts it into the 101 format ( minus one day )

not sure if you are just...

I get incorrect syntex near '\'

thoughts?

thanks!!! Will give that a try.

here is the SQL I am running...

Select personid,personnum,firstnm,lastnm,middleinitialnm,workemailaddress,

companyhiredtm,birthdtm,homestreet,homecity,homestate,homezip,employmentstatus,employmentstatusdt

from VP_personv42

where Employmentstatusdt = convert(char(12),GETDATE()-1,101)

OR employmentstatus = 'active'

order by personnum

The field in question is Homestreet which is actually pulled from another...