SELECT *,'pedro' FROM VW_DEVOLVESELECCAO

appreciate that you have provided sample data....but in your "real" world and to ensure scalability for a solution...can you tell us approx. number of rows in @t table and confirm...

http://www.sqlservercentral.com/Forums/Topic917650-146-1.aspx

is this as simple as a cross join?

eg:

SELECT TOP 186 IDENTITY(INT, 4070039 , 37) AS lat

INTO dbo.lat

FROM ...

does your function return id or pallet?...this would possibly provide a "join"

maybe better if you posted create table/insert sample data scripts and your expected results...am sure this will result is...

may not be relevant ...but I beg to differ on duplicates in your test data

script

insert into dbo.salesquotestest values('QUO-10566-0', 'X16093', '10024', '2', ...

I think you have duplicate rows in the data...can you please check.

my effort...too much time on my hands 😀

DECLARE @Question VARCHAR(100) =

'The Answer to the Ultimate Question of Life, the Universe, and Everything'

DECLARE @Source VARCHAR(100) =

'The Hitchhikers Guide to the...

cbrammer1219 (6/14/2014)

---

I will give this a try in a little while, I appreciate all that have stuck through this post. I will mark answered if this is a solution or...

Jeff...+1 many times 🙂

if as OP was specific about "spaces"...heres a first cut ....may be a start??;-)

--drop table #tempcall

SELECT

ID = IDENTITY(INT, 1, 1),

RTRIM(LTRIM(REPLACE(REPLACE(REPLACE(REPLACE(SUBSTRING(calldata,0,7),'-',''),'%',''),'+',''),'/','-'))) as...

maybe I misread your requirements...but I thought that the week end date was a Sunday?

who set the requirement?

jorichard31 (6/13/2014)

---

Hi Team,

Select tmp.* from openquery( [LinkedServerName], 'select * from viewname1' ) as tmp. When I executed this query, I am getting below error. Could you please help?...

Sean Lange (6/13/2014)

---

While I agree that the DelimitedSplit8K function is likely to be of help here I want to point out that the datatype containing the csv data is varchar(max)...