Thanks.Will try this out

Jeff Moden (3/26/2016)

---

Sachin Nandanwar (3/26/2016)

---

ALTER FUNCTION [dbo].[Getgrnqty_test2] (@ItemCode VARCHAR(10))

RETURNS TABLE

AS

BEGIN

RETURN

(SELECT S1.divisionid,

...

Sachin Nandanwar (3/26/2016)

---

Forgot the column alias for SUM in the earlier code.

ALTER FUNCTION [dbo].[Getgrnqty_test2] (@ItemCode VARCHAR(10))

RETURNS TABLE

AS

BEGIN

RETURN

...

Sachin Nandanwar (3/26/2016)

---

Your function is scalar valued so it will return only a single value.What you need to do is convert the scalar valued function to a inline table valued...

Thanks.I have sorted this out.after scouring through tables i found some keys that matched and worked from there.Took me quite a while but i sorted out

I have most of the info.i would've liked to run the report once.Looks like ill have to run the goods sold and then received and then filter out what i...

My director wants to see a Unit sellingprice for the item '0000'

To do that:

i have to join on primary keys(no foreign keys).

I have to join on the STOCK table and...

I have run the query without the case statement and it shows the correct value

here is the sample code

SELECT DISTINCT I.Alternatecode, I.ItemDescr, I.ItemCode, S.Quantity,

S.ActualSellPrice , s1.TradingDate,s.Branchid,c.poscolourcode,s1.docketdate,st.SellPrice1,

case

when

st.markdownprice1 is...

Thanks

Let me give that a try.thanks

Any easier way?

Sorry for that.Sorted out the problem

I work for a retail clothing company so when we bought the POS package the developer done everything.I was more in the technical/support side of things.Recently my company decided on...

Thanks guys.I did checkup and spoke to the developer.There are NO foreign keys

Yes i do have and yes they are trusted.I did the diagram once before and it worked,but i didn't save it.