Ed Wagner (6/16/2014)

---

GilaMonster (6/14/2014)

---

Yup, that's pretty much how I feel.

I have little interest in sport. Most of the time that's fine. This week, I can't...

Your query has an inner join between tables STG.personattribute (stg) and GDW.personattribute (tar)

which includes this predicate: Tar.AttributeID = stg.AttributeID.

The WHERE clause includes this predicate: ISNULL(Tar.AttributeID, 0) != ISNULL(stg.AttributeID, 0),

which...

There are a few hints in here which might help you on your way:

ALTER PROCEDURE [dbo].[TR_SearchTests_Counter_v2]

@REGISTER_IDint= null,

@PART_NUMBERnvarchar(50)= null,

@PHASE_NUMBERnvarchar(10)= null,

@TEST_NUMBERnvarchar(20) = null,

@PROCESS_ORDERnvarchar(50) = null,

@IS_VOIDbit= null,

@REGISTERED_FROMsmalldatetime=...

DwainC wrote this article [/url]a couple of years ago which might offer you some ideas.

Strongly seasonal. Two months ago I was getting two or three phone calls each day, now it's more...

Sean Lange (6/11/2014)

---

SQLSteve (6/11/2014)

---

Sean, the query only posted 1 entry back to me from the duplicate. Chris' posted both enrties, so I can now see all of the entries rather...

SELECT fullname, attrib3, num_occurrences

FROM (

SELECT

fullname,

attrib3,

num_occurrences = COUNT(*) OVER(PARTITION BY fullname)

FROM userdb

WHERE companyname LIKE 'carpet%'

) d

WHERE num_occurrences > 1

pk2dpvp (6/11/2014)

---

well,

I fixed the problem

though I do not know why it got fixed...

what I did:

I changed ever A to SP and every SP to A (Turned around the script so...

sql-lover (6/11/2014)

---

ChrisM@Work (6/11/2014)

---

CREATE TABLE #temp (colint INT, colvarchar VARCHAR(10), colcomputed AS CAST(colvarchar AS INT))

INSERT INTO #temp (colint, colvarchar) SELECT 1, '10'

SELECT * FROM #temp

CREATE INDEX ix_colcomputed ON #temp (colcomputed)

SELECT colcomputed...

CREATE TABLE #temp (colint INT, colvarchar VARCHAR(10), colcomputed AS CAST(colvarchar AS INT))

INSERT INTO #temp (colint, colvarchar) SELECT 1, '10'

SELECT * FROM #temp

CREATE INDEX ix_colcomputed ON #temp (colcomputed)

SELECT colcomputed FROM #temp...

The two large data blocks which you posted earlier are slowing down access to this thread - can I ask you to shorten each block to say ten rows please?...

Not quite. Your results are exactly consistent with running this:

-- Query 1

SELECT

a.omschrijving, sp.omschrijving,

--a.verkoopprijs, sp.verkoopprijs,

a.gewijzigd, getDate()

FROM artikelen a

INNER JOIN...

pk2dpvp (6/11/2014)

---

so according to what you are saying, the problem in my script is the float point

I've tried to run my script without any float's (Just the description, which is...

Thanks.

Here's an article which explains what's happening and offers a workaround.

Select one of the tables in SSMS.

Right-click on column [verkoopprijs] to raise the property sheet. Record the values for [Length] and [Numeric Precision].

Do the same with the other table, post...