Viewing 15 posts - 436 through 450 (of 1,241 total)
I am being asked to cherry pick the important stuff.
Depending on who you ask, if you go around the company eventually you might find most all of it...
----------------------------------------------------
October 26, 2016 at 4:26 pm
And for any outside service that does cleansing, just be mindful about any protected information in your agreements from which you get these addresses. I see no issue with standardizing...
----------------------------------------------------
October 25, 2016 at 2:17 pm
I DID NOT say "Users are entering data", what I said was "We get tables" - meaning these are tables exported from other systems where the limits are not...
----------------------------------------------------
October 25, 2016 at 1:44 pm
As for ongoing maintenance, there is a fancy cliche out there ... something like "machine learning." It means that new codes that are not familiar would get captured by the...
----------------------------------------------------
October 25, 2016 at 1:24 pm
Maybe this helps? It may not look pretty, but it it worked for me given your requirements of removing the final suffix if it is directional and standardizing the street...
----------------------------------------------------
October 25, 2016 at 1:17 pm
Just one item of consideration that I wanted to throw out there. The bookings can change from day to day, since from a business perspective I imagine each booking can...
----------------------------------------------------
October 25, 2016 at 11:43 am
If you must have all in one row, you can opt for the names of the people on the project to be stored in a XML type column.
----------------------------------------------------
October 21, 2016 at 12:21 pm
To add my two cents, I just finished a good book that has some useful thoughts on the use of source control as the central tool when working with teams...
----------------------------------------------------
October 21, 2016 at 12:05 pm
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
Viewing 15 posts - 436 through 450 (of 1,241 total)