February 17, 2009 at 4:50 am
i am bit confused about my question only please help me to get the result
i hav 3 tables
table1,table2,table3
table1
uid shiftcode roasterdate
100 s1 xxxxxx
101 s1 xxxxxx
102 s1 xxxxxx
table2
uid patterncode
103 p1
//table3
//uid shiftcode patterncode
//103 s2 p1
srry... i am mistaken i do not hav uid in table3
table3
patterncode shiftcode
p1 s2
i want shiftcode's of 100 to 103 users between give dates
how to get
plzz help me....
February 17, 2009 at 5:00 am
shiva (2/17/2009)
i want shiftcode's of 100 to 103 users between give dateshow to get
plzz help me....
The shiftcode of user 100 is s1, and of user 103 is s2.
Without knowing what the relationships are between the tables, it's difficult to be more specific. Can you describe them at least in terms of parent-child relationships?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
February 17, 2009 at 5:09 am
thx for reply...
[userdetails] this is the master table
table1's uid is forignkey of userdetails of uid
at registration time only user enters in to the table2 and table3
when he got work for some days, user simply moves to the 'table1' table with his work code(shiftcode) and working days
just i want 100 to 103 users of shift code
how can I ??
February 18, 2009 at 2:49 am
i got solved this problem
http://forums.asp.net/t/1385965.aspx from this forum
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply