Viewing 15 posts - 3,271 through 3,285 (of 10,144 total)
Select one of the tables in Object Explorer in SSMS.
Right-click on it, from the popup menu select "Script Table as", then "Create to" then "New Query Editor Window".
Do the...
June 11, 2014 at 3:20 am
pk2dpvp (6/11/2014)
11,5311,535,75,7
1,671,67
100,57132
13,111,97
09,81
I was expecting to see two columns of float numbers. You may get some clues from this:
CREATE TABLE #Temp (Float1 FLOAT(1), Float24 FLOAT(24), Float53 FLOAT(53))
INSERT INTO #Temp (Float1, Float24,...
June 11, 2014 at 3:04 am
pk2dpvp (6/11/2014)
there are loads of differences, about 1000 of the 2054 have differences in the price
Can you show a few? Please?
June 11, 2014 at 2:46 am
pk2dpvp (6/11/2014)
what should I check?;p
The two float values. Check if they are the same.
Run this query:
-- Secondly, test what the update is going to do before you run it,...
June 11, 2014 at 2:43 am
pk2dpvp (6/11/2014)
It returns the 2054 rows that it is going to change......which never happens for some reason
I really just don't get it anymore;p
brains can't handle.
Check the two float values in...
June 11, 2014 at 2:31 am
pk2dpvp (6/11/2014)
they are the same in both tables
Have you run the query I posted, labelled "test what the update is going to do before you run it"?
What does it return?
June 11, 2014 at 2:22 am
pk2dpvp (6/11/2014)
omschrijving: nvarcharverkoopprijs: float
they mean:
omschrijving - Description
Verkoopprijs: - Price.
Check that the datatypes are the same in both tables.
June 11, 2014 at 2:16 am
What are the datatypes of those two columns in both tables?
June 11, 2014 at 2:10 am
pk2dpvp (6/11/2014)
what am I doing...
June 11, 2014 at 1:54 am
wall str33t (6/9/2014)
Take one of the slowest queries and add top 1000 to it ...
Using TOP to choke the result set can dramatically change the execution plan whether or not...
June 10, 2014 at 4:15 am
Jeff Moden (6/6/2014)
ChrisM@Work (6/6/2014)
julian.fletcher (6/6/2014)
June 9, 2014 at 9:41 am
BWFC (6/9/2014)
ChrisM@Work (6/9/2014)
BWFC (6/9/2014)
ChrisM@Work (6/9/2014)
BWFC (6/9/2014)
ChrisM@Work (6/9/2014)
June 9, 2014 at 9:27 am
BWFC (6/9/2014)
ChrisM@Work (6/9/2014)
BWFC (6/9/2014)
ChrisM@Work (6/9/2014)
June 9, 2014 at 8:50 am
BWFC (6/9/2014)
ChrisM@Work (6/9/2014)
June 9, 2014 at 7:49 am
Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If you can answer "Yes",...
June 9, 2014 at 7:00 am
Viewing 15 posts - 3,271 through 3,285 (of 10,144 total)