Viewing 15 posts - 421 through 435 (of 1,229 total)
Below is a sample of the underlying data. Please excuse me if I did not use the correct code, and for the headers not being completely aligned.
Reporting YearReg AreaOrignalAdmissionOrignalDischargeReadmissiondischargedatedays between...
October 31, 2016 at 2:45 pm
Hello, our server hard disk crashed due to power failure and all the backups were on the hard disk. Before just before it did we had managed to copy the...
October 28, 2016 at 1:43 pm
Lynn Pettis (10/28/2016)
Chris Wooding (10/27/2016)
October 28, 2016 at 12:01 pm
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
Viewing 15 posts - 421 through 435 (of 1,229 total)