lmu92 (2/23/2010)

---

Peter Brinkhaus (2/23/2010)

---

Excellent job, Peter!!

If I...

If the amount of numbers is fixed here's an example of 8 numbers. I doesn't look efficient but given the number of parameters it will do. I have changed the...

Makes sense too. But looking at the query plan of the...

You get zero because all the operands in...

GSquared (2/23/2010)

---

Nest NullIf and IsNull.

If your datetime column is called MyDate and it's in table MyTable:

select IsNull(MyDate, 0)

from dbo.MyTable;

That will replace the nulls with 0s (datetime 0 = 1 Jan...

DECLARE @table TABLE (d date)

INSERT INTO @table

VALUES (GETDATE()), (GETDATE() + 10), (GETDATE() - 50000), (NULL)

SELECT

DATEADD(dd, 0, NULLIF(MIN(COALESCE(DATEDIFF(dd, 0, d), -2147483648)), -2147483648))

FROM

@table

REMOVED: false statement

BTW, the same holds true for the LIKE method

declare @test-2 table(value varchar(50))

insert into @test-2(value) values('a123²³')

select * from @test-2 where value like '%[^''0-9a-Z .,-]%'

select...

Well, not exactly. The second version of StripHighAscii (the one with the loop) can give you very odd results depending on the collation being...

The reason that it's...

Strange.

select difference('DML', 'DDL')

gives...

select

t1.id, t2.requirement

into

#myTable2

from

#myTable1 t1

cross apply

(

select t1.req1 requirement

union all

select t1.req2

union all

select...

I know, but I was wondering if there is any error...

bitbucket-25253 (2/3/2010)

---

Peter Brinkhaus

I tried a new approach, where I started a nested transaction to solve the problem but since SQL Server does not support rollback of inner transactions without...

I was just looking up the documentation of SAVE TRANSACTION in BOL and now I'm really confused. It gives an example of just what you are trying to do:

USE AdventureWorks;

GO

IF...