When starting working on a modification to a stored procedure, I start by comparing what's in production to the latest in the production branch of the source code repository. They...

So we're talking v2016 now; it's hard for me to believe that our DW is three releases behind already. SQL Server v2008 may end up being the most extant version...

TomThomson (6/1/2015)

---

Well,...

I can't entirely digest all what you've said above. But taking a step back, here is what I'd propose:

Have the raw daily transactions from the CRM imported into an Excel...

SQL doesn't provide for conditionally returning columns. However, you can have a computed column that contains values from multiple columns appended together. For example, you can return your events as...

fliteskates (5/29/2015)

---

Hey all,

I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with little experience.

I just downloaded and...

GoofyGuy (6/1/2015)

---

If that's a requirement, but unless you're an ISV providing a solution that is installed at the client's site, then there is no compelling business reason to design an...

You can query the job history from msdb.dbo.sysjobhistory. Here is a link to an article that describes in more detail.

http://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/

What is "Line 29", and what is the error message you're getting ?

GoofyGuy (6/1/2015)

---

I'm curious if/how the 'repeatability' design philosophy includes being able to swop...

I'm not sure what you mean by "removing" addresses from a "list". However, the following example assumes your need is to delete rows from a table where IPAddress is contained...

That's a big part of why I love being a database developer; I rarely get mired in the muck of "why does the code work on X machine but not...

You mentioned above that your update is running within 45 seconds. It's unclear why this would be unacceptable. If you are updating this table multiple times per day, then you...

When it comes to politics, I think they first draw the pie chart to make a point, and then they twist the data to fit the chart.

Before attempting to revover data from a damaged .mdb file, consider that you may still have the option of recoving a previous version of the file intact. From Windows Explorer,...