Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
update PlacedOrderDetails set Qty = [Ship Qty] * (cast(substring(Size, 1, patindex('%[^0-9]%', Size + '/') - 1) as float) * case when charindex('X', Size, 1) > 0 then cast(substring(substring(Size, charindex('X', Size) + 1, len(Size)), 1, patindex('%[^0-9]%', substring(Size, charindex('X', Size) + 1, len(Size)) + '/') - 1) as float) else 1 end ) WHERE Qty IS NULL
|Error "String or binary data would be truncated" in an update on a datatable||7||28|
|Help with Sorting Full Text results||2||14|
|sql server group by every 2hrs||5||20|
|SQL won't work after disabling SSL3 / TLS1||3||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!