Viewing 15 posts - 436 through 450 (of 1,233 total)
I just finished reading this book and it opened my eyes some good ways of organizing the flow of code from development to production, with source control as the pivotal...
October 21, 2016 at 12:01 pm
This is a cross post.
http://www.sqlservercentral.com/Forums/Topic1827737-145-1.aspx
Rather than posting the same thing in multiple spots, people will better serve you better if you help them to help you. In both of...
October 21, 2016 at 11:53 am
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
Viewing 15 posts - 436 through 450 (of 1,233 total)