May be he want to learn about sub-queries.

infexthenna (11/7/2013)

---

Select Top 1 Q.UniqueId From DataQueue Q Where (((Q.field1= 1) And (Q.Status = 'ND')))

And Q.Status Not In ('A', 'B')

And 0 = (Select Count(*) From DataQueue Where ImageId = Q.ImageId...

What about

select CONVERT(VARCHAR(12), getdate())

output of select getdate() is 2013-11-11 17:50:53.347

but output of select CONVERT(VARCHAR(12), getdate()) is Nov 11 2013 (+ 1 blank space)

So, is it one more typo of MSDN ?

select NULLIF(1,NULL) = 1 (Both values are not same, so first value)

select NULLIF(NULL,2) = Error "first argument has to be known"

select NULLIF(1,1) ...

GilaMonster (10/24/2013)

---

Most installation sets contain all editions. The edition that installs depends on the key that you use during set up. Some installations have the key embedded. To see which...

Agree. Not the best.

covering index will be a better idea...

Agree.

create your index on

yearno

periodid

select @@version

Also, the posted question should be clear enough, with all required details.

Rakesh.Chaudhary (10/24/2013)

---

Hi,

I am using Drop and create table in Loop because of results I want to achieve using loop. But my question is

Is this better to use Truncate table...

can also be shifted to CTE

Hugo Kornelis (10/21/2013)

---

crussell-931424 (10/21/2013)

---

I can't win on these. If you read it exactly as it is written then people complain that we should have understood what the question was really...

Welcome.