parpaa
asked on
Correct my query
Dear Experts,
I have discomfort with my select query ( pls find it below) I know it is wrong..
I highly appreciate if you could correct it.. thanks in advance
I have discomfort with my select query ( pls find it below) I know it is wrong..
I highly appreciate if you could correct it.. thanks in advance
select account_no, case
when [del_no]=0 to 8 then ( select [days_0_8] from table2)
when [del_no]=9 to 15 then ( select [days_9_15] from table2)
end as 'del'
into table3 from table1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thnks for soln .. It resolved.
Maybe an example of data going in would be helpful and the outcome you'd expect.