asked on
ASKER
ASKER
ASKER
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
TRUSTED BY
Set STATUS = Case
When IsNumeric(Quantity) <> 1 Then 'FAILURE'
When IsNumeric(Quantity) = 1And Quantity <=0 Then 'FAILURE'
Else NULL
End,
Set REMARKS = Case
When IsNumeric(Quantity) <> 1 Then 'Quantity is not numeric'
When IsNumeric(Quantity) = 1 And Quantity <=0 Then 'Quantity is less than 0'
Else NULL
End
WHERE
QUANTITY IS NULL
AND STATUS IS NULL