thanks for ur reply.

yes u r right abt profiler.but we had a problem with a user .he says he did not login yesterday at all.

i want to findout when he...

thanks for that.

so you r saying there is no system table/proc to query, right?

now i cannot modify my procedure bcoz its constantly being used.

let me know if there is any...

cheers ray

i'll look at it.

frankly i didnot know aby yukon.

thanks for telling me abt it.

cheers

Thanks Ray

my company is not willing to invest any amt

in buying those 3rd party tools.

may b i need to stick to my earlier plan.

cheers

Hi Jonathan & racosta

Thank u very much for ur reply.

sorry i'm in late in reply as i was in christamas holidays.

Hope u guys had great christamas.

cheers

thank u very much Mongo_ks

i think need add 1 to lowest column i.e

lowest+1 (in case statement)otherwise its returning existing row.

cheers

Thank u very much friend.

ur query worked perfectly.

the reason i'm using non-numeric datatype is

there is some existing data.now we decided that it should be autogenerated fld without

effecting existing data.

thank u...

Thanks Gary

Actually left outer join is the key here.i

think i need basically 2 queries.when staffid passed it will b inner join on Task.if no staffid passed it will b left...

Hi gary

i think i understand what the problem is.

i have 2 tasks with no assignments on it.

so when i pass staffid the query returns those 2 tasks too.

is there any...

Thanks for quick reply Gary

here Task primary key table for Assignment table.its 1 to many relationship.

on a single Task there may b more than 1 person working on it.so when...

HI

i'm back again.it worked fine when i pass only % but if i pass some staffid(i mean some value other than %) it bring wrong results.

for example if i...

Dear Gary Johnson

you r wonderful mate.

i've been struggling for 2 hours.

Your suggestion worked. 🙂

Thank you so much