I have a role called dyngroup that grants access to every table that uses my Great Plains Product, so I created a DenyPayroll role that Denies all but I only...

I got it to work.

I had to add @plantcode variable to the end of my first dataset

select * from fleetsize where order_date between @startdate and @enddate and [plant code] in...

I did. Here is the simple code i have

select * from fleetsize where [plant code] in (@plantcode) and order_date between @startdate and @enddate

How did you get this to work. I having the same problem

The row count is the same but in one field there is only one record in it. It should be 6 records.

This is only happening on 2 machines, all...

No the going to the same database, same table side by side and i'm not getting all the data on my machine.

I have double checked an i am pulling from...

How would I do this if i wanted to pull from two different tables.

When i add inner join it doesn't work.

Here is what i have:

osql -Usa -Psanicle -Sdbc-gp -Q"SELECT sum(qtyonhnd-atyalloc)...

Thanks that works perfect

This is what the output is of the sample code

Item Quanity

RMA2052...

Man this worked, i have been working on this for a week

one more thing:

SELECT

VARID ,

MyAlias.*

FROM BESTGUESS2

INNER JOIN (SELECT

...

but if you look at the 1st query it returns

ALFALFA 02229.00000

CLEVELAND14154.50000

GRADY 26191.75000

OK2 ALFALFA 02217.08000

OK2 BECKHAM 05639.78000

PAYNE 60273.24000

ROGER MIL65263.27000

but i what i want to see is alfalfa 02 and ok2 alfalfa...

CREATE TABLE BESTGUESS2(VARID varchar(15),

SOMEPLACE VARCHAR(15),

SOMEINVOICE VARCHAR(30),

SOMEDECIMAL DECIMAL (19,5) )

INSERT INTO BESTGUESS2

SELECT '0288','OK2 ALFALFA 02','INV0000083073',217.08000 UNION ALL

SELECT '0588','OK2 BECKHAM 05','INV0000083064',303.50000...

i'm getting the sample code together for you now.

A B ...

Here is some sample data:

ADAMS (See McGee, Angela)

Adryan (EP)

12821 N. Stratford #4

Oklahoma City, OK 73120

NULL

ALEXANDER JR. (See Arnold, Alice)

Alton (RB)

...