mtassin (5/3/2012)

---

Hmmm it's not working for me though when I try to make it work with my table.

I'm sure it's my not getting your case statement, but I keep getting...

Where are you hosting your .bak? I'll take a look at it sometime tonight if I can.

I wasn't aware it had been deprecated, and reading on BOL I still don't think it has.

I do agree that CROSS JOIN is better than a comma, in this case...

Something like this?

DECLARE @date DATETIME = '9999-06-05 21:13:49.907';

SELECT CAST(DATEADD(n, CASE WHEN @date > ending THEN DATEDIFF(n, ending, @date) ELSE 0 END,

...

mtassin (5/3/2012)

---

You could you know... mock up fake data that's entirely made off the cuff. Then based on the output use the same said data to show what the...

blandry (5/3/2012)

---

Hi Cadavre,

SUCCESS! Your first block of code works - no errors.

Do I need to try the second block if the first one works? (For now, I wont...

blandry (5/3/2012)

---

Nope, doesnt work...

This is the error I get...

Msg 8120, Level 16, State 1, Procedure usp_rpt_AgingProfile_Test, Line 37

Column 'c.modDate' is invalid in the select list because it is not contained...

kate-395233 (5/3/2012)

---

Thank you very much!

This is how I modified it (I don't have access to the master db) - and added more rows

DECLARE @count INT

SET @count = 1

DECLARE...

lanky_doodle (5/3/2012)

---

I have added another table, CASES.

What I want to do is count all the cases a user has. At the moment it (correctly) shows the number of cases for...

From BOL.

Best Practices

---

Do not use table variables to store large amounts of data (more than 100 rows). Plan choices may not be optimal or stable when a table variable contains...

lanky_doodle (5/3/2012)

---

Hiya,

I have a table that contains the name type of a user, and a table that contains the user;

NAMES table:

NAMENO | NAME |...

My bad, was being...

michael vessey (5/2/2012)

---

Cadavre (5/2/2012)

---

michael vessey (5/2/2012)

---

depends if you need a BIGINT or not - i'd suggest just using yours for anything when max-min > 32,767 - otherwise use the nice...

michael vessey (5/2/2012)

---

depends if you need a BIGINT or not - i'd suggest just using yours for anything when max-min > 32,767 - otherwise use the nice small (low resource)...

WITH CTE(n) AS(SELECT 1

...