You might be able to get away with the following:

INSERT INTO HFM_Auxiliar.dbo.HFM_Applications (Appname)

SELECT DISTINCT Appname

FROM hfm.dbo.HSX_DATASOURCES

EXCEPT

SELECT DISTINCT Appname

FROM HFM_Auxiliar.dbo.HFM_Applications

It shouldn't be common,...

Luis Cazares (4/22/2015)

---

This can be done with a recursive CTE. You can find many examples on the internet.

It should be something like this:

WITH RCTE AS(

select T1.a1, T1.a2, T1.a3,

...

Just curious as to whether you might be allowed to add the ROW_NUMBER() column to the table as a computed, persisted column... Might simplify things quite a bit,...

Sorry, my friend,...

Happy to have the consumable data, but unfortunately, me understanding your requirement isn't happening. I see two slightly different source tables, where one appears to represent amounts versus expected...

tcronin 95651 (7/8/2015)

---

the spikes I see are from my Idera and verified with perfmon. Had a consultant help sysadmins setup SAN, looks like we may have hired wrong guy....

OLSONEJ (7/9/2015)

---

This seem to be pulling beyond lapse periods. When I have the following, I am expecting a count of 3 not 7, which is what I am receiving.

INSERT...

Not really having the time to delve all that deep into your procedure, I can only guess what the objective is. However, one thing that folks often trip over,...

coachmkavanaugh (7/8/2015)

---

Steve, Is there an easy way to show the differences of the motivational type if I wanted to compare two or more meets together? The only thing that would...

If for any reason there were multiple lines for the same employee for the same code, you might want a SUM instead, assuming all such rows are valid ... ...

sudhirnune (7/7/2015)

---

Hi All,

We are having a requirement to Aggregate the data and create LY, CY data across 5 Metrics.

the Volume of Data will be 200 Mil - 250 Mil

Server Configuration:

Memory:...

coachmkavanaugh (7/5/2015)

---

Holy cow, thank you so much! This is very close!!!

There seems to be some duplicates returned from the query, sometime 2 times, other times 3, some 4 times.

Times...

SSRS Newbie (7/8/2015)

---

Hi Steve,

The solution you suggested is exactly what I need. Do I have to add extra column type to my table? If so, I can't add the column...

Best way to "pass it on", is to go ahead and post what the problem was, what you did to solve it, and the nature of...