Excluding 2 entries from showing

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Excluding 2 entries from showing

Author

Topic

Dgardner1988
Starting Member

1 Post

Posted - 2012-03-12 : 10:44:36

I'm having an issue with a company report I'm building using REPORT MANAGER / DESIGNER XP, it's using SQL parameters which make it easy.

WinSQL is also making it a lot easier to comb through, but I'm still having troubles. Here's the code I have

SELECT pomvt.item, pomvt.ord8wks, pomvt.shp8wks, arinvt01.descrip,
arinvt01.brand, arinvt01.onhand, arinvt01.onorder, arinvt01.aloc
FROM pomvt JOIN arinvt01
ON pomvt.item = arinvt01.item
WHERE pomvt.ord8wks > arinvt01.onhand+arinvt01.aloc AND AT (pomvt.item,'FREIGHT,w0999') = 0
ORDER BY arinvt01.brand

I want the two entries that show up "Freight" and "w0999" to NOT show up AT ALL in my report. but I've tried at least 3 different tactics and nothing works. Help? lol

ITS A TRAP!!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-12 : 10:50:14

This is not a WinSQL forum. So I dont think there're enough people with WinSQL skills here. Why not try your luck at relevant forums?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources