There are 2 links in my signature...

What do yo mean by testing the database? Are you looking to test your stored...

Hi and welcome to SSC. Can you please try to explain what it is you are trying to do? From your description I cannot figure out where to begin.

Thanks for posting ddl and data. Can you explain the logic here? All we have is a few tables with a few rows and very cryptic names and values. There...

Or you might check the articles in my signature about cross tabs. The techniques there will generally beat PIVOT for performance.

What is the logic...

Denise McMillan (6/10/2013)

---

The results I'm trying to get are:

proc_id dtime proc_num result

70360 ...

Obviously you did not read the article about best practices. The idea here is provide ddl and data in a consumable format. That way we are not left guessing datatypes...

Evil Kraig F (6/10/2013)

---

Sean Lange (6/10/2013)

---

Evil Kraig F (6/10/2013)

---

I don't argue with H.L. Mencken's philosophy, but noone ever got rich trying to make a spreadsheet software using a pac-man interface,...

Evil Kraig F (6/10/2013)

---

I don't argue with H.L. Mencken's philosophy, but noone ever got rich trying to make a spreadsheet software using a pac-man interface, either.

If you can't trust your...

@RDBMS (6/10/2013)

---

With MERGE I want to know whether I can do something like this:

MERGE <table name> USING <sql>

WHEN MATCHED THEN

IF (condition) Then (Update Query)

When NOT...

MERGE is exactly what I would use here. I am not sure I understand your reservations about using MERGE for this.

If you want specific coding help we need you to...

That's funny....until now I never even noticed there is a jobs link. 😀 I would still recommend finding a local recruiter and scouring the newspaper and other online job sites.

arun1_m1 (6/10/2013)

---

Hi,

For the past few days I have been applying to the jobs posted on SSC. But I am not getting a single call from the employer. The job description...

J Good (6/10/2013)

---

Yes, the above...