Looks like you have two instances of the DB engine installed.

One will be accessible by typing 'localhost' in the server name.

The other will be accessible by typing [machine name]\SQLExpress in...

Ed Wagner (4/19/2016)

---

Are you thinking something along...

Services, not servers.

You're...

Saying that something "doesn't work" in the...

DSNOSPAM (4/19/2016)

---

Sorry for being such a doofus on this. Only place I know to go look at services is under the Task Manager window after hitting CTL ALT DEL.

I've...

Did you run the code provided?

DSNOSPAM (4/19/2016)

---

version is:

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1...

Jeff Moden (4/19/2016)

---

Ken McKelvey (4/19/2016)

---

An alternative would be be have an XML column in the base table where user defined fields could be placed. This would give you the option...

DSNOSPAM (4/19/2016)

---

I've got SS 2008 R2 (developer vs I think) and 2014 Express loaded on my machine.

I'm trying to load the Adventureworks 2008 RS info I downloaded from Codeplex, but...

astrid 69000 (4/19/2016)

---

Hi,

I have attached an excel with a sample of the data.

I don't know what you mean by converting to varchar, inside of each nod there are different values....

nuno.fbo (4/19/2016)

---

Hi Phill,

Thanks for your feedback.

I think I only can use Object_Name() in a Select statement right?

Here in my example I need to use in FROM and WHERE statements

SELECT OSUSR_CYW_TED_EVENTS.[AMOUNT],

(select...

dave.jones 96182 (4/19/2016)

---

I always re-factor the CTE's when debugging them, for simplicity

;WITH CTE AS

(

SELECTID, Col1, Col2

FROMMyTable

WHERE...

)

SELECTCol1,

Col2

FROMCTE AS C

JOIN MyTable AS T

ON T.ID = C.ID

SELECTCol1

, Col2

FROM(

SELECTID, Col1, Col2...

Given an Object_Id, you can use Object_Name() to get the object's name.

To get the schema related to the Object_Id, use Object_Schema_Name().

While that will provide useful background info, this situation is crying out...

pvong (4/18/2016)

---

Phil - I'm sorta new so thanks for your help.

In both the derived col and conversion, I can not change the value in the Precision box. For the...