Thank you so much Jeff. I was trying to figure out that last line. However, I found that when copied and pasted into Excel, then formatted as money,...

Greg

On second glance, I think I got it wrong the first time. I think this is what you want.

DECLARE @min-2 INT, @max-2 INT, @width...

Greg

Here is a solution based on your criteria, which is to simply use the minimum and maximum values of existing data as the endpoints of...

toddasd (5/9/2011)

---

Your code is working perfectly fine for me, Greg. I created a folder in c:\temp called "todd's files" and as long as there is a file in that folder,...

Thanks Jeff, it has been quite fun. And I'm confident I'll think of a use for it later.

Small update here. I noticed that although the file 'administrator''s documents' is named as such when navigating to it, when xp_DirTree lists out the folders in c:\documents and settings\administrator,...

AVB, if you search this site for concatanation functions, you will find countless examples of basically the same thing as shown below. Please note, I have not tried the...

Jeff/Dave - I've actually used the BOL example as a template for several procedures since this post began, and I am very interested in learning of the solution to Dave's...

That looks a bit like homework to me. What is your table structure? Sample data? What have you tried?

Thank you so much, that worked like a charm!

DOH! I always forget about CAST. Thank you John, that did the trick.

vbradham (12/9/2010)

---

It amazes me that questions get asked, and yet no-one answers the questions. I would find so useful the example asked for here.

Leave the error checking aside, I...

Very interesting. Now I am thinking of all the stuff I am going to have to fix, now that I know what not to do. Thanks for the...

happyfax, is this going to be a reporting table? If so, then there are sometimes benefits to de-normalizing a table. However, if it is because someone told you...

norbertackerman (10/12/2010)

---

Wayne,

It looks like this is what I need. However, I keep getting an error because the the phone field is not int.

SELECT contact_KEY,

...