The posted answers should improve for awhile. A few days ago this happened:

My brand new baby girl! My first baby. I took a month off of work and the...

I have to go through my notes, I can't remember at the moment and I don't have access to a PC. It had something...

Great article Chad! I learned something new today.

Answer removed, bad advice.

I think I got to the bottom of this... Give me a few minutes...

Ok I'm back. Again, DDL would really be helpful. Note the link in...

lmarkum (6/19/2015)

---

Here is the SQL and the attached sql plan

DECLARE @SendId INT

SET @SendId = 1

UPDATEEmailTrackingSummary

SETEmailName = tets.EmailName,

SentDate = tets.SentDate,

SendDate = tets.SendDate,

NumberSent = tets.NumberSent,

NumberDelivered = tets.NumberDelivered,

Duplicates = tets.Duplicates,

UniqueClicks = tets.UniqueClicks,

UniqueOpens =...

ChrisM@Work (6/18/2015)

---

You will find this much easier to work with if you can reduce the clutter, and one way of doing this is to encapsulate sections of the code into...

I'm on my phone now, otherwise I'd provide an example....

You could take the last backup and restore it somewhere else (a non-production machine preferably). Then you could create a...

Another way...

DECLARE @IDList VARCHAR(MAX);

WITH yourtable AS

(

SELECT memberID FROM (VALUES ('001'),('002'),('003')) t(memberID)

)

SELECT @IDList = STUFF ((SELECT ','+memberID FROM yourtable FOR XML PATH('')),1,1,'');

PRINT @IDList;

GO

Andrew P (6/17/2015)

---

Thanks Thomas - I appreciate the offer, but not at the moment. I've had a read through the TimeXtender 2014 user guide and have somewhat of an idea...

I agree with Alvin - don't use ambiguous column names like ID and Date. Instead go with Contact_ID and something like Create_Date. Economic Class can be it's own table with...

For even better performance I strongly suggest that you consider turning it into an Inline Table Valued Function and use SCHEMABINDING.

There are many issues with scalar udfs including the...

Robin35 (6/17/2015)

---

thanks for the reply.

yeah refreshing the view will solve the issue but when i query the view after adding a column to table, i get the following result.

c1c2total

533RobinNULL

655SteveNULL

Column Total...

<Duplicate Post Removed>

SSC Bug? :hehe:

Great Post Andy.

I have been everything from a DBA at a bank and in the Healthcare industry where there are the tightest controls imaginable and I have worked in...

This is a classic "it's not a bug, it's a feature" things...

This is one of those funky MS SQL Server View behaviors. Because the view is not Schema Bound...