Based on that screen shot, if you change your PARTITION BY to this, it should work

(PARTITION BY TROJNUMMER ORDER BY SASONG DESC)

(obviously, the various accented characters need to be substituted...

SELECT *

INTO Newtable

creates a permanent table called Newtable. So if you run it again when the table already exists, you get an error because the table cannot be created again.

If...

Kristen-173977 (10/15/2015)

---

fernando.arias (10/15/2015)

---

--- But it gave me this message:

Msg 336, Level 15, State 1, Line 5

Incorrect syntax near 'Fernhl'. If this is intended to be a common table expression, you...

fernando.arias (10/15/2015)

---

Hi

I am having some problems coding with sql. Very new at this. I'm using sql server 2014.

Anyway, I want to clean my table which have seveal duplicates in the...

What version of SSIS are you using?

I run the exact setup you describe and it works fine. No issues.

PSB (10/14/2015)

---

I am not getting distinct values .

CREATE TABLE #ListString

(

JobNo VARCHAR(10),

InvNo VARCHAR(MAX),

Address1 VARCHAR(100)

)

INSERT INTO #ListString ( JobNo, InvNo,Address1 )

SELECT '3079', 'abc' ,'Add1'

UNION ALL

SELECT '3079',...

Use the FOR XML PATH technique described here.

PB_BI (10/14/2015)

---

To get the column name is a bit fiddly but possible (unless you have a time machine and are using SQL 2016 where it's been made simple finally[/url]. Also,...

And now I just got this warning in Gmail, for a "SQLServerCentral.com - New Topic " e-mail:

This message could be a scam. The sender's account may have been compromised and...

Felix Pamittan (10/14/2015)

---

So that's why I received an email saying:

A new reply has been added by CELKO to...

The error message does not say what went wrong, so I don't know whether anyone can help much without more information.

Did you check whether you have sufficient disk space for...

botta.5283 (10/14/2015)

---

Hi All,

please find the below is my requirement

how to fetch data from oracle database in sql server 2014

example

----------

oracle schema :t1

sql server :t2

now...

rajarajansudar (10/13/2015)

---

i need to write condtion like this

if ( System ID =="RE2")

{

Account_num +"-"+ coulum

}

i wrote in SSIS like below

System ID ?...

Sounds like something is setting this value.

If you click once on the CM and then get properties, can you check the 'Expressions' property – is there anything in there?