Viewing 15 posts - 976 through 990 (of 1,034 total)
Mike C (5/29/2007)
God-awful loops and cursors. It's all I seem to see these days, and getting people to think about changing them? Even when you can demonstrate 100%, 200%, 500%,...
May 1, 2008 at 9:27 am
Adam Machanic (5/28/2007)
May 1, 2008 at 9:19 am
We can always rewrite the question.
Does Windows XP by default come with Exchange Installed?
A. Yes
B. No
C. If you install Windows 2003 Server over it and then install Exchange
April 24, 2008 at 10:06 am
Steve Jones - Editor (4/21/2008)
You don't need admin costs, you need savings based on GB. It's the cost of your GB per year in media, people, time, etc.
That's actually exactly...
April 22, 2008 at 8:11 am
I have to agree with GSquared. This one made me do some research to see which of these would work.
While I'm not a big fan of the undocumented things,...
April 16, 2008 at 8:54 am
Steve Jones - Editor (4/9/2008)
apologies. The question has been changed (and answers) and everyone to this point in time is awarded points.
Except that I just answered it... and it's saying...
April 9, 2008 at 8:44 am
Adam Haines (4/8/2008)
April 8, 2008 at 12:25 pm
Actually... the joys of the Tally Table return... 🙂
http://www.sqlservercentral.com/Forums/Topic452198-338-1.aspx
SELECT TOP 11000 --equates to more than 30 years of dates
IDENTITY(INT,1,1) AS...
April 8, 2008 at 12:02 pm
Antonio... that's some interesting code, but
select * from dbo.fListToText( 'a,b,c', ',' )
the function flisttotext is missing from the code.
At first I thought it was using flisttoitems, but when I...
April 8, 2008 at 10:33 am
Shaun McGuile (4/8/2008)
Is the question poster a US citizen by any chance? 😀it would explain the 'english' bias of the question.
I'm a US Citizen... doesn't change the fact that I'm...
April 8, 2008 at 9:49 am
I hate to beat this dead horse, but the corrected question/answer went out today.
Explanation: Either of the first two answers will work. All the month names have at least the...
April 8, 2008 at 9:20 am
Jignesh Mehta (4/6/2008)
The other answer " datename(m,join_date) like '%a%' " is also not correct as it will not give the list of employees who joined in the month of FEB
Well...
April 7, 2008 at 9:00 am
I'm guessing as to what this is for, but I think it's basically making an attendance record for every user for every day. When a user is entered in...
April 4, 2008 at 9:45 am
Without the table structures, I can only give a sort of pseudo code but something like this.
Here's your trigger
CREATE TRIGGER NEW_USER ON USERS
FOR INSERT
AS
INSERT INTO ATTENDANCE([UID],[DATE])
SELECT
[UID],
GETDATE()
FROM INSERTED
The other...
April 4, 2008 at 9:08 am
Did you create indexes on the county and state fields? Need indexes to make it work.
I see some foreign keys, but not indexes in the structure above.
What do the...
April 3, 2008 at 4:26 pm
Viewing 15 posts - 976 through 990 (of 1,034 total)