Lab Sql

After my previous question, I have an SQL query like the following: SELECT * WHERE ... ORDER BY … Read more What Does It Happen When Using Multiple Case ... When Statements In The Same Sql Query?

I've the following query: SELECT tn.Date, b1.Name DrBook, b2.Name CrBook, c1.Name DrContro… Read more Creating Column Based On Where Condition

I'm working on trigger in MSSQL and i got this error message: Msg 512, Level 16, State 1, Proc… Read more Mssql Case When Statement Error

I have this query: CASE ClaimsFees.TBA WHEN 0 THEN CAST(IndemnityReserve AS NUMERIC(9,2)) E… Read more Sql Server : Conversion Error Numeric To Varchar Case

I need to make a case statement. Depending on what the variables value is, it needs to select the c… Read more How To Use A Case Statement Within A Select Count Statement?

I have the following code which generates data similar to mine. The posting here (PivotWithoutAggr… Read more Replacing Null From Results Of Case Query

I need to have an order by functionality inside a stored procedure. A value is posted to a webservi… Read more Order By And Case In Sql Server

So I have a query that looks like this - select case when @subType = 1 or @subType = 2 then id en… Read more Selecting Columns That Are Not All Null