ok let me try, anyways thanx a lot

hi

Thanx a lot, I can see the variance now, but every count is shown in a different column I want everything YTD2009 / YTD2010 / and Variance in...

i ran both the queries provided, but it returned nothing...NO rows...

I am not sure if It's returning result @ ur end.

Hi

I have already defined in my query the year strings...

have a look here:

Select

...

any helppppppppp on thisss

Thanks

hi here is the create table and insert and my query to get data for 2009 and 2010 year,,

the result will be like this:

LASource1YTD 200969

LASource1YTD 201068

I want to show variance...

[font="Comic Sans MS"]Thank u All:-):-)

Thank u ....Thank u Gail Shaw 🙂

I used your Row_number code and It works like gem..........

I used account number in both places, instead of order by...

Hi All[font="Comic Sans MS"]

thank you so much for all your Replies.....

The criteria is to get the first Row...

SELECT

Area

,StateName

,CityName

,ACCOUNT_NO

,CUSTOMER_NAME

,CounterNo

,ROUTE_No

,Address

,TeleNumber

FROM FACT F

,Dim1 1

,Dim2 2

,Dim3 3

WHERE

F.DW_1_KEY =...

[font="Comic Sans MS"]Hi

thanks for your reply,

I dont wanna use the Script task, I have code for it.

I wanna use my Execute SQl task and set a vriable value to 1...

thnk u thnk thnku:-)

Thank You Lynn :-):-):-)

Thank You bitbucket-25253 :-):-):-)

Thank You :-):-):-)

Thank You :-):-):-)

i have to cast a column like this

select cast(73982597/1000000 as numeric(8,6))

it gives me 73.000000

but i want result as 73.982597

any help

thanks

Thanks a lot..

it works fine for all the string ..but doesn't work for 0000 string

it only removes one 0

I want to make it single 0 if it is more than...

Thanks, but I have many records for each date, I cant use this.

For ex :

10/23/09 -i have 1000 records

10/22/09 - i have 3000 records

I need max date -1 , but...

Thanks Lowell...

It works perfectly f9....

Thk uuu again:-):-)