I would like to know why they even bother.

How many people out there are going to think "I could do with a new kitchen, where should I look? I know...

You just had to, didn't you?

Has nobody ever told you - CandyMan, CandyMan, Cand....

Phil Parkin (7/26/2016)

---

ChrisM@Work (7/26/2016)

---

BrainDonor (7/26/2016)

---

Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the...

Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the columns...

Does anybody know who the "Hotshot SQL Guru" is?

https://tmblr.co/Z14uHt29WaOS7

https://tmblr.co/Z14uHt29Ww0kS

https://tmblr.co/Z14uHt29ZP3zF

Somebody wasn't impressed.

For option 1:

DECLARE @Param1 varchar(10) = NULL;

UPDATE dbo.table

SET Column1 = ISNULL(@Param1,Column1);

So if @Param1 is null, it will use the existing value, so no change to the contents of that column.

For...

jasona.work (6/22/2016)

---

So, I'm curious, and I'm also tempted to spin this up in another topic as I suspect this is a contentious issue, what's everyone's feelings / opinions on the...

The first thing you should do is find out if you actually have a problem. It may be a sign of an issue elsewhere (hardware, comms etc) so it would...

have a look at the differences:

create procedure DailyReport_sp

@ModelNumber nvarchar(100),

@debug bit = 0

as

Begin

declare @TableName nvarchar(200), @SQLQuery nvarchar(200)

select @TableName = name from sys.objects where type = 'u' and name...

What error do you get that is...

Having set the value for @SQLQuery you then need to execute it:

exec sp_executesql @SQLQuery

llouw1 (6/15/2016)

---

thank you for the reply.

I want to use...

First of all, you don't need a CTE for this. The CTE would be useful if you were transforming the data prior to inserting it (at a basic level think...

Brandie Tarvin (6/14/2016)

---

I am seriously considering removing my LinkedIn profile all of a sudden. I did not join to be marketed to. According to this article:

Microsoft wants to use LinkedIn...

SQL Saturday Manchester, on July 23rd - who (apart from Hugo) will be going?