In the case of using the convert function on the column in the where clause, I would only consider it if there are relatively few rows being sought, as those...

Jeff Moden (9/15/2015)

---

Heh... remind me not to even attempt such questions in the future. I mentally added "and do it right" to the question which, of course, would have...

Steve Jones - SSC Editor (9/15/2015)

---

The idea in checksum is to reduce work. ALL hashing algorithms have the possibility of collisions. The faster/shorter/cheaper the algorithm is, the more likely there...

Commute

Trying this out :Whistling:, I'm wondering on what kind of logic Bobby is using.....

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH T(N) AS (SELECT CONVERT(TINYINT,N,0) FROM (VALUES (1),(2),(3),(4),(5))AS X(N))

,BASE_DATA AS

(

SELECT

...

Same column order rule applies there too;-)

😎

robin 66943 (9/15/2015)

---

This makes no sense to me. If the checksum is calculated differently, then when the checksums match that will most likely imply the data is different, not the...

Without any further information on the data, structure or even an execution plan, it obviously is a pure guesswork. Can you supply some more information such as DDL, sample data...

SQLPain (9/14/2015)

---

This happens to be a view query that needs to be run every night, needs to be converted to an excel file and email the attachment to couple of...

he he, how to tell when?

😎

john_rowles (9/14/2015)

---

The query returns the data that I need, but it looks rather sloppy. There are only a few hundred rows in the table at the moment, but expect...

SQL-DBA-01 (9/14/2015)

---

V strange

if you try any of the below, the results will be:

"Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type numeric."

SELECT round(.999,0);

SELECT round(.999,1);

SELECT...

Sorry, slightly hurried and inaccurate

😎

CONVERT(DATE,AppDetails.DateDetailDisposed,0) = CONVERT(DATE,DATEADD(DAY,-21,getdate()),0)

kdejan87 (9/14/2015)

---

No, this is my starting point:

CREATE TABLE #NONAMETABLE(

ID INT

,column1 INT

,column2 int

);

INSERT INTO #NONAMETABLE(ID,column1,column2) VALUES

(1,100.00,40)

;

drop table...

SQLPain (9/14/2015)

---

Thanks Again, but this one is giving me all the results from the last 25 days till today...

why do we need a between clause if I only need records...