Hi

If MIN is not the solution you are looking for you should take GSquared's solution with a CTE.

Greets

Flo

I'm a city guy from here but Munich is a very green city with many parks.

Anyway, 30 minutes to some nice lakes and 45 minutes to the Alps is really...

Proudly present my personal hall of blame #1:

nested row_number () function

:pinch:

:sigh:

This script definitely becomes part of my hall-of-blame.

Next version up and (hopefully) running

Flo

mmunson (5/14/2009)

---

Can I get your opinion? Is my script pretty beginner stuff? I was just wondering because I have no frame of reference, I'm the only one in...

:w00t:

Maybe I should shutdown my system and go to bed... 😛

Changed the script again.

Greets

Flo

Oups, sorry. I forgot the "AS" at the end of the second line (as most times... :hehe:)

I just corrected my previous post. Now it should work.

Greets

Flo

Hi

I would use a CTE to encapsulate the CRM_STATUSCODES and join it instead of the table.

; WITH

status_codes (TransactionId, End_Date, System_Status, RecId) AS

(

select

...

Hi

I would use GROUP BY and MIN.

DECLARE @t TABLE (GroupId INT, Subgroup INT)

INSERT INTO @t

SELECT 1, 11

...

I would also use old-school batch files (or new-school power-shell files).

If you want to use a tool try FileZilla.

Greets

Flo

😀

Didn't notice.

Hi

It's very hard to help without some sample data or more information. As you say the trigger (part you posted) doesn't generate a syntax error. So it depends on your...

Psst, Lutz. Remove the "[" at the end of your link 😉

Hi

The right time for stored procedures? After the connection opened in your application.

It seems to be an overkill at the beginning to do any data-access (SELECT/INSERT/UPDATE/DELETE) within procedures. Some reasons:

1.)

Keep...

Hi

30 million users? Congratulate to your sales management! 😛

I don't understand the specific problem. Do you have duplicates which have to be removed? Do you want to know how you...