I merely suggested changing the existing table and then...

What does that mean? The number of explicit transactions? The number of implicit transactions? Both? What exactly are you trying to find?

Like this.

SELECT COUNT(ID), Prog

FROM tblCount

GROUP BY Prog

Once you add another join you are quite likely going to get a different number of rows. That is why your counts changed.

Your description is extremely vague to say the least. Do you an insert trigger on Table1 that inserts data into Table2? And you also have an insert trigger on Table2...

Not sure why you want to create a new table and copy all this data into it, especially if you the point of this is to save space. Alter the...

Hi I see that you are pretty new around here. From what you posted there is no chance anybody can offer much help. Take a look at the first link...

It is rather difficult to offer a very solid solution because there are so few details posted. From your description though I don't know how you would be able to...

It is pretty much impossible to provide any assistance from just a query and a screenshot of an execution plan. Take a look at this article from Gail. It explains...

computer.mike (12/4/2012)

---

So I am updateing one record, my update statement returns three records. Normally I would expect to see an error. But my record is being updated. ...

Melanie Peterson (12/4/2012)

---

Thank you. How about FULL TEXT searching? Microsoft says it's faster than the equivalent LIKE statements. I've never used it. Is it worth looking into in this...

I can see a lot of things wrong with that query.

Let's start here.

CASE

WHEN STG.cde_pol_stat_gaaa = 'A'

THEN (

SELECT MaxDate

FROM stg_GENESIS_gaaa_t a

Can the subquery return more than 1 row? It...

nikki123 (12/4/2012)

---

We have excel with 4 colums

5 nth select columa column b

10 5.16 ...

Not 100% sure what you are trying to do here but I think you are trying to implement...

I have an app that I'm adding a generic search function to. The user types in a word, or phrase, or portion of a word, and all items matching this...