Viewing 15 posts - 136 through 150 (of 621 total)
dwain.c (5/29/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 29, 2012 at 8:04 pm
CELKO (5/29/2012)
This is not a table; it has no key asnd not way rto ever have a key.
Well, Joe, thank you once again for pointing out the obvious. However,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 29, 2012 at 7:55 pm
Are you just trying to lop off the zeros to the right of the decimal place? If so, you could just convert to DECIMAL with 0 decimal places. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 11, 2012 at 1:28 pm
What kind of database will it be? If you are simply looking for any database, perhaps Adventure Works might serve you well.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 11, 2012 at 5:34 am
Thank you all so much for the feedback. I did not realize there were so many things to consider.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 4, 2012 at 1:33 pm
I think I finally have it working
I'm just curious, how many rows are there, and how long does it take to run?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 7, 2012 at 1:34 pm
Amy, as long as you are comfortable with it. At my last job I was the only one person who did anything at all to our SQL Server. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 5, 2012 at 4:50 pm
would anyone recommend ever creating a delete_dups procedure?
If it were me, probably not. Let's say you have a table with col1, col2, and col3. You create a procedure...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
March 5, 2012 at 1:38 pm
Well, we never could get Viewfinity to make SQL Server think I had admin rights. The only way to solve it was to have the IT guy temporarily restore...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 21, 2012 at 7:14 am
I've never messed with indexed view or schema binding, but the error message seems to indicate it does not like the aggregate functions. You could try wrapping the whole...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 18, 2012 at 7:16 am
Thank you Alex for the reply. I believe you are dead on. After I posted, I went back and re-read the email they sent (in its entirety this...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 17, 2012 at 5:08 pm
...but the || does work....
Are you sure you're using SQL Server?
Edit: DOH! Really should learn to read the rest of the posts before I post annoying redundancy.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 26, 2012 at 2:21 pm
Peter, I looked at the link you provided for the lookup table, and decided to create a permanent table to use in the function. I also tweaked it to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2012 at 1:32 pm
Not even the least bit disappointed, indeed just the opposite is true, as not being able to see the tables is a minor issue. I built a full table...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2012 at 10:54 am
Peter, thank you so much for taking your good time to work on my problem, I am truly humbled by your knowledge.
Peter Brinkhaus (1/13/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2012 at 8:41 am
Viewing 15 posts - 136 through 150 (of 621 total)