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,...

The following will easily give you what you want, without resorting to a loop. It basically just applies row_number() across a resultset to get a sequential set of numbers, multiplying...

Not just for data scientists, basic statistical analysis can also be incorporated into a database at the operational level. For a dashboard application that monitors ETL processes, I leverage the...

Confirm that both tests, the straight select and then the insert / select, are performed in the same SSMS query window, using the same session and default session settings. Settings...