Sean Lange (9/16/2015)

---

sgmunson (9/15/2015)

---

Sean Lange (9/15/2015)

---

sgmunson (9/15/2015)

---

Sean Lange (9/15/2015)

---

That could either strengthen the idea of not using the existing type or make the whole process a lot more complicated. Will...

Sean Lange (9/15/2015)

---

sgmunson (9/15/2015)

---

Sean Lange (9/15/2015)

---

That could either strengthen the idea of not using the existing type or make the whole process a lot more complicated. Will be interesting to...

Sean Lange (9/15/2015)

---

That could either strengthen the idea of not using the existing type or make the whole process a lot more complicated. Will be interesting to see what path...

Lowell (9/15/2015)

---

As a remember it, there is no valid syntax for ALTER TYPE. only drop and create.

i know that once a user type is in use, to change it, it...

Sean Lange (9/15/2015)

---

sgmunson (9/15/2015)

---

Question: Table definition uses user defined types for EVERY field (yeah, I know, but it's legacy). These aren't really "user defined types" in the...

Luis Cazares (9/8/2015)

---

It depends on the expected output. My code will return all...

Jeff Moden (9/6/2015)

---

@QQ-485619,

1. How many rows are in the actual table?

2. Which column is the clustered index on?

3. How often does this need to be done?

4. ...

Jeff,

The original poster's rules, no matter how they were stated, across ALL of his/her posts, are broken based on the data supplied and the expected results. It appears...

Munabhai (9/1/2015)

---

Thanks all. Special thanks to Luis C.

I got solution with the help of Luis C.

SELECT date1, date2,

CASE

WHEN...

Luis Cazares (9/3/2015)

---

It could be with something like this:

CREATE TABLE numerator(

memberid int,

measureid int

);

INSERT INTO numerator

VALUES

(1,501),

(1,502),

(1,503),

(2,501),

(2,502),

(3,501),

(3,501),

(3,501),

(3,501),

(4,501),

(4,502),

(4,503),

(4,504),

(4,505);

SELECT memberid,

measureid

FROM numerator

WHERE...

kevinp81 (9/6/2015)

---

Hi Guys,

Apologies for the late response - organising a first birthday is hard work!

Firstly, thank you both for your comments. Dennes, that code worked exactly on the example data,...

dan.tuma (8/21/2015)

---

Thank you SSCrazy.

I was able to adapt your code to what I was attempting to accomplish and it worked. I've been fighting with this for quite some time now...

candide (9/4/2015)

---

Hi,

I posted also in a CR-forum and there's another idea which I think maybe more flexible as I can use the CR-crosstab feature with no restriction (?).

As posted here...

ScottPletcher (9/4/2015)

---

You certainly don't need a calendar table for that simple a calculation! All you need is:

SELECT (DATEDIFF(MONTH, 0, @enddate) / 3) - (DATEDIFF(MONTH, 0, @startdate) / 3) +...

Dennes Spek (9/3/2015)

---

[p]Hi there,

I have made a recursive search for relations here.

What about this:

[/p]

Create Table connections(

from_node_id Int,

to_node_id Int,

)

Insert connections

Select 1, 2

Union All

Select 2, 3

Union All

Select...