Best wishes, thoughts and prayers with you and your family.

SQLBits.

Not a huge surprise. I've seen a few events coming up being cancelled or postponed.

Good they have postponed it though and not cancelled it.

Sadly hotel is standing by its...

Awww, SQLBits has been postponed until September.  I was really looking forward to it as well, but not surprised at all.

What is supposed to happen when you have an "IN" and no corresponding "OUT" ?  Emp ID 1 has a time in at "2017-08-02 13:00:00.000", then another time in at...

Sound died in Pinal Dave's talk ??

I'm there for the Friday and the Saturday, as normal when it's a sensible distance from home 🙂
Train journey in on the Saturday is going to be a killer.

Not an aswer to your question, but I'm just curious. . . why are you upgrading from 2008 to 2008R2?  Both are out of mainstream support and both end extended...

Something like this would show you the tables and rows where a column holds data that has at least 3 decimal places: -

DECLARE @sql...

A few options. . .

SELECT N AS [ORIGINAL],

LTRIM([N]) AS [LTRIM - DOES NOTHING],

REPLACE([N],...

Is the row_number even necessary? Don't you just want: -

SELECT [ItemNr],

MAX([FromDate]) AS FromData

FROM #Table1

WHERE FromDate...

Your "PRINT" is printing a variable called "@sql", whilst your statement is being appended to a variable called "@SQLQuery".

This seems like an odd requirement, why do you want to do...

You could try modifying this: -

SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#indexes') IS NOT NULL

BEGIN

DROP TABLE [#indexes];

END;

SELECT CASE WHEN [a].[type_desc] <> 'HEAP'

...

Brandie Tarvin (5/17/2016)

---

I have a package from SQL 2005 that was upgraded to SQL 2008 and then (recently) upgraded to SQL 2012 with Data Tools. When I open the package...

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

See: -

BEGIN TRY

DECLARE @sql NVARCHAR(MAX) = 'IF ' + CHAR(39) + '1' + CHAR(39)

+ ' COLLATE...