January 23, 2007 at 9:02 am
Hi i'd like to get help with this
A log number is created uniquely in the system... for each log you can have many different scenarios here is one...
New log created X7=> acknowledged (01) => after talking to the customer determined an action plan(07) => on further investigation needed more information (41) after a day received the information (78)=> developed a solution (13) +. customer happy with solution Log Closed (25)
Exit Log X8
Here is a table with the results i like to get..
create table #tbl1
(
sequence_no int,
code nvarchar(20),
log_no nvarchar(20),
)
insert into #tbl1(sequence_no,code,log_no)
values('1','X7','104475777')
insert into #tbl1(sequence_no,code,log_no)
values('2','01','104475777')
insert into #tbl1(sequence_no,code,log_no)
values('3','07','104475777')
insert into #tbl1(sequence_no,code,log_no)
values('4','41','104475777')
insert into #tbl1(sequence_no,code,log_no)
values('5','78','104475777')
insert into #tbl1(sequence_no,code,log_no)
values('6','13','104475777')
insert into #tbl1(sequence_no,code,log_no)
values('7','25','104475777')
insert into #tbl1(sequence_no,code,log_no)
values('8','X8','104475777')
I need to find if a log has this possible scenario.
Many thanks.
January 23, 2007 at 11:26 am
What do you think that this result will look like?
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply