You haven't said what happens when you use RTRIM...so I will guess that the lack of a column name is upsetting it...

select RTRIM(status_code) AS status_code from status_codes where delete_ind =...

Brilliant answer Jeff!

I like this a lot, but every time I see NEWID() used like this it just makes me yearn for a decent random number generator so that you...

If I understand correctly, I don't much like the idea of using the values in the xml as column names....

If however, you just want to get the xml data out...

I offer this...

;WITH DATA

AS

(

SELECT

K9ID,

RxStartDate,

MedID,

Dose,

Frequency ,

...

My 2p worth:

Jeff has shown you a framework for generating numbers.

I personally think you could consider generating more numbers and disallowing any with any repeating digits.

You should probably consider...

Jeff, that is an interesting take on Random..... :w00t:

The first ten codes in the sample I tried...

10000180

10000F52

10001875

10001D17

1000221F

10003478

100035E7

10003763

10006415

100081B2

Is there some bias towards groups of characters in that solution ....

Or am I...

I have minimal experience of EF in one project, and it works just fine,

although it is not being subjected to that much workload.

I would point out though, you can...

Thanks for the feedback.

Just a small point, but worth noting....you should really use quotename() to protect your field names ... I have modded below.

Stringzz (5/4/2010)

---

I was able to create...

If the field names are truly dynamic then you need to follow Lutz's advice and go down the dynamic route.

I have a question: If you cannot know what the field names will be and they can change, are you only selecting one row at a time?

Otherwise you are...

It sounds like you have missed the "type" part of the for xml path('') statement...

yes, you just want this in your connection string instead of UID and PWD

Trusted_Connection=Yes

Yes, just like in 2005, you can add support for DTS to 2008.

SET NOCOUNT ON

SELECT @NewTagID=ID FROM mt_tags WHERE tag=@tag and type=@type

IF @NewTagId IS NULL

BEGIN

INSERT INTO mt_tags(tag,type)

SELECT @tag, @type

SET @NewTagId = SCOPE_IDENTITY()

END

also, can you clarify if tag+type is unique or is just tag unique?