Nope. You can add a...

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Use this excellent site to look up which CU matches the build:

http://sqlserverbuilds.blogspot.be/

One of the most important lines in the whole thread!

Scott Coleman (2/6/2014)

---

Now...

Nice, glad you got it solved.

Thanks for posting back the solution.

You used @tablename inside the dynamic SQL.

If you would print out @SQLStatement, you would see there is no declaration for @tablename.

You have two options:

* pass @tablename as an input parameter...

hoseam (2/6/2014)

---

I edited your query to this:

DECLARE @SQLStatement NVARCHAR(2000);

SET @SQLStatement = 'CREATE TABLE dbo.Hosea_tblDATA_NOTE (';

SELECT @SQLStatement = @SQLStatement + ',' + c.name +' '+st.name +' '+cast(c.max_length as varchar(50))

FROM sys.tables...

SrcName (2/6/2014)

---

maybe

select NOTE_ID, NOTE_DESCRIPTION, NOTE_TEXT, NOTE_STATUS, NOTE_STARTDATE

, NOTE_ENDDATE, NOTE_AUTHOR,...

It is dynamic SQL yes.

The concept is simple: you construct a SQL statement on the fly, store it inside a string variable and execute it with sp_executesql.

Add PRINT @SQLStatement right...

Ah ok, now I get it.

DECLARE @SQLStatement VARCHAR(2000);

SET @SQLStatement =...

Can't you use SELECT ... INTO?

Great question, thanks.

Phil Parkin (2/5/2014)

---

I tried the UNPIVOT transformation for this problem and after pratting about with it for a while in an attempt to make it work, I have come down...

You cannot use URLs in the for each loop/file system task.

You can use UNC paths (//servername/folder/), but not http paths.

You'll need to use the HTTP connection manager and a script...

OK, good to know.

I almost solely rely on networking when changing jobs.

When applying for my current jobs I few months back, I didn't even have an updated resume.

It was quite an awkward moment...