Thanks for your answer and that is actually the no.. i was looking for...

would both the queries result in the same answer????

[Code]

delete from #tempTable t

Left join cte_claims...

Index Episode Start Date = Starting episode of treatment during the intake period with no prior claims for 120 days and a new diagnosis of depression. (DSM-IV-TR 296.2x, 296.3x, and...

Actually this is my requirement

Index Episode Start Date = Starting episode of treatment during the intake period with no prior claims for 120 days and a new diagnosis of...

so should i use eff_dt = dateadd(month,-4,eff_dt) or what

Thank you very very much for that idea...

yeah your right i was not thinking out of the box...

thanks for the answer but when i do that... can i use those values to plot a graph???

Download & Install "Microsoft OLE DB Provider for Visual FoxPro 9.0" from...

http://www.microsoft.com/downloads/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en

U can download the driver from here and install it on ur system and while importing it to sql server u need to select that driver..

Download & Install "Microsoft OLE...

The client is going to provide us the excel spread sheet...but we wanted to add a logo as a new feature so i thought to just put them in the...

Thanks for the quick reply.. my spread sheet has the following columns and everything is done on a plan level.. so my spread sheet with the logo information will...

Thanks for the answer.. I got it work by Adding Rtrim next to the fields..

Thanks for your answer.. But wouldnt there be a gap for the columns that are blank and will the size of the report shrink??

Thanks for ur answer GSquared..

In my first post i hve the table definitions.. and in the second post i have given the data i get in my select query and...

Select

cs.ClientActCode,

cs.CodeDescription

From

ActCodes cs

...