tfifield (4/21/2011)

---

Great article Craig! I've been put off by job postings that have the SQL God requirement in the past. I'll never look at job postings in the...

jcrawf02 (4/21/2011)

---

Personally, I learn a lot by being a wallflower in these kinds of conversations, so if it's not in the Thread but you are having it elsewhere, can we...

GilaMonster (4/21/2011)

---

jcrawf02 (4/21/2011)

---

Personally, I learn a lot by being a wallflower in these kinds of conversations, so if it's not in the Thread but you are having it elsewhere, can...

toddasd (4/21/2011)

---

I've been reading about Service Broker with these questions lately and I still have a lot of questions on what exactly it is (even after reading BOL). Anyone here...

Very nice article Wayne, thank you. Perfect spackle.

Check your PM, I don't want to start a tech conversation in the thread. However yes, I have reasonable acquaintance with statistics. 🙂

You'll have to unpivot the data, sort it desc, then select top 1 for each item.

If you can provide a sample DDL/Data set like you'll find described in the first...

You know, this is why I'm never quite sure if I should write tech articles. No, I'm not looking for help per se, just bringing a personally amusing moment.

So...

Aaron G (4/20/2011)

---

I am running SS2K8 on a server with 4GB of RAM. I have an SSIS package that pulls in approximately 5,000,000 rows and does some very complex...

2008 can do this natively with CONVERT options.

The trick is to convert to VARBINARY in the middle with the style: 1

Here's some sample code:

DECLARE @hexStr VARCHAR(20),

@hexBin varBINARY(20)

SET @hexStr = '0x4158'

SET...

LOOKUP_BI-756009 (4/20/2011)

---

Craig & Michael, yup inserting a NULL in datetime clmn returns a NULL and empty string returned 1900-01-01 00:00:00.000.

So what I need is to replace all 1900-01-01 00:00:00.000 with...

Yeah, that's a fixed width file. Did you setup column widths in the advanced piece?

LOOKUP_BI-756009 (4/20/2011)

---

I have a column of type datetime.

Many of its value are NULL's but in the column it appears as 1900-01-01 00:00:00.

I know that 1900-01-01 00:00:00 is the default for...

I'm not quite sure I get the question. Can you rephrase...

DECLARE @today DATETIME

SET @today = GETDATE()

EXEC proc @MyDate = @today

Can't send in a function as a value to a parameter.