Jus (6/1/2009)
DDL:CREATE TABLE [dbo].[testcases](
[testcase_id] [int] IDENTITY(1,1) NOT NULL,
[ScenarioName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[scenario_category] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[expected_bundles] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[expected_promotions] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[on_order] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[on_profile] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Change_to] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [datetime] NULL,
[user_name] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_crmm_testcase] PRIMARY KEY CLUSTERED
(
[testcase_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Data:
testcase_id scenarioname
1 [Change6]-[Existing Customer]-[FE / FDV + Video SPL FL DCT with VTP = NO]
The DDL is okay, but there are two things wrong with your sample data. One, one record does not a sample make. Two, I really don't want to take the time edit the "sample" to get it into your table to test. It simply is not in a readily consummable format. Again, you may want to read the first article I reference below in my signature block if you would like better answers to your questions.
Edit: And actually, the "sample" data doesn't even match the DDL of the table.
You want help, you have to put in some effort to get the best responses.