If the query otherwise works the way you want it to, just remove the unneeded column from the subquery:

...,

(SELECT C1.containerCode as containerCode --,SE.createdOn

FROM Containers C1

LEFT JOIN StoringsEvents SE ON C1.containerIncId...

I don't like the extra overhead of generating hundreds of rows every time when you only need a dozen or two.

A "standard" sequential-numbers tally table can easily handle those types...

Grant Fritchey (1/6/2015)One other point, I'm not sure what industry you're working in, but many, especially healthcare, now have criminal penalties if you expose personal data to people without permission...

First thought for first task:

Compare one customer's pattern to the concatenated pattern of another customer(s). This should alleviate the off-by-n issue. Naturally you could also reduce the repeating...

Eirikur Eiriksson (1/6/2015)

ScottPletcher (1/6/2015)

Eirikur Eiriksson (1/6/2015)

ScottPletcher (1/6/2015)

Jeff Moden (1/4/2015)

Trust me Dhani, we know what it does and folks in-the-know can't just ignore...

Great, glad it helped. It was a fun exercise :). And thanks so much for posting the final solution so I could see it! Yeah, I thought...

DECLARE @CopyParams TABLE (

CopyFromVIEGuid uniqueidentifier,

CopyToVIEGuid uniqueidentifier

)

UPDATE [dbo].XdsInboundSecurity

SET ClientCertificateThumbprint = (

Select...

Keep in mind that a proc exists in that view as long as it is still in the procedure cache. As long as the proc is in the cache,...

Eirikur Eiriksson (1/6/2015)

ScottPletcher (1/6/2015)

Jeff Moden (1/4/2015)

Trust me Dhani, we know what it does and folks in-the-know can't just ignore it. It's...

I agree, NEVER use the GUIs for backups and restores. For one thing, you have no record of what was done, whereas a script can be enhanced over time.

I...

For a table that size, and esp. one that apparently static, I'd make sure the statistics were based on the entire table rather than just a small sampling.

You can see...

Jeff Moden (1/4/2015)

Trust me Dhani, we know what it does and folks in-the-know can't just ignore it. It's normally a bad...

------------------------------------------------------------------------------------------------------------------------

--declare temp tables and variables

IF OBJECT_ID('tempdb.dbo.#sql') IS NOT NULL

DROP TABLE #sql

CREATE TABLE #sql (

ident int IDENTITY(1, 1) NOT NULL,

...

I'd probably generate dynamic SQL in this case, as it's much clearer to me. Sample below. I'm sure it will need tweaked but it should give you enough...

GilaMonster (12/31/2014)

It's also far less clear than a DATEADD for...