But that means i have to write update 31 times. Can't this...

Thanks Luis. That work.

When i tried the above query i was getting the below error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=...

Yup you are right. I had figured it out. i was not knowing that we are able to used from with update. Between thanks for reply:-)

Antony i tried your first solution it is working but it is showing me only the value of A. It is not showing subsequent rows i.e not showing me...

Thanks Gila And Grant. i was able to find the answer through sys.dm_exec_procedure_stats but when i tried for sys.dm_exec_query_stats , over here how can we specify whether we are searching...

Over here operation can be just select,update or delete.

Jeff Moden (8/10/2012)

---

Shadab Shah (8/9/2012)

---

Hi all,

I have come across various section on this website where it is mention that SQL Server is a set based programming language.

My understanding about...

I really appreciate you for your answer thanks. And the output was the same as i was thinking.

Since i am a newbie , i am having some problem while trying...

Thanks that help 🙂

yeah i was expecting functional requriment. But again the new question that comes to mind is if we do have an alternate solution then why unpivot and pivot.

Since i am...

So does that mean that Surrogate Key is only the concept. And in lay man terms(i.e. mine) can we say that PK=Surrogate Key.

If the above is true that what is...

I would again try to make to understand what i am trying to achieve.Since i am a newbie , the first thing they teach to me was C.

I was trying...

Hi,

I might not be able to put my question in proper way so let me put the same question other way around.

-------- //some logic

-------- //some logic

where empid = (select empid...

I tried your query but it is not working for me. This query does not overwrite the existing value in emp2 but it adds additional records. I want something which...