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...

Have you tried putting a number in the Precision column to represent the maximum, err, precision of the incoming data?

How about something like this?

Create table #TestTable (EmailID Int, EmailAddress Varchar (100))

Insert #TestTable Values (101, 'Donald@Trump.com'), (102, 'Ted@Cruz.com'), (103, 'Hillary@Clinton.com'),

(104, 'Bernie@Sanders.com'), (105, 'Donald@Trump.com'), (106, 'Hillary@Clinton.com'),

(107, 'Donald@Trump.com');

WITH Ordered AS (SELECT...

Eirikur Eiriksson (4/18/2016)

---

Phil Parkin (4/18/2016)

---

Eirikur Eiriksson (4/18/2016)

---

No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any...