Viewing 15 posts - 451 through 465 (of 1,246 total)
No worries at all.
Thanks for posting back 🙂
----------------------------------------------------
October 21, 2016 at 11:03 am
select
item_location_view.qty_on_hand AS 'Qty on Hand',
item_location_view.qty_allocated AS 'Qty Allocated',
item_location_view.qty_backordered AS 'Qty Backordered'
FROM dbo.inv_mast inv_mast, dbo.item_location_view item_location_view
WHERE inv_mast.item_id = item_location_view.item_id AND ((item_location_view.qty_on_hand>=0) AND (item_location_view.qty_allocated>0) AND (item_location_view.qty_backordered>0))
Just as a side...
----------------------------------------------------
October 20, 2016 at 7:16 pm
My problem is that I have this query and it does not show me qty on hand that is equal to 0 and any value in the other 2 columns.
Why...
----------------------------------------------------
October 20, 2016 at 7:06 pm
When you open SSMS 2012 and up , there on the splash screen I have seen 'powered by visual studio.' I've not use this version but simply imagined there is...
----------------------------------------------------
October 20, 2016 at 6:58 pm
kreilly 50203 (9/2/2016)
We have created some versions of the SP's to mitigate the parameter sniffing - testing already.
Will look into blocking as well - has been...
----------------------------------------------------
October 20, 2016 at 6:44 pm
If you are developing code then you are advised to use a source control system. Aside from not having the copy of the release code reside on your machine or...
----------------------------------------------------
October 20, 2016 at 6:25 pm
As I see things like target price, target something ; plus sales markup and the like I think about the deal dimension and the promotion dimension that Kimball outlines...
----------------------------------------------------
October 20, 2016 at 5:57 pm
I just think SQL Server has lots better maintainability, speed optimization potential and is easy to build functions, calculated fields etc.. The fact that it has the ability to...
----------------------------------------------------
October 14, 2016 at 4:32 pm
Please provide sample DDL, sample data, with INSERT statements corresponding with the sample data and desired results, so that we can properly understand what you are trying to do and...
----------------------------------------------------
October 13, 2016 at 6:20 pm
I know there is a deployment utility within VS, though I've not used it much at all. Right click the name of the project in solution explorer > properties >...
----------------------------------------------------
October 13, 2016 at 6:07 pm
Luis Cazares (10/12/2016)
I really hope the OP didn't depend on the last replies. Not because they're bad, but because it's been over 3 years now.
I also hope the OP migrated...
----------------------------------------------------
October 13, 2016 at 5:45 pm
A good illustration for anyone learning the basics of Xquery.
----------------------------------------------------
October 13, 2016 at 11:25 am
The issue I see is that you can have one product out of many that only uses source D for example, while the rest are varied among the...
----------------------------------------------------
October 11, 2016 at 11:57 am
What is supposed to be doing the insert? A person? An application?
One idea is to have a trigger on the table that takes the inserted ID value and adds them...
----------------------------------------------------
October 10, 2016 at 11:36 am
We need DDL statements for your tables, inserts, and the queries with any parameters you are using in your report to pull your datasets.
Please start from the top. Just...
----------------------------------------------------
October 10, 2016 at 11:22 am
Viewing 15 posts - 451 through 465 (of 1,246 total)