Only took a month, but attempt 2 posted: alan-berger.blogspot.com

Didn't work, but thanks.

Now I really screwed up the installation...no BIDS. Going to try to snare somebody tomorrow at a user group mtg.

I guess I still have SQL2sDay on my mind:

; with empTotSal (EmpID, TotSal) as

(Select EmpID

, SUM(Salary)

from forumPct

group by EmpID)

SELECT fp.EmpID

, fp.Division

, fp.Department

, SUM(fp.Salary) as DivSal

, SUM(fp.Salary) * 100 / ets.TotSal...

Thanks Jeff...going to work on that later tonight.

Besides using the profiler, is there any obvious (or not so obvious) way to get the QOH?

Truly appreciate your time!!

ab

Jeff...

Good point. I never would have thought of that as a concern. The full, safe, we know where that is url is

http://alan-berger.blogspot.com/2011/04/outer-join-subquery-cte-or-udf-you-be.html

But should I just...

Thanks again all. I am going through Grant's e-book. At the rate I'm going, I'll have this little side project done in the year 2025, but, hey, at...

I think that's one of the best piece of advice I've gotten,...

Thanks!

Awesome. Please let me know when the blog is posted. I'd appreciate a link sent to alanb.dba@gmail.com

Thanks!!

(and I'm all for shameless plugs!)

Thanks for the leads...Grant's book is exactly what I was looking for.

Quoting from Itzik Ben-Gan's T-SQL Fundamentals, Merge "allows you to modify data, applying different actions (INSERT, UPDATE, DELETE) based on conditional logic."

You have a source table and a target table,...

I'm also new at SQL, so sorry to jump in, but wouldn't a MERGE query (run from the 2008 side) work?

eugene.kr (1/9/2009)

---

dknaus, thank you so much for reply!

I played with textboxes in ssrs 2008, assigned it a value "i'm ", but it showed me markup, not bold text. Could...