Viewing 15 posts - 166 through 180 (of 621 total)
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
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 6, 2011 at 9:02 am
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
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 5, 2011 at 2:19 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 5, 2011 at 2:12 pm
toddasd (5/9/2011)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 9, 2011 at 2:15 pm
Thanks Jeff, it has been quite fun. And I'm confident I'll think of a use for it later.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 9, 2011 at 2:02 pm
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,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 9, 2011 at 7:18 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 6, 2011 at 10:11 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 22, 2011 at 12:45 pm
That looks a bit like homework to me. What is your table structure? Sample data? What have you tried?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
April 22, 2011 at 12:32 pm
Thank you so much, that worked like a charm!
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 11, 2011 at 6:17 am
DOH! I always forget about CAST. Thank you John, that did the trick.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 5, 2011 at 2:02 pm
vbradham (12/9/2010)
Leave the error checking aside, I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 10, 2010 at 1:28 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 10, 2010 at 11:34 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2010 at 8:44 pm
norbertackerman (10/12/2010)
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,
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2010 at 8:24 pm
Viewing 15 posts - 166 through 180 (of 621 total)