Hi Nugby, try this. But let me warn you, this is a crooked way of doing it.

And it may not give good performance for large tables (see the functions...

Try this:

create table #t(customernumber varchar(10), notes varchar(10), lastvisitdate smalldatetime)

insert into #t values(100000, 'text 1', '10.feb.2010')

insert into #t values(100000, 'text 2', '10.feb.2010')

insert into #t values(100000, 'text 3', '10.feb.2010')

;with cte as

(

select customernumber,...

Lester Vincent (3/21/2010)

---

Thanks Jason. I tried installing the REporting Services Component from my Dev Edition CD but it was not listed among the Components. ...

Hey Ray, have you been to Bangalore? I think there are only a few people from Bangalore in SSC (yet to find another one). 🙂

Hey I am from Bangalore, India 🙂

Hey I didn't quite understand your question. What are you trying to do here?

Copy and process some data from existing tables, based on some conditions and insert the result...

Why can't you use XML here instead of the table approach? I think it will be more elegant.

create table #t(membername varchar(10), uniquenum varchar(10), id int)

insert into #t values('abc', '4567A4', 1)

insert...

Hey thanks for the time Paul. I will watch what I write here. I think it is important not to mislead other people who refer to the forums. I will...

Sorry, but I really want to nail this down. Bear with me.

Are you saying it is faster to copy to the rows to a temporary table, and add the...

Paul White (3/15/2010)

---

Arjun Sivadasan (3/15/2010)

---

Ya I have tried that (the temp table approach on queries that return ~40k rows with performance improvement from 10 to 2 secs. Of course, with...

Ya I have tried that (the temp table approach on queries that return ~40k rows with performance improvement from 10 to 2 secs. Ofcourse, with the addition of index) Paul....

Hi Steven,

Is this what you need?

create table #t(col1 int, col2 int)

insert into #t values (1, 10)

insert into #t values (2, 55)

insert into #t values (3, 68)

insert into #t values (4,...

pablavo (3/8/2010)

---

Hi there,

I'm working on a very complex report and want the running time to be as minimal as possible. the report displays financial data and will be used...