I just want Week  and Target column not formula column.Formula is just reference to calculate Target column

I have both 2008 and 2012 systems.I can run query on 2012,its not an issue

You can answer query for 2012 .It would be great help
Thanks

Hi Guys

Using this query select OFFICE_ID,

CASE WHEN OFFICE_ID in('1126','1127','1128','9999') THEN 'Yes' ELSE 'No ID_Exists' end

from [REV_BINDERS2]

i m getting this

OFFICE_ID(No column name)

1126 ...

I want such query in which i put specific IDs in IN operator and give me result which are present in table and which are not.

insert into dbo.retail(subscriber,wan,activation_date)

select '1700', '1802','2014-10-05 00:00:00.000' UNION ALL

select '1700','1801','2014-10-09 00:00:00.000'

For above dataset query wont work because wan 1801 activation_date is latest so it should come in New...

Thanks for this solution.

Is this possible i get old dated wan and new dated wan according to activation_date column.?

Activation date of both wan compared then old dated wan set...

Yea its in oracle but you can give solution accordingly

Thanks bro u nailed it

This query will return those id also which contain resource type BT (ex: 119319005).I only want those ids which contain RG and MI only.

That dataset was just an example.I need only those id which has MI and RG both

I m using oracle sql developer...

any good solution for that??

Luis Cazares u done great job...

Thanks a lot

WHERE KNO in ('8789','8896','6963')

AND KNO = 0

this will return empty records....

i want output

KNO

6963