There are two variants of the CASE expression: the simple CASE expression and the searched CASE expression. You are mixing the two.

When using the simple CASE expression, the comparison...

mcfarlandparkway (9/28/2016)

---

TY for the response, In the recent code we are selecting data form temp table where DOC NOT IN (select DOC from table where code<> -1)

This is what the...

SELECT v.*

FROM (

VALUES

(1, 'True', 'True', 'True', 'True', 'True', 'True'),

(2, 'True', 'True', 'True', 'True', 'True', 'True'),

(3, 'True', 'True', 'True', 'True', 'True', 'True'),

(4, 'True', 'True', 'True', 'False', 'False', 'True'),

(5, 'True', 'True', 'True',...

J Livingston SQL (9/27/2016)

---

drew.allen (9/27/2016)

---

Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime....

You're strings/dates aren't quoted. You should always try to run your query before posting it on the Internet.

Drew

Infock12 (9/28/2016)

---

Hello all,

You expert opinion is much appreciated.

I am running a report that covers the last two fiscal years. I want all the data for the last two years. The...

Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime. It's not like...

The problem with this approach is that it can be very expensive,...

dimpythewimpy (9/27/2016)

---

Also, the reason I was unable to window function from the link above is, it does this:

basically...

rishakin (9/26/2016)

---

Hi,

Problem Statement:

I have 2 tables say Table1 and Table2. They both have fields Number and type. But the numbers across the table should be reordered sequential when user clicks...

ZZartin (9/27/2016)

---

WITH TEMP_CTE AS(

SELECT NameFrequency.Name, NameFrequency.Role, RoleRankLookup.Priority, SUM(NameFrequency.Count) AS TOTAL, RANK() OVER(PARTITION BY NameFrequency.Name ORDER BY SUM(NameFrequency.Count) DESC, RoleRankLookup.Priority ASC) AS RN

FROM (VALUES('Jack', 'Student', 3),

('Jack', 'Teacher', 5),

('Jack', 'Admin', 2),

('Jack', 'Student',...

Jacob Wilkins (9/27/2016)

---

The Dixie Flatline (9/26/2016)

---

you should specify the window frame (generally ROWS UNBOUNDED PRECEDING), because the default is RANGE UNBOUNDED PRECEDING, and which is much slower than specifying...

Luis Cazares (9/26/2016)

---

I can't picture a situation in which a CASE statement could be the only option in a WHERE clause.

I, however, can see a lack of understanding of SQL....

pietlinden (9/26/2016)

---

If the reason for your loop is to implement a running total, why not just use a Window function and do something like

SUM( <column to be summed> )...

dimpythewimpy (9/26/2016)

---

I am trying to implement a while loop and if condition (with a function call) in a case statement. Basically, I am trying to do this:

begin

case

when (condition1 and condition...