Hey its wonderful tht a solution is being with my assumed condition..

now i have mingle both of your query to make my one to achieve and it was working...

Dear,

Thanks for your replies !!!

i found that i has to be done as a vb project and then to take the dll created inside our application and then from there...

Hi any one please reply /?

Else say me where shall i post this to get a solution ???

Thanks,

Meera.

Any light on this ???

please ....

hi Dear,

Thanks for your reply !

Fine, in addition let me explain a little more.

(Kindly bear if this is not the right forum to post my queries)

What they have done is

1....

Hey Thomson U r great... ur query worked out for me...

Thanks a lot ...

If i could assign u points like other forum say me ... im unable to find where...

Dear Thomson, Thanks for reply.

PLease say me whether the following will be correct if i use your query with mine.

Select S.Id, S.Value, S.Id() Over (ORDER BY [datActualDate] ASC) AS ROWID,

[datActualDate]

FROM

[Schema].[TableName])...

Hi Can you help me providing the steps to create a job? becoz i ve nt tried tht b4.. plz..

thanks in advance,

Dear All, Thks for ur kind sharing of ur ideas for my accomplishments.

But very sorry if in case i am bothering u ppl in further.

All of u had taken...

Dear Andrew

i am bit confused, with declaration of

DECLARE @StartTime datetime

DECLARE @EndTime datetime

SELECT @StartTime = '10:00', @EndTime = '14:30'

I am unable to modify without this declaration. the values of start...

No ll not consider the holidays for only the day on which the process gonna take place ll be entered into table.

HI ALZDBA, Thks for ur Query.

But ur query is not giving me the required result,

for i need to get only the hrs as single result n not any other...

Hi i got tht 9 hrs by manually calculating the hrs between 10:00 to 2:30 for 2 days. For a day its 4.30 hrs, so for 2 days its 9...

Ok Sorry for my xplanation

Kindly assume T1, T2, T3 - Tables

T1 |

----

P1 |

C3 |

C2 |

T2|

---

C3 |

C2 |

C1 |

R1 |

T3

---

Col1 - Col2

P1 - C3

C3 -...

HI Arun Thks for ur reply tht trick works Thks a Lot txtPost_CommentEmoticon(':-)');

🙂