David Jackson (9/5/2008)

---

I know this is nearly two years late, :w00t: but I've just spotted this. What an excellent addition. I'll test this avro and post it with due...

[font="Courier New"]DROP TABLE #Temp

CREATE TABLE #Temp ([Code] VARCHAR(6), [Panel No] INT, [Bay No] INT, [Closing Code] CHAR(1), [Test Product] VARCHAR(3), [Oil Quality] INT)

INSERT INTO #Temp ([Code], [Panel No], [Bay No],...

Something like this will do it. You may have to fiddle with the token size and the match level cutoff to match your data.

[font="Courier New"]-- Create some sample data

CREATE TABLE...

Hi Robero

Thanks for the feedback. I would however read very carefully the wise words of GSquared, he's absolutely right. If you are in a position to alter your schema at...

Hi Robero

Looks like you've got a little confused with SQL Servers' proprietary variable update, typically used for running totals and other operations where sequential data is updated according to values...

I reckon your join columns are nvarchar and int...and there's an nvarchar value too big to implicitly cast as an int...

Bill Mell (9/3/2008)

---

I have to run the query against a join of two base tables.

The Datetimex, RecID and ID columns are in one table, the HandleID in another.

The tables are...

Bill Mell (9/3/2008)

---

Where else would it get the number from if not from a bigint column.

the number is to large for an int.

I would think the important issue would be...

Is it a partitioned view? Or to put this another way, are the values for RecID from one table...

Have you tried dropping and recreating the view?

Bill Mell (9/3/2008)

---

declare @test-2 bigint

select @test-2 = MAX(RecID)

FROM DBO.DATAVWOBJACCESSINFO

WHERE DATETIMEX <= '9/2/2008 10:45:03 AM' AND HANDLEID = 2964 AND ID = 567

select @test-2

This fails every time, The RecID...

Bill, can you please post some or all of your query? It's impossible to deduce why an nvarchar value is being converted (to whatever) from what you've posted.

BOL states that...

The spreadsheet sample of how you want your data to look shows one output per role, and one output not associated with any role.

What is your logic for deciding which...

Check that this matches the query you posted, which was a little garbled:

[font="Courier New"]SELECT headcountdec.StaffNo, headcountdec.CallName, headcountdec.Surname, headcountdec.BranchID, headcountdec.Branch,

   jpRoles.Role,

   jpOutputs.Output, jpOutputs.Weight, jpOutputs.Activities

FROM jpRoles

INNER JOIN jpProfileRoles

  ...

Jeff Moden (9/2/2008)

---

I'm pretty sure you don't need PATINDEX if you prewrap the string to be split in delimiters... please see the section titled "One Final "Split" Trick with...