Viewing 15 posts - 436 through 450 (of 1,229 total)
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
kevin.obrien 66193 (10/9/2016)
How do I allow for an item in SourceA to be matched to an item in SourceB?
So in my report output, if the user has indicated these 2...
October 10, 2016 at 11:11 am
MickyD (9/15/2016)
I recently came across a dev database in our organization that had no clustered indexes and circa 100 million row.....:crazy:
In order to rectify I need some advice on...
October 7, 2016 at 2:36 pm
Viewing 15 posts - 436 through 450 (of 1,229 total)