aggravate

< .... Running screaming to my tent in the desert ......>

Why is it that when you ask someone to SHOW you want they are trying to do they never...

Not really sure if you want this:

select 'ALL',StateName from States

or this

select StateName from States

union all

select...

No, that isn't what I asked for. Show what you are trying to accomplish. What code have you written so far, and you actually want.

Try this:

SELECT * FROM [dbo].[tblReportData]

WHERE (CardORKey='Card')

AND (LastName = @LastName OR @LastName IS NULL)

AND (Date >= @StartDate OR @StartDate IS NULL)

AND (Date < dateadd(dd,1,@EndDate) OR @EndDate IS NULL)...

Care to show us what you asking?

Something like this, I would guess.

create table #testtab (

CId int,

SN char(4)

);

insert into #testtab

select 1, 'ABC1' union all

select...

mbender (2/5/2010)

---

Guess I'm a bit unclear about what your asking, do you want to know what I would expect the results of SELECT * FROM InventoryThatNeedsReorders before or after the...

Actually, I'll take a fresh brewed sweet tea, just not as sweet as...

mbender (2/5/2010)

---

In the example if the updates and inserts were done then i pulled the query

Select PartNumber, Location, Quantity from InventoryThatNeedsReorders Where ((Quantity-ReorderPoint)>=1)

I would not expect it to show:

Widget 123,...

debilitate

Will this help get you started:

create table #testtab (

intval int

);

insert into #testtab

select 1 union all

select 2 union all

select 3 union all

select 4;

select

STUFF((select...

so:

select replace('1 2 3 4',' ',',')

Is that what you are looking for?

Are you talking about a delimited string split? Like this:

1,2,3,4 to

1

2

3

4

At the previous employer where we had Notes, the Notes programmer wrote code that pushed data into a database on SQL Server, so I never had to setup a transfer...