If you're using DBMail (sp_send_DBMail), then all the e-mails are queued and logged in msdb, and you can query the relevant tables for status, etc., pretty easily. That's what...

I've played EVE enough to have two characters with Tech III ships and one with a Command ship (those aren't easy to get into). It's fun enough for a...

It can't pull those in Insert Select. It's one of those, "What was Microsoft thinking when they did that?" kind of things. Especially since you can get that...

As far as I'm concerned, Rift rocks.

It's got significant similarity to WoW, but...

It would look something like this:

-- Input Parameters faked for script

DECLARE @StartDate CHAR(10),

@EndDate CHAR(10),

@PatientPersonGUID VARCHAR(25),

@TCPersonGUID VARCHAR(25),

...

Spend time with my wife, spend time with my dogs, volunteer work, study, MMORPGs (currently playing RIFT), lots of movies (theatre and Netflix), cooking, eating.

That's the kind of thing SSIS does really well at.

It can query a folder for a list of files, or operate off of a query to a database table, and...

Here are the two options most commonly used:

Select <column list>

Into #MyTempTable

From MyTable;

create table #MyTempTable (colum list and definitions);

Insert Into #MyTempTable (column list)

Select (column list)

From MyTable;

In both cases, SQL Server has...

Select Into for temp tables used to be a bad practice in pre-SQL 2000 days because of schema locks in tempdb. The datum that it is a bad practice...

"text" datatype fields aren't actually stored in the clustered index. They are stored in an extended space. So, no, they really can't be part of an index, even...

Log space used != table space used.

Have you dug into a log parsing technique like DBCC LOG?

There's a lot going on in there. Everything needed to make sure that any...

Considering the query and return results he's trying for, I discounted the system proc. The input command would be complex to...

NullIf isn't the way to go for what you're doing. It will render your whole string null.

What you need is a Case statement. Check if the value of...

toddasd (6/8/2011)

---

GSquared (6/8/2011)

---

toddasd (6/7/2011)

---

Richard Warr (6/6/2011)

---

No, however that is the only way you can represent 1/3 as a...

coronaride (6/10/2011)

---

Thanks Gail - that helps.

G-Squared - I see where you're coming from and, if I wasn't normalizing addresses out into CASS certified columns or making first/last name entities (our...