Viewing 15 posts - 466 through 480 (of 621 total)
J (2/15/2008)
Either you set the query mode to gridm and...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 15, 2008 at 7:56 pm
Matt Miller (2/15/2008)
Or - you could run reporting services and just send them a link to the report (which wouldn't need to change)...
Well, I do not want to have to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 15, 2008 at 10:04 am
I never thought of that. I guess I would have to name the file something else every time right? That would mean I would have to save them....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 15, 2008 at 5:59 am
Jeff Moden (2/13/2008)
... Greg, ever heard of "sp_MakeWebTask"? Read up on it in Books Online and we'll talk some more 😉
Well, as a matter of fact I have indeed...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 14, 2008 at 1:08 pm
Jeff Moden (2/12/2008)
Would you post one of your emails that has the correct format, please? Be sure to use a code window (Click on "IFCode" in the menu of...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 13, 2008 at 8:21 am
SELECT
b.*
FROM table_b b LEFT OUTER JOIN
table_a a
ON b.key_col = a.key_col
WHERE a.key_col IS NULL
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 13, 2008 at 6:27 am
Thanks Lowell. I have not tried it yet, but I should have time tomorrow. I searched past articles, and found the PAD function, that may or may not...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 12, 2008 at 1:51 pm
Ok, this is yet another episode of 'How not to do things, by a non-programmer'. Anyhow, I think the problem was not clearly defined in the OP, so I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 12, 2008 at 9:47 am
Jeff Moden (2/11/2008)
What are the datatypes and, if appropriate, sizes for the 5 different columns you're pulling from, Greg?
Yep, I know did the cardinal sin by not including test data...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
February 11, 2008 at 11:03 pm
Jeff Moden
Heh... it's always an option if the nail in the bat is large enough and you can find the designers that put the screws to your data 😉
So tell...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 15, 2008 at 5:51 am
You could also try something like...
SELECT YourDateCol
WHERE DATENAME(m,YourDateCol) = 'February', or what ever month you want.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 14, 2008 at 1:57 pm
Assuming table A is the one with the padding, and that you do not want to see the padding in your view, you could try this:
SELECT
b.ID
FROM tablea a,tableb b
WHERE...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 14, 2008 at 1:44 pm
Thanks for the info. I guess the extra storage space is not worth having visibility of the seconds for most of my applications.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 8, 2008 at 12:37 pm
John Mitchell (1/8/2008)
Could it be to do with your regional settings? What happens if you do SELECT CAST (GETDATE() AS datetime)?John
If I do that I get seconds and miliseconds....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 8, 2008 at 9:47 am
Duly noted. I will stick with the function as long as it works. Thaks Jeff.
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2008 at 2:18 pm
Viewing 15 posts - 466 through 480 (of 621 total)