strings, no id's being passed

remove like isn't an problem, my first crack at is had { = }, as for performance, quicker the better. 🙂

@jeff, thanks for your help on this. the more and more i posted the more it was coming to me, so I guess posting was like me talking it out...

I got it working

I did this:

select * from

(select id,

max(case when value like 'make' then shortdescription else '' end) as carMake,

max(case when value like 'model' then shortdescription else '' end)...

@jeff,

I have it about 99.9% working, but i'm losing my date, this is what I have

CREATE TABLE [dbo].[sales](

[id] [int] IDENTITY(1,1) NOT NULL,

[value] [nvarchar](50) NULL,

[shortDescription] [nvarchar](max) NULL,

[longdescription] [nvarchar](max) NULL,

[datetime] [smalldatetime] NULL

)...

how's this:

CREATE TABLE [dbo].[sales](

[id] [int] IDENTITY(1,1) NOT NULL,

[value] [nvarchar](50) NULL,

[shortDescription] [nvarchar](max) NULL,

[longdescription] [nvarchar](max) NULL,

[datetime] [smalldatetime] NULL

) ON [PRIMARY]

INSERT INTO[dbo].[sales]

([value]

...

I can't show the table schema and what I have shown is what most of my data looks like.

it contains 5 colums and they are all nvarchar fields, so I...

I got it, I had to make a query change and then I grouped everything via the code within the app.

Though for future, could SQL give me output like...

thanks, I have to say, the security on Win 7 is brutal.

this helped, thanks alot.

yes

thanks, I'll take a look, I just don't want to uninstall and reinstall everything on the servers. That would be a huge task

i'm just looking for pulling random records out (which I showed my query I'm using) and not show the same sales person twice.

Jeff Moden (4/19/2010)

---

SQL_NuB (4/19/2010)

---

that is setup for the start date or end date begin on a weekend, I need to find out if the day between my two dates are...

that is setup for the start date or end date begin on a weekend, I need to find out if the day between my two dates are a saturday or...

I got it working, instead of where you had the 10, I put that as my column that has the defined number of days to complete and it worked fine.

thanks...