The out of memory error is most likely returned by SSMS or the client application that you were using. That happens when dealing with large results sets.

Your rewrite is correct,...

Why don't you simply store it as a date? It'll be more effective than a constraint.

If you seriously need a constraint, check the following article: http://www.sqlservercentral.com/articles/T-SQL/130558/

Ale

Good, but do you understand how it works?

Do you need something like this?

WITH CTE AS(

SELECT * , ROW_NUMBER() OVER (PARTITION BY IDENTIFICATION_CODE ORDER BY VERSION_NO DESC) rn

FROM [MY_TABLE]

)

SELECT UNIQUE_ROW_ID

...

gfx99ne (8/4/2016)

---

My understanding is, once you define the variable it stays in memory as long as same query screen is opened... and it perfectly worked for me in the past,...

What about using an OR?

select c1,c2,c3 From numbers

where c3 <> 'CP-961080'

OR c3 is null

Don't convert your dates into strings just to convert them again back to dates.

Send the variables as parameters in the dynamic query. You just need to use sp_executesql

Here's a cleaner...

You should also try...

whereisSQL? (8/3/2016)

---

Ed Wagner (8/3/2016)

---

Schizophrenia (just...

drew.allen (8/3/2016)

---

Luis Cazares (8/3/2016)

---

pnr8uk (8/3/2016)

---

What does the u in this line mean?

...

ntreelevel (8/3/2016)

---

Hi ALL,

I have a situation where I should round a col in a table

Ex

Units Desired Result

0.3 ...

pnr8uk (8/3/2016)

---

What does the u in this line mean?

( 5, Sales5))u(RowId,...

pnr8uk (8/3/2016)

---

Thank you Louis - I haven't used CROSS TAB before, makes life a lot easier than trying to use something not designed for transposing.

This is all I need I...

Is this what you need? Note that instead of pivot I'm using cross tabs and instead of unpivot I'm using CROSS APPLY.

SELECT RowId,

MAX( CASE WHEN ExSubCat...