dwain.c (5/29/2012)

---

I am curious why you think this may be solvable with a recursive CTE. I am unable to come up with a recursion formula that would satisfy the...

Well, Joe, thank you once again for pointing out the obvious. However,...

Are you just trying to lop off the zeros to the right of the decimal place? If so, you could just convert to DECIMAL with 0 decimal places. ...

What kind of database will it be? If you are simply looking for any database, perhaps Adventure Works might serve you well.

Thank you all so much for the feedback. I did not realize there were so many things to consider.

I'm just curious, how many rows are there, and how long does it take to run?

Amy, as long as you are comfortable with it. At my last job I was the only one person who did anything at all to our SQL Server. ...

If it were me, probably not. Let's say you have a table with col1, col2, and col3. You create a procedure...

Well, we never could get Viewfinity to make SQL Server think I had admin rights. The only way to solve it was to have the IT guy temporarily restore...

I've never messed with indexed view or schema binding, but the error message seems to indicate it does not like the aggregate functions. You could try wrapping the whole...

Thank you Alex for the reply. I believe you are dead on. After I posted, I went back and re-read the email they sent (in its entirety this...

Are you sure you're using SQL Server?

Edit: DOH! Really should learn to read the rest of the posts before I post annoying redundancy.

Peter, I looked at the link you provided for the lookup table, and decided to create a permanent table to use in the function. I also tweaked it to...

Not even the least bit disappointed, indeed just the opposite is true, as not being able to see the tables is a minor issue. I built a full table...

Peter, thank you so much for taking your good time to work on my problem, I am truly humbled by your knowledge.

Peter Brinkhaus (1/13/2012)

---

What's the data type of...