I know Jeff will shoot me for this... 🙂

I did some other tests and finally found a high performant solution with CLR. Due to the fact that CLR functions do...

Hi Jeff!

I'm not sure if "nice" should...

Hey Paul!

Was only for the sample to make everything available. I have a real tally table in my...

Bob Hovious (4/12/2009)

---

Flo: I'm not at my laptop right now, so I can't test your code. I'll do so at the earliest opportunity. ...

Hi

Thank you for all this feedback!

...hope my internet stays alive since I answered all the questions...

Greets

Flo

I know what you mean... 😛

Article is bookmarked! 😎

Greets

Flo

Hi Paul

Thanks for the link, great article!

Greets

Flo

Hi

Have a look to GSquared's article about audit triggers: Audit Trails and Logging Part II[/url]

There are also some other articles on this site depending audit tables.

Greets

Flo

Hi

It depends. If you are new in SQL Server but already work as DBA then I would say "Yes". At least have a look for the main functionality to automate...

Jeff Moden (4/11/2009)

---

Florian Reischl (4/11/2009)

---

Hi

Try to handle it with a PIVOT operator.

Greets

Flo

PS: Maybe have a look to the "Best Practices" link in my signature for posting sample data and DDL....

Hi Andrew

1 The volume of testing and the test coverage of SQL statements - both embedded and stored procedures.

In my experience of dotNet/SQL n-tier business application the code is...

Hi

In addition you have to enable TCP/IP in Configuration Manager. By default only shared memory is enabled.

Edited: Maybe you have to restart the service after that.

Greets

Flo

Hi mister.magoo

Nice solution! So let's add the CROSS APPLY solution for the completion 🙂

DECLARE @t TABLE (Name VARCHAR(30), Reading INT, Result INT)

INSERT INTO @t

...

GilaMonster (4/11/2009)

---

Florian Reischl (4/11/2009)

---

I remember a case my apprentice told me from one of his teachers, the "IF-loop". Sure a slip of the tongue, but anyway:

DECLARE @i INT

SET @i =...

Hi Bob!

You should have a look to the new XML functions of XML data type. MS introduced the OPENXML in SSE2k; but they...