Paul Hernández (4/22/2015)

---

That is the result of the UNICODE,

I would like to take some time to dig deeper on this and summarize all the information.

Thanks all of you for the...

I wasn't aware of UNICODE as a function, but it...

All I can think is that you have invisible characters. . .:ermm:

Mind trying to see what all of the character codes of the string are?

WITH CTE (...

Paul Hernández (4/22/2015)

---

Hi Tom, thanks for your answer.

Please forget my first post, I copied and pasted the query that SSAS issues, therefore contains this weird aliasing.

Here is a better...

Paul Hernández (4/21/2015)

---

Hi Cadavre,

your script is the best explanation I have ever seen for the ASCII characters an trimming functions. But that is exactly my problem, that the last position...

SELECT subQuery.N + '|',

subQuery.X + '|',

CASE WHEN CAST(ASCII(SUBSTRING(REVERSE(subQuery.N), 1, 1)) AS VARCHAR(3)) =...

I'd guess that you don't have a "Mr", "Ms", "Dr" in the column, instead it probably has white space. Also, if the column doesn't equal one of those options...

SELECT '5' AS 'value/@version',

'database' AS 'value/@type',

'master' AS 'value/name',

...

Weird.

If you make it "FORWARD_ONLY" and "READ_ONLY" (or FAST_FORWARD) then it works as expected (the execution plan has the full outer join and results are as expected).

I may be misunderstanding you, but does this help?

Setup -

IF OBJECT_ID('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

SELECT TOP 5

...

BWFC (4/15/2015)

---

PASSING PARAMETERS (not my father :w00t:)

create proc Parameter_Provider as

declare @login varchar(4) = 'BWFC'

declare @results table

(

col1 varchar(10)

,col2 int

)

execute sp_executesql Parameter_Recipient ---requires @login parameter.

--- I...

I've answered this question in the first post you made about this here --> http://www.sqlservercentral.com/Forums/Topic1676026-3077-1.aspx%5B/url%5D.

So, quoting myself: -

Cadavre (4/10/2015)

---

I knocked up a bit more sample data: -

IF OBJECT_ID('tempdb..#stagingTable')...

Sample data used: -

IF OBJECT_ID('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

SELECT TOP 10

IDENTITY( INT,1,1 ) AS ID,

...

jbalbo (4/10/2015)

---

Hi

I have a query where I want to select only the top record which meets the criteria from one of the tables (if any)

but want all the other...

vipin_jha123 (4/9/2015)

---

Hi All,

I am having one store procedure which use to load data from flat file to staging table dynamically.

everything is working fine.staging_temp table have single column.all the data stored...