Hi Erikur and Dwain,

Thanks very much for looking into it.

Queries are amazing and works very well as expected. Perfect!!

Dwain's answer looks closer to what I expected as some of...

Thanks EveryBody,

So, I think we have to take the Max.Values manually for the Given DataType and then we can use it for other operations like comparing the value of the...

Hi,

Can you put your expected Results for the given sample datas at the end of each conditional select Statement for the given sample datas

Rajesh

you use this query also

select A1,B2 from Test

inner join test1 on test.A2 = test1.b1

where a3 in (select max(a3) from test group by a1)

order by a1

rajesh

HI ,

You can Use a case option in select statement when transactiontype is LIKE 'Down Time% then

concatenate ''= transactiontype LIKE 'Down Time%" else do it in opposite manner

This...

Can you post the expected output result with some input datas

rajesh

Hi,

Hope this will be helpful to you

with fulldate (date)as

(

select dateadd (day,n,'06/01/08')

from Dbo.Tally

where n<=datediff(day,'06/01/08', '06/16/08') and dateadd(day,n,'06/01/08')<'06/16/08'

)

,leave(date) as

(

SELECT DATEADD(DAY, 7 *...

Can you explain clear by posting some sample datas and expected Results you are looking for

Rajesh

Hi ,

Can we use a function for this solution or this will give poor performance,can nybody suggest where iam wrong?

create function DateCalc(@processID int)

returns Datetime

as

begin

Declare @Date DateTime,@Deadline DateTime,@PRocessAfter int

select @ProcessAfter...

Thanks all,

Thanks for everyOne in sharing the Ideas.

RBarryYoung has given the Really superb Answer which is what i am looking For thats keeps away from correlated queries.Once again thanks for...

Where are you entering the Current date and also there is no deadLine COlumn in this table.

Are you trying to calculate the DeadLine based on the Given Current Date using...

Could you post the sample Datas along with the Expected Results

Rajesh

HI,

Try this and confirm whether this is what you are looking for,

Select E.Number, E.Name, E.Date As Date, M.Text1

From Entries As E Inner Join Main As M On E.Number = M.Number

where...

Hi Rahul,

Can you post the Table Structure as a create Table query for the two tables along with some sample Datas as insert query and expected Results in the Table2...

Hi Sharma,

I Have assumed your Ids starts from 1,so N in the Tally Table starts from 1 ,if you want to start from 0 ,make the Identity(1,1) in tally table...