This can easily be done using a tally table. The problem is that it is not clear what you want to do here. You say there should be 48 new...

Ed Wagner (1/6/2016)

---

Brandie Tarvin (1/6/2016)

---

Sean Lange (1/6/2016)

---

Wow. I rarely have to deal with user issues but I was just on a phone call with one of our own people having...

Steve Jones - SSC Editor (1/6/2016)

---

Sean Lange (1/6/2016)

---

Wow. I rarely have to deal with user issues but I was just on a phone call with one of our own people...

Wow. I rarely have to deal with user issues but I was just on a phone call with one of our own people having an issue with our website. I...

Ray Herring (1/6/2016)

---

I am sorry that I fall short of your expectations and apologize for not meeting your standards.

I will of course, bow to your superior knowledge and refrain from...

We try to go beyond just answering the OP's question around here. We try to share our...

Ray Herring (1/5/2016)

---

The syntax error was because you have a select sub-query

Select @Return = Select ....

Your second Select needs to be in parens

Select @Return =...

Hugo Kornelis (1/5/2016)

---

sandesh_krishnan (1/5/2016)

---

More details .....

I have a T-SQL query provided by users of our data, which goes after multiple tables and generates an output. There are multiple queries...

sartis (1/5/2016)

---

Sean Lange (1/5/2016)

---

sartis (1/5/2016)

---

Sean, Thanks for trying to help. So the page in my web app where I want to display this timeline is called details.cfm . It's a...

sartis (1/5/2016)

---

Sean, Thanks for trying to help. So the page in my web app where I want to display this timeline is called details.cfm . It's a page where I...

sartis (1/4/2016)

---

Sean Lange (1/4/2016)

---

This is much better. Thanks.

Now we have the next challenge which I asked previously also. Is there something that states which row(s) from sh_asset belong to...

This is much better. Thanks.

Now we have the next challenge which I asked previously also. Is there something that states which row(s) from sh_asset belong to a given stakeholder?...

sandesh_krishnan (1/4/2016)

---

Hi,

I have a procedure that returns different results(different number of columns and different datatypes) every time the procedure is executed. How can i capture the results of the stored...

sartis (1/4/2016)

---

Here is a select from 2 tables in my database:

SELECT TOP 1000 [email_id]

,[email_to]

,[email_cc]

...

sartis (1/4/2016)

---

I apologize, ok, so i have several tables I want to select data from, one of the columns in each table is a date column. So, I guess my...