Just to put another spin on the subject that was raised about how people should not be providing free advice on a forum during work hours. My boss expects...

Wow….I have to chime in as well as a “lady programmer”. I was a Business Administration major in college with emphasis in Marketing. I was so bored at...

Thank you VERY much! I had tried adding a fourth union and had definitely been doing it wrong. And I year you on the CDATA portion. Here...

I have avoided SN sites like Facebook and MySpace like the plague. I've received several invites to Facebook and simply can't bring myself to join. I'm a private...

In response to sudhanvag, who stated:

But i want a result like this

---------------------------------

codName (no column name)

abc 1 281 444 5555 , 55 11...

I have been getting my daily SQLServerCentral.com emails and ashamedly skipping by them lately. I just had other stuff going on and hadn't lurked here in a while. ...

SO well deserved!! Jeff is simply amazing. I am often looking for Jeff's replies in many of the posts I read. I often copy and paste his...

I have a C# web application and ran into the same predicament. Should I encrypt? I know nothing about encrypting/decrypting. And through some Google search, found some...

If you can believe it, I once had a boss who (although I was his top developer) told me I was "too thorough". This was from a CIO who...

A naming convention I was taught a long time ago (and still use today) is:

GetCustomer - select

InsCustomer - insert

UpdCustomer - update

DelCustomer - delete

I'm not sure if I'm understanding you problem correctly, but just iterate throught the items in the ListBox, building a string as you go and then pass that to a...

Let me give this a shot. If I understand your post correctly, you are saying you want to use a stored procedure. You're practically there with what you...

I enjoy writing and my managers have always complimented my ability to write to a technical and non-technical audience. However, like Lian indicated (comments on page 1), I don't...

I wanted to provide an update to this in the event someone researches PIVOT. I tried having the front end perform the pivot, however each employee's data contained 20...

That is a good suggestion. This data is being consumed by a .NET web application. I will look into that.

Thanks -

Lisa