1800m1g0000h69g9eujg000000Reduce non-value added calls stemming from complex marketing initiativesCanceled DMAICNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

1800m1g0000h69ip1m600000001. DefineCompleted ...

Thanks for the reply...

But i need all the four recored (All records from the table )With ActiveGateDate

Say: If Active Gate Is Null then ActiveGateDate vl also be null

If...

HI All

I got to retrieve record within one table(Say subquerues)

I hav table lyk this

WorkId WorkName Actual_start_Date ActiveGate Status Current

10052 ...

Hi Anthony,

I got one more Error..

I have table lyk

WorkId

Hi Guys....

I Need to retrieve Days from the Dates..Using DATEDIFF Funtion

With Project_view(WorkId,Name,StatusCurrent,ActiveProcess,ActiveGateDate,ActualStartDate,ActualEndDate)

As

(

Select distinct vw.work_id as WorkId, vw.name as Name,vw.status_current as StatusCurrent,

vp.process_name as ActiveProcess,vw.actual_start_date as ActiveGateDate,vw.actual_start_date,

vw.actual_end_date

from view_work...

With Project_view(WorkId,Name,StatusCurrent,ActiveProcess,ActiveGateDate,ActualStartDate,ActualEndDate,parent_work_id)

As

(

Select distinct vw.work_id as WorkId, vw.name as Name,vw.status_current as StatusCurrent,

vp.process_name as ActiveProcess,vw.actual_start_date as ActiveGateDate,vw.actual_start_date,

vw.actual_end_date,vw.parent_work_id

from view_work vw INNER JOIN View_Process vp ON vw.process_id = vp.process_id

join...

With Project_view(WorkId,Name,StatusCurrent,ActiveProcess,ActiveGateDate,ActualStartDate,ActualEndDate,parent_work_id)

As

(

Select distinct vw.work_id as WorkId, vw.name as Name,vw.status_current as StatusCurrent,

vp.process_name as ActiveProcess,vw.actual_start_date as ActiveGateDate,vw.actual_start_date,

vw.actual_end_date,vw.parent_work_id

from view_work vw INNER JOIN View_Process vp ON vw.process_id = vp.process_id

join...

I didnt find the tagging to ur Signature

Mr.Jeff

It should Multiply with 'n' number to the value

if 10 power 2 = 10 * 10 =100

if 10 power 5...

Sorry Jeff....

For simple Understanding i vl give an example..Please hel;p me out

Ex:

how to calculate power vale in the Sql server...

Hi codebyo,

Thanks for ur Posting..I got My result

Thnks for u r Reply

Now if the date is from two Diff Month 02-Feb-2011 to 03 - Mar-2011

how to get this following...

Hi Guy Thnkz for the support..

But i want in the Different scenario..this is for Payroll Calculation ..I have listed example table

person_id Assign_id ...

Thnxzzz

thanks Buddy!!

How to implement this in store procedure......???

Lyk using this validation

IF EXISTS ( SELECT 1 FROM MY TABLE WHERE ACCOUNT_CODE = 10000 AND ACCOUNT_TYPE = ASSETS)

LYK THIS VALIDATION BEFORE...