March 9, 2009 at 9:58 am
Lynn Pettis (3/9/2009)
You have to wonder what people are being taught when you see code like this:ALTER TRIGGER [dbo].[tr_insert]
ON [dbo].[table1]
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @i INT
SELECT @i = COUNT(*) FROM inserted
SELECT @i
IF (@i > 1)
BEGIN
inser into table2
select * from table1 where date not in (select date from table2)
end
IF (@i = 1 )
begin
INSERT INTO [dbo].[table1]
([ReportDate]
,[EmployeeID]
,[CreatedDate]
,[CreatedBy])
select * from inserted
end
There are times you want to help, but you just don't know where to start.
And not content with posting that question 3 times, he PM'd me with it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2009 at 10:21 am
I hate it when someone PM's me with a problem/question/additional info that really should be posted on an open forum thread. I tend to inform those individuals that I don't answer questions that way. I don't work for SSC.
March 9, 2009 at 10:24 am
Bob Hovious (3/9/2009)
I once shot an elephant in my pajamas... how he got into my pajamas, I'll never know.
personally, my favorite Groucho quote is
"Outside of a dog, a book is man's best friend. Inside of a dog, it's too dark to read."
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 9, 2009 at 10:28 am
Lynn Pettis (3/9/2009)
I hate it when someone PM's me with a problem/question/additional info that really should be posted on an open forum thread.
I've been getting a fair few PM'd questions recently. They all get exactly the same answer - Please post this in the forums.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2009 at 10:31 am
And you know why? You are one of the top 3 people on SSC, so they figure if anyone knows the answer you are sure to be the one to ask.
March 9, 2009 at 11:27 am
Group By doesn't guarantee distinct results
The above quote comes from this thread in the newbies forum.
http://www.sqlservercentral.com/Forums/Topic670743-1291-1.aspx#bm671705
Gail, weren't you the person who observed that GROUP BY produces the same execution plan
as DISTINCT? Could a guru weigh in on how a Group By could possibly produce non-distinct results with respect to the columns contained in the Group By clause?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 11:38 am
Man o Man... Lynn, That must have been tough not to throw your key board out of the window...:hehe:
-Roy
March 9, 2009 at 11:39 am
Lynn Pettis (3/9/2009)
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.Okay, I just went sarcastic in this thread.
I think we're going to have to pull the "saint" logo from next to your image.... 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 11:42 am
DavidB (3/9/2009)
Lynn Pettis (3/9/2009)
Lynn Pettis (3/9/2009)
And Gail, its easy to see why you leave Mike to others to answer. I mean, really.Okay, I just went sarcastic in this thread.
I think we're going to have to pull the "saint" logo from next to your image.... 😉
Even a Saint stumbles once and a again. :blush:
There are some people that really have no business being near computers.
March 9, 2009 at 11:44 am
That guy needs a wake up call, if he can't learn on his own, he needs a new career!! NOW.
March 9, 2009 at 11:45 am
Laughing.... I have struggled down a path or two with that one before as well and found myself wondering if I was talking to two different people and then realizing that there was some really fundamental basic knowledge that was missing.
I will say though that had you asked me that question, i.e. "want me to install it for you?", I might have answered "yes". 😛
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 9, 2009 at 11:51 am
DavidB (3/9/2009)
Laughing.... I have struggled down a path or two with that one before as well and found myself wondering if I was talking to two different people and then realizing that there was some really fundamental basic knowledge that was missing.I will say though that had you asked me that question, i.e. "want me to install it for you?", I might have answered "yes". 😛
I doubt lack of training is the problem with said user, having had my own interactions with him. The fact of the matter is that in one case had he typed in Google the key words from his question, the first three or four links laid out what he needed to do. That's not a training issue. I don't know what the issue is, but it's not about missing some fundamental basic knowledge unless it it a lack of knowledge on how to use a search engine.
K. Brian Kelley
@kbriankelley
March 9, 2009 at 11:53 am
Well that yes to will you do it for me comes at a price... for a user like that it would a 1 day of work min at 250$ / hour... cause you know that you need to check EVERYTHING.
Viewing 15 posts - 2,401 through 2,415 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply