Viewing 15 posts - 2,506 through 2,520 (of 7,631 total)
I've used the data that you posted to mock-up a preliminary routine to solve this:
Alter Proc spInstructorAssignments_SS_Solution as
/*select * from InstructorSummary order by StudentId
select * from Assignment --Where StudentId=101
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 10:05 pm
Hey, thanks for the plug, Jeff!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 7:59 pm
Paul White (5/11/2009)
RBarryYoung (5/11/2009)
Hmm, I seem to recall that this issue in 2000 was if the ORDER BY contained an expression, instead of just a column.
At the risk of being...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 7:51 pm
Jeff Moden (5/11/2009)
ifila (5/7/2009)
NO.....they are resumes and people vary the location of content.Thanks
BWAA-HAAA! According to what I see in Barry's fine code, they were, in fact, all the same...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 7:29 pm
CREATE TABLE [dbo].[WCI_IP_ST_AGENT_SKILL_GROUP_HH](
[DateTime] [datetime] NULL,
[EmpNumber] [varchar](32) NOT NULL,
[Skill Group] [varchar](32) NOT NULL,
[SkillGroupSkillTargetID] [int] NOT NULL,
[SkillTargetID] [int] NOT NULL,
[wcEmployeeId] [int] NOT NULL,
[wcTaskId] [int] NOT NULL,
[PeripheralID] [int] NOT NULL,
[wcCallsAnswered] [int] NULL,
[wcTalkTime] [int]...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 2:53 pm
Grant Fritchey (5/11/2009)
Well to get the thread back "on topic" (as if), this one has managed to raise my blood pressure with his/her response.Suffice to say. I'm done.
Heh. Frankly,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 11:52 am
Jonathan Kehayias (5/11/2009)
Bob Hovious (5/11/2009)
I agree, Roy.
You are an unbeliever, Johnathan?
Glad to see you're thinking ahead, Alvin.
Hey Lynn, do you think we'll make 5K this...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 11:49 am
Glad we could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 11:35 am
It's OK, this problem interests me. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 11:28 am
I would use something like thid to mak a stored procedure to purge the backup files:
drop table #DirOut
go
DECLARE @path VARCHAR(256) -- path for backup files
DECLARE @EarliestDate VARCHAR(20) -- purge all...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 11:24 am
Glad I could help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 10:27 am
BU69 (5/11/2009)
"Updating statistics ensures that queries compile with up-to-date statistics. However, updating statistics causes queries to...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 10:18 am
While you can do this, there is some question as to whether you should do it. The issue is that ofr most transactional methods, charges are "All Or Nothing"....
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 10:14 am
Hmm, I seem to recall that this issue in 2000 was if the ORDER BY contained an expression, instead of just a column.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 8:44 am
By the way, if you want to reduce concurrency issues with this to a linked server, you should probably use a passthrough-type query using "EXEC linkedServer.master.dbo.sp_ExecuteSQL ...". That should...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 11, 2009 at 7:57 am
Viewing 15 posts - 2,506 through 2,520 (of 7,631 total)