Hi John

Two things:

* First: You can change your nickname if you click "My Account" in header section.

* Second: Please attach your XML as file. 😉

Greets

Flo

Hi cdunn

Thank you! Currently I plan a completely new and probably much faster version without any wrapping.

I just needed this a possibility to format VARBINARY to hex string and I...

Hi Robert

I fixed the bug. I just don't know when they update it.

Thanks again

Flo

Hi jsanborn

jsanborn (4/1/2009)

---

I'm not making judgements or trying to insult anyone's intelligence, but the sample I posted should be self explanatory. It's the people who can look at the example...

Hi Mike

I can't thank you enough. I had a little trouble, banged my head a few times, and then realized that I had to type the word "use" and...

Hi

Try this:

;WITH data (id, col1, col2, col3) AS

(

SELECT 1, 3, 4, 5

UNION SELECT 2, 1, 2, NULL

...

Hi

There are some little issues in your sample but it was possible to fix...

What I don't understand:

* What is the link between the territories and the funds? I just applied...

Yes, this helps! 🙂

You have SQL Server Express and you have a named instance of SQL Server with name "SQLEXPRESS"

So go back to my command line steps and replace the...

Aha ?!?

Did you try the solution GSquared suggested?

CREATE INDEX IX_iv00101_USCATVLS_2_3_4 ON iv00101 (USCATVLS_2,USCATVLS_3,USCATVLS_4)

Greets

Flo

Well... strange.

In the braces behind the "SQL Server" is there exactly the "MSSQLSERVER" or something else?

In Configuration Manager please expand "SQL Server Network Configuration" in tree and select "Protocols for...

For fun? Here is no place for fun!!

... but there should also be a CTE solution:

WITH

schools (id, name) AS

(

SELECT 1, 'school...

Hi Mike

So let's keep on rocking... 😛

Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Configuration Manager

On left hand select "SQL Server Services"

In detail view on...

If you want to create an index on a view it needs to be schema bound.

Greets

Flo

Hi

Try this in lines 600 to 611 of your procedure (starting from ALTER PROCEDURE):

/**** Update Practice from historic GP record ****/

UPDATE NSTS_Matching_Outpatient

SET

NSTS_PRACTICE = GP.PRACTICE_CODE

FROM

...