Dizzy (4/21/2009)

---

I am working with an application that lets me create filter lists of data for display in a dashboard using SQL statements.

The filter and dashboard components of...

Now, wait a minute... concatenation is usually a mistake. What is this for (ie, business reasons other than "it's a requirement") and why do you need to do it...

YSLGuru (4/16/2009)

---

How To Display Phone Number Formatted

How To Apply Mask To Phone Number

Q: How best to display a phone number that is stored raw (without any formatting or delimeters) and...

Bob Hovious (4/17/2009)

---

Good point, Jack. Although we do formatting at the db level for consistency, if you just stored phone numbers as integers, you would trim fat...

vkoka (4/22/2009)

---

thanks for giving reply. in result i want

-----------------------------------------

actuals/budget | Revenue | Month | year |

------------------------------------------

Actuals |100 ...

Heh.... never mind... I didn't read down far enough.

Goldie Graber (4/20/2009)

---

As a post script, I ended up using Bevan's method.

It works well on tables with up to a few million records. Takes a minute or two.

When I had...

I've been very disappointed with every outsourcing venture we've had, so far. Examples include such things as code that has UDF's that call 4 levels of UDF's and things...

Heh... no need to be sorry... it's a very common typing mistake that I occasionally make myself. The names are...

Try Master.sys.SYScolumns instead... it contains at least 11,000 rows which will produce up to 121 million rows with a single cross-join. And, although it looks fine, double cross joins...

Thanks, Manie. I sure do appreciate the feedback.

Bob Hovious (4/21/2009)

---

Flo and Jeff, I just had to try.

This beast features double-barelled carburetors.... errrr tally tables.... one with two columns, and nested CROSS APPLYs.

Can you...

Absolutely... see the following article (Look for "One final split trick")...

http://www.sqlservercentral.com/articles/TSQL/62867/

... and the following post where many, many different solutions...

Paul White (4/21/2009)

---

Morning Flo!

On first look, the performance improvement is down to the QO choosing a much more sensible plan when a VARCHAR is used, rather than a MAX datatype....

Like I've told others, I learn something new from each thread I read. I've...