Forum Replies Created

Viewing 15 posts - 241 through 255 (of 285 total)

  • RE: Create Status table Column and update

    Thank you for spending your time on this!!!

  • RE: Create Status table Column and update

    Thank you for understanding.

    I need these columns( all of them are tbl_doc_sctivity table) except status column …which has to be derived.

    create Table Status_of_Enrollment

    ( Entry_id int,

    event_type_id int,

    Event_value varchar(30),

    Event_time varchar(30),

    Username ...

  • RE: Create Status table Column and update

    I need a event_status table :

    I want status for only those records which have sys_current_step(5) = "enrollmentanalyst"

    and status will complete or pending.

    I need to know the status of records which...

  • RE: Create Status table Column and update

    Yep..new table with status column

  • RE: Create Status table Column and update

    Entry_idevent_type_idEvent_valueevent_timelast_updated_userStatus

    107141Initiated5/18/2012 16:01ADMIN

    107145Customer Service5/18/2012 16:01ADMIN

    107145Enrollment Technicia5/18/2012 16:07ADMIN

    107145Customer Service5/18/2012 16:07ADMIN Pending

    1071Imported5/12/2012 13:49ABD Pending

    1075Enrollment Analyst5/12/2012 13:49ABD2 Pending

    1071Routing5/12/2012 13:49ABD3 Pending

    1073ENROLLMENT TECHNICIA5/12/2012 13:49ABD4 Pending

    1081Routing5/18/2012 2:03ABDComplete

    1085Enrollment Analyst5/18/2012 2:03ABD2Complete

    1085Intake5/18/2012 2:03ABD3Complete

    1083INDEXING5/18/2012 10:29ABD4Complete

    1084Enrollment Analyst5/18/2012 10:53ABD5Complete

    My status...

  • RE: Create Status table Column and update

    Example of entries which has no current+step=5 and event_value=’enrollment anaylst”---------

    Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value ,Event_time,Username)

    VALUES(10725,1,'Initiated','2012-05-18 16:26:02.987','ADMIN')

    Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value ,Event_time,Username)

    VALUES(10725,5,'QA Technician','2012-05-18 16:26:02.987','ADMIN')

    Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value ,Event_time,Username)

    VALUES(10725,1,'Carrier Exception','2012-05-18 16:27:56.870','ADMIN')

    Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value...

  • RE: Create Status table Column and update

    From your query i am getting all the records whose current_step is not "enrollment_analyst and setting sattus = "pending"

    But I need only those records which are in Current_step ="Enrollment_Analsyt" and...

  • RE: QUERY

    SELECT Entry_id, Eventy_type_id, Event_value, Event_datetime, username

    Here it goes

    INTO #yourSampleData1

    FROM (VALUES(1,6,'pending','05/17/2012 23:30','ABC'),

    (1,6,'Pending letter','05/17/2012 24:31','DCBSA'),

    ...

  • RE: QUERY

    Expected:

    Entry_id pendeddate newinfodate ...

  • RE: QUERY

    Sorry my criteria changed!!!

    Entry_id Eventy_type_id( not unquie) Event_value( not unique)Event_datetimeusername

    16pending05/17/2012 23:30ABC

    16Pending letter05/17/2012 24:31DCBSA

    11newinforecieevd05/17/2012 24:32Adsadhsa

    18EA05/17/2012 24:33Asafcsd

    16pending05/17/2012 24:33Asdsac

    TABLE A scenario 1

    TABLE A scenario 2

    Entry_id Eventy_type_id( not unquie) Event_value( not unique)Event_datetimeusername

    21carrierexception05/17/2012 23:30ABC

    21newinforecieevd05/17/2012...

  • RE: rows to columns

    hi ,

    Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)

    values ( 91,5, 'Indexing',2012-04-23 15:51:53.177,asdf,asdf,2012-04-23 15:51:53.177)

    Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)

    values ( 91,4, 'Intake',2012-04-23 15:51:53.177,asdf,asdf,2012-04-23 15:51:53.177)

    Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)

    values ( 298,5, 'Indexing',2012-05-05 23:31:22.660,asdf,asdf,2012-04-23 15:51:53.177)

    Insert into...

  • RE: rows to columns

    sorry !! i am always thankful to the people for helping me out.

    due to few situations..i am just copying from notepad what I typed.

    Thank you , I worked out the...

  • RE: rows to columns

    entry_id sys_Routing_Action sys_WkfStep_Current

    123 Indexing...

  • RE: rows to columns

    hi

    event_type table has values

    Event_DescriptionEvent_Type_Id

    Status 1

    foldername ...

  • RE: String extraction

    ex:/csteam

    the o/p=csteam

Viewing 15 posts - 241 through 255 (of 285 total)