Hi All,
I have the following SQL Table, which represents the number of steps required (in order) to complete an application (Simplified):
I also have the following table, which records application details (again simplified):
(stage is actually a foreign key referencing the the workflowID WFID of the first table)
Basically what I am looking for is a really simple char, which will list the workflow steps descriptions along the bottom, and then a single (horiz) bar, showing the current progress of the application out of all steps.
If anyone could help me with the SQL for this, I would be grateful
Regards
Mick
I have the following SQL Table, which represents the number of steps required (in order) to complete an application (Simplified):
CREATE TABLE [dbo].[tblWorkflowSteps]( |
[WFID] [int] IDENTITY(1,1) NOT NULL, |
[Description] [varchar](500) COLLATE Latin1_General_CI_AS NOT NULL, |
CONSTRAINT [PK_tblWorkflowSteps] PRIMARY KEY CLUSTERED |
( |
[WFID] ASC |
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] |
) ON [PRIMARY] |
GO |
SET ANSI_PADDING OFF |
I also have the following table, which records application details (again simplified):
CREATE TABLE [dbo].[tblApplications]( |
[AppID] [int] IDENTITY(1,1) NOT NULL, |
[Completed] [bit] NULL, |
[Stage] int NOT NULL, |
CONSTRAINT [PK_tblApplications] PRIMARY KEY CLUSTERED |
( |
[AppID] ASC |
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] |
) ON [PRIMARY] |
GO |
SET ANSI_PADDING OFF |
Basically what I am looking for is a really simple char, which will list the workflow steps descriptions along the bottom, and then a single (horiz) bar, showing the current progress of the application out of all steps.
If anyone could help me with the SQL for this, I would be grateful
Regards
Mick