Its time...

Phil Parkin (4/3/2013)

---

shalinder.verma (4/3/2013)

---

I agree with David. The title was misleading and I got upset before reading the article and got angry after reading the article, save 'holy moly guacamole'....

I agree with David. The title was misleading and I got upset before reading the article and got angry after reading the article, save 'holy moly guacamole'. 😛

That...

This is a good article for the beginners. Great work Andy!

I would also stress on looking at Merge TSQL statement. Have used it quite a few times. It would be...

Thanks Chris for a quick reply.

This looks to me that we are breaking a string in multiple rows and then putting the components back on the same row using MAX...

Great work.

I have another problem on same lines.

Instead of having all the resultant split pieces in one column and multiple rows, how about splitting it into multiple columns in same...

Eugene,

Thanks for all the hard work.

First of all, I was comparing the "on the fly tally table" SQL with "Recursive CTE" SQL. Therefore, my phrase "more efficient" should be...

Eugene Elutin (10/17/2012)

---

shalinder.verma (10/17/2012)

---

If you are familiar with recursive CTE, you can use following SQL. You won't have to refer to any tables. Moreover this is much more efficient. Try...

If you are familiar with recursive CTE, you can use following SQL. You won't have to refer to any tables. Moreover this is much more efficient. Try it.

DECLARE @StartDate DATE...

I was facing similar problem but was managed to solve the problem.

My environment:

Vista Professional

SQL 2008 Express

Steps:

A. Fix Report Target Server URL.

1. In the Solution Explorer, Right Click Report Object.

2. Click...