psuedocode sucks....when you abstract the real problem, you get crappy answers, that you end up having to explain lots of times till you come around to teh real answer. Show...

here's an example for you to look at:

stuff all values into a column

------------DDL----------------

create table test (id int identity, category varchar(100),

name varchar(100), allnames varchar(8000) null)

insert test (category, name)

select 'fruit', 'apple' union...

i think either your server is SQL 2000, or the database's compatibility level is still sitting at 80 instead of 90. the xquery is a 2005/90 feature.

change your compatibility level...

like others said, you have to JOIN the two aliased groups:

Select

ALIAS1.naam,

ALIAS1.Aantal_Incidenten,

--ALIAS2.naam, --now that they are joined, no need to repeat

ALIAS2.Aantal_Inc_Portal

FROM

(

select vestiging.naam, count(*)...

if you add a tally table, this is one of those magical Tally table wonders that extracts between two delimiters: it pulls out the ID and each of the Id's...

my fault... i was running the query in a database that was Compatibility level 80....duh!

Lowell (2/18/2009)

---

Jack I get an error when trying to test the code snippet you pasted...

Msg 156,...

Jack I get an error when trying to test the code snippet you pasted...

Msg 156, Level 15, State 1, Line 19

Incorrect syntax near the keyword 'CASE'.

I must be blind, because...

most likely this is related to installing an EXPRESS version ..express does not allow remote connections by default, you must enable it using the Surface Area Configuration Manager:

ok, what happens int eh case of a tie?...for code 75360412, two names have been used twice in your example

results:

code ...

you hit the reason on the head...Cost.....Developer version is not licensed for production.

imagine you have 20 developers on your team, building an application that will be deployed in production...each developer...

psuedo code sucks big time.

what does the REAL data look like? if you just want the first character, or do you want to strip out non- letter stuff fromt...

it's possible to connect to SQL server without using TCP/IP (you can use named pipes); so those named pipes users would not have an IP address available to query;

Just like...

when i use that script wizard in 2005 SSMS, i get an option at the end to script per file:

but i'll be darned if i see the equivilent in Tools>>Options...

Also could it be that the log file is being appended to instead of overwritten WITH INIT, so the big backup actually contains 30 or so regular 5 Meg backups...

unless you add an alias to the the tables from the other db, you have to reference them with the whole 4 part identifier in the select:

[ON_KEY_42R5_UDM2]..astAssets.ID,

not just...