Here's the approach I would use:

SELECT

t1.id,

t1.fromdt,

t1.todt

FROM [test2] t1

WHERE EXISTS

( SELECT 1

FROM [test2] t2

WHERE t1.id ...

Would the following dynamic SQL help you?

DECLARE @sql VARCHAR(6000)

DECLARE @sql1 VARCHAR(500)

DECLARE @sql2 VARCHAR(5000)

DECLARE @sql3 VARCHAR(500)

SET @sql1='

;with cte_group_of8 as

(

SELECT

ROW_NUMBER() OVER(PARTITION BY claim_id ORDER BY cast(left(claim_sequence_numbers + '','',charindex('','',claim_sequence_numbers)-1) as...

Would you mind shring your solution? We might be able to improve it even further.

As a...

m.dunster (7/12/2010)

---

Ok, when I use the term 'adapted', what I really mean is change the table names to suit my database. 😀

Through your example for creating the data...I have learnt...

Would you repeat that face to face with Gail? (assuming she can hear you and doesn't still have that bee swarm sound in her ears...)

Congrats to everyone from Spain to win the Soccer WC for the first time!!!!!

The first half wasn't as excellent as expected but it went better and better starting with the...

Jeff Moden (7/11/2010)

---

lmu92 (7/11/2010)

---

A few more things to notice:

I'm not sure how the functions to_char and to_date are written, but I guess both can be replaced by the built-in function...

One thing to start with is to read through the forum you posted your question in.

You'll find numerous threads with a large variety of replication errors...

Regarding prerequisites: you should read...

You could use a subquery or CTE to get the roles per fname (including the user_id from the user_role table) and join that back to the user table. Based on...

The concept is rather simple:

the CTE or "common table expression" is nothing but a subquery (at least in this case), just easier to read.

The purpose is to number your rows...

Unfortunately, it's still not clear how to identify "the first" row you want to keep.

When building the #tempGlMastDesc table you end up with duplicates but without any sorting criteria that...

Why would you need to store the result of the calculation in a table (even during import)?

Wouldn't it be easier to use a view to display the profit or a...

Ok, here's the code including test data setup.

Please note that there a few people around (including myself, usually) who expect sample data in a ready to use format (as shown...

Assuming you don't have an additional column that will number your rows starting with 1 you could either use ROW_NUMBER() or subtract the min(DATE) from your DATE column and add...

Looks like you're trying to build a calendar table.

You should add a column with datetime format to make it easier to recognize the date. You could do it by using...