which I believe is what I posted earlier

CASE...

ok, without you answering the rest of my question for expected results on various scenarios...here is shot in the dark :

CREATE TABLE #test(CurrentValue...

what datatype is "current value"?

what would you expect for Current...

camiloecheverry11 (10/19/2016)

---

This is exactly how I have the entire query.

SELECT item_location_view.item_id AS 'Item',

item_location_view.item_desc AS 'Description',

inv_mast.class_id1 AS 'Brand',

item_location_view.location_id AS 'Location',

item_location_view.qty_on_hand AS 'Qty on Hand',

item_location_view.qty_allocated AS 'Qty Allocated',

item_location_view.qty_on_po...

why are you using ">$0" ...ie the $ sign?

what have you tried so far?

from you brief details maybe

SELECT a,

b,

c

FROM sometable

WHERE(a >= 0)

...

Aquilagb (10/19/2016)

---

Hello,

I have a SQL query which works fine and returns 10 columns and one row of data. What I would like is to pivot this data so that...

are you able to post the .sqlplan rather than the word doc please?

what does your "dbo.function" perform?

WendellB (10/19/2016)

---

You are correct...

SELECT CONVERT(VARCHAR(10),GETDATE(),112)

possibly ??

WITH cte AS (

SELECT Date,

Amount,

ROW_NUMBER() OVER(ORDER BY date) - DENSE_RANK() OVER(PARTITION BY amount ORDER...

I really dont follow your question....can you please expand and explain.

and to help all of us help you....here's how to post sample data

CREATE TABLE #yourtable(

id ...

ChrisM@Work (10/19/2016)

---

BLOB_EATER (10/19/2016)

---

Brandie Tarvin (10/19/2016)

---

ThomasRushton (10/19/2016)

---

rodjkidd (10/19/2016)

---

are you...

I think you have to set up the the RI in the SQL Server environment, not via your Access FE.....I may be wrong though

one way maybe...??

CREATE TABLE #Counter

(CKey INT,

CA INT,

CB INT,

CC INT,

CD INT,

CE INT

);

INSERT INTO #Counter

VALUES

(1, 2, 3,...