Here's[/url] an excellent article which describes how to merge text/ntext datatypes.

Cheers

ChrisM

In that case, the article will show you how, with examples.

Can you explain how you expect to benefit from putting a simple query into a function?...

nabajyoti.b (1/2/2009)

---

what is a t-sql statement to store the sql results in an excel sheet.

suppose i have two valieables @s-2 and @b-2

normally i use select @a to display the value...

larsosman56 (1/1/2009)

---

Hoping for some assistance. I have been working this for weeks, looking into recursive CTEs, cursors, etc.

My first query returns a result set, but I want to pass...

Adi Cohn (1/2/2009)

---

When you use function in the where clause on the column, the server can’t use any index that was created on that column. Although the queries...

You're welcome. Is your problem solved?

I reckon this should do it.

[font="Courier New"]DROP TABLE #Temp

CREATE TABLE #Temp ([Month] CHAR(8), Country CHAR(2), [Tran] INT)

INSERT INTO #Temp ([Month], Country, [Tran])

SELECT 'Jul 2003', 'US', 1271 UNION ALL

SELECT 'Jun 2003',...

Can you post a sample of what you expect your output to look like?

Good lord Brandie, how do you find the time to do all of this stuff?

It's a...

josemyj (12/30/2008)

---

These values are chosen arbitrary by the decision support department depending of the way the butterflies move through the window when it rains...

So they are randomly chosen from a...

How does SQL Server get these values? One at a time? As a file/cursor?

josemyj (12/30/2008)

---

I didnt said they were consecutive, it was just an example. I have a 4000 rows table whose primary keys are used for filtering that way.

No 4000 columns... Only...

No need to apologise, we'll get there.

Your first post said you wanted a temporary table or CTE to provide consecutive...

So...you need a simple list of integers, from 1 to about 2000? Is there anything else?