DECLARE

@StartDate datetime = '2012-02-03 23:00:00',

@EndDate datetime = '2012-02-07 00:00:00';

DECLARE @Holidays AS TABLE

(

HolidayDate date...

Yes I saw that after I posted here. Please don't post twice in different places next time, thanks.

For details here, for anyone interested:

http://sqlblog.com/blogs/paul_white/archive/2011/06/22/undocumented-query-plans-equality-comparisons.aspx

Jason-299789 (2/7/2012)

---

A quick Question in SQL 2008 doesnt the OPTION(RECOMPILE) on a query force that query to recompile its plan based on the values thus eliminating the need for Parameter...

Doesn't account for NULLs.

SELECT

t2.*

FROM dbo.temp1empdtls AS t1

JOIN dbo.temp2empdtls AS t2 ON

t2.empno = t1.empno

WHERE

...

This meets the stated requirement:

SELECT

t2.*

FROM dbo.temp1empdtls AS t1

JOIN dbo.temp2empdtls AS t2 ON

t2.empno = t1.empno

WHERE

NOT EXISTS

...

Here: DATE (Transact-SQL)

It's been around for four years or so now 🙂

Hugo Kornelis (2/6/2012)

---

That's definitely cleaner, and easier to understand code. But how does the performance of a CLR aggregate compare to performance...

It depends on the rules you want to apply:

DECLARE @T1 TABLE (col1 varchar(30) COLLATE Latin1_General_CI_AS);

DECLARE @T2 TABLE (col1 varchar(30) COLLATE Latin1_General_CS_AS);

INSERT...

CELKO (2/7/2012)

---

Good SQL programmers do not use temp table;

we use COALESCE() not ISNULL

Also, we would tend to use a VIEW and not an UPDATE.

And we never, never use the...

Another option would be to have SYSTEM_USER as the default for the column.

Sample data:

DECLARE @test-2 AS TABLE

(

ID integer PRIMARY KEY,

InternalCode ...

Example simple join:

DECLARE @Table1 AS TABLE (col1 integer NULL, col2 integer NULL);

DECLARE @Table2 AS TABLE (col1 integer NULL, col2 integer NULL);

INSERT @Table1 VALUES (1, 10), (2, 20), (3, 30), (4,...

Given this sample data:

DECLARE @data AS TABLE

(

CityName varchar(50) NOT NULL,

RegionName ...

Guessed from memory at 31 (-15 to +15) and got it wrong. Ah well.