The bigger problem is that your field is a composite field. A better solution would be to break it down into the identifying parts:

Prefix varchar(5), PrefixID int

To help you with...

Brandie Tarvin (10/28/2010)

---

Last post until I get more info from you on how you're dynamically generating your column names (code sample?) from the database.

Looks like there was an article on...

Brandie Tarvin (10/28/2010)

---

Nope. That's a different, separate thing. You can dynamically create the file, and...

Can you post the MSDN link so that we know what you're talking about? Seriously, pretend that you know anything about your problem, read the question you posted, and try...

Agreed... I left a mess behind! :w00t:

Jeff Moden (10/28/2010)

---

Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post...

ankit.uneedme (10/27/2010)

---

I am Building a "CAB Booking Application" in that i have done few things:

1> Firstly i have created the Cab tour on particular Date.

2> Secondly i have plotted its...

christine.lawrie (10/27/2010)

---

I've got the Base64 -> varbinary sorted... you wouldn't know about the -> Hex conversion would you?

I've been butting my head against this for about a week now, there's...

smile_netz (10/27/2010)

---

Hi,

How do I know which account has been used for the reporting server?

Does the Windows Service Identity screen tells me this?

And what does it mean when it just says...

Jeff Moden (10/27/2010)

---

I may be misreading the requirements but can't you just determine when one of the indexes on the table was last used which would also indicate when the...

Passive node first. Reboot passive...

Steve Jones - SSC Editor (10/27/2010)

---

OK, sign up for articles. Please just pick one, then another when you finish.

If you have ideas, feel free to post them, but try to...

http://en.wikipedia.org/wiki/Spackling_paste

You mean like http://www.sqlservercentral.com/scripts/66808/?

Steve Jones - SSC Editor (10/27/2010)

---

BTW, SSC usually has a blogger at the blogger table during the PASS Summit. Usually it's me, someone that can take notes during keynotes and...