some more info on table columns

OrderId, PersonId, Name, Product, Date, SpoonId, Priority

1, 1, AA, AA, 01/01/2012, 2, 1

2, 1, AA, AA, 01/01/2012, 3, 2

3, 2, AB, AA, 01/01/2011, 5, 1

4,...

Hi I did the following:

The idea is to get all records of possible combinations: Say @Mod1 = AA, @Mod2 = AB, @MOD3 = AC

I have table with columns,...

CREATE TABLE [dbo].[WorkOrderDetailedReports](

[Id] [float] NULL,

[Status] [nvarchar](255) NULL,

[Description] [nvarchar](255) NULL,

[Category] [nvarchar](255) NULL,

[Workgroup Name] [nvarchar](255) NULL,

[F6] [nvarchar](255) NULL,

[Person Name] [nvarchar](255) NULL,

[Created (Date&Time)] [datetime] NULL,

[Actual Finish (Date&Time)] [datetime] NULL,

[WO Classification] [nvarchar](255) NULL,

[Closure Code]...

The idea is still same. Join (probably left join) your original table with the category table with condition

on originaltable.category = categorytable.categoryname

you will get id of matching category name. Do...

Try this, it may contains syntax error. I don't have a context, so this is just a wild idea. We need to optimize this. Try and let me know you...

By combine you mean combine them as records or columns?

If records you can use UNION ALL. For union all you should have same amount/type/name columns across all select statements. If...

You mean this?

create table #tab

(

id int identity(1, 1) not null,

name varchar(10)

)

create table #tab1

(

name varchar(10)

)

insert into #tab values ('A')

insert into #tab values ('B')

insert into #tab values ('C')

insert into #tab values ('D')

insert...