Viewing 15 posts - 17,116 through 17,130 (of 26,489 total)
Grant Fritchey (2/1/2010)
Lynn Pettis (2/1/2010)
Grant Fritchey (2/1/2010)
SpamDid you report it?
Yepper.
Okay, then I won't. 😉
February 1, 2010 at 7:30 am
I'm still confused as to what is being asked. How about more detail instead of a single line vaguely worded question. What are you trying to do?
February 1, 2010 at 7:29 am
milzs (2/1/2010)
February 1, 2010 at 7:24 am
Grant Fritchey (2/1/2010)
Spam
Did you report it?
February 1, 2010 at 7:21 am
Dave Ballantyne (2/1/2010)
How many times do we have to go through this one ???
As many times as people used to working with Excel start working with SQL. 😉
February 1, 2010 at 7:18 am
Your where clause effectively turns your outer join into an inner join. Try the following query:
with Myft as (
select
ft.fdata,
ft.no,
...
February 1, 2010 at 7:14 am
Actually, since you are running SQL Server 2005, if yoour account has SysAdmin rights you can still can access to your system. You will need to restart SQL Server...
January 31, 2010 at 11:31 pm
You can find the syntax for the BACKUP DATABASE command in Books Online.
January 31, 2010 at 3:48 pm
First, I just took an example that someone else started.
Second, very well said, Matt, and I agree.
January 31, 2010 at 2:27 pm
Paul White (1/31/2010)
An alternative approach might be:
DECLARE @DateOnly DATE = GETDATE(),
...
January 31, 2010 at 1:45 pm
David Portas (1/31/2010)
Matt Miller (#4) (1/31/2010)When I say X is NULL, it means I know nothing about it: I don't even know if it's something that can HAVE a value.
Does...
January 31, 2010 at 12:53 pm
Still don't see SQL, or its variants (T-SQL, PL-SQL, etc), going away any time soon. Just like COBOL, I see it having a long life, or at least until...
January 31, 2010 at 11:47 am
bitbucket-25253 (1/30/2010)
is said that you are never more than 6 persons removed from every other person on this earth
Always thought that was a fallacy - what...
January 30, 2010 at 4:21 pm
Florian Reischl (1/30/2010)
Alvin Ramard (1/30/2010)
Fortunately, most of the noise comes from just a couple of people.
Yup, this makes it easy to skip some tweets.
(BTW: One non-technical thing I really love...
January 30, 2010 at 2:15 pm
Jeff Moden (1/29/2010)
Lynn Pettis (1/29/2010)
January 29, 2010 at 10:29 pm
Viewing 15 posts - 17,116 through 17,130 (of 26,489 total)