Viewing 15 posts - 3,136 through 3,150 (of 7,631 total)
Lynn Pettis (3/30/2009)
RBarryYoung (3/30/2009)
Hey, Lynn got to use HAVING! Wohoo! 😛I think that we ought to award a prize anytime someone gets to use HAVING legitimately. 😀
You know,...
[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]
March 31, 2009 at 7:39 am
Why don't you tell us what features you already have. And also tell us what your architecture and design is. Then I am sure that we can answer...
[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]
March 31, 2009 at 7:27 am
Nice example, JohnG. Mind if I quote it in my Blog sometime?
[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]
March 31, 2009 at 7:22 am
swmsan (3/31/2009)
Now in my report i need to find total blood tests done by the doctors
Select Doctor_ID, Patient_ID, Count(*) as [Count]
From Table1 as t1
Inner Join Table2 as t2...
[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]
March 31, 2009 at 7:15 am
Like this:
Select Doctor_ID, Patient_ID, Count(*) as [Count]
From Table1 as t1
Inner Join Table2 as t2 ON t1.Doctor_ID = t2.Doctor_ID
And t1.Patient_ID = t2.Patient_ID
Where t2.Diabetes = 'No'
...
[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]
March 30, 2009 at 9:04 pm
Tony Davis (3/30/2009)
...the bleeding from one of Tony's editing sessions only lasts for three or four days, so don't worry.
Don't worry, Jeff. I'll offer you as much help as...
[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]
March 30, 2009 at 6:54 pm
Hey, Lynn got to use HAVING! Wohoo! 😛
I think that we ought to award a prize anytime someone gets to use HAVING legitimately. 😀
[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]
March 30, 2009 at 6:44 pm
I think that you just need to install Jet. Check Microsoft, there should be a free download & install.
[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]
March 30, 2009 at 6:38 pm
I can't see the procedure from here. Could you please show it to us?
[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]
March 30, 2009 at 1:11 pm
justanewone (3/30/2009)
I have been asked to generate some code which will produce a list of employee activity by day and create a rota from it... Please bear in mind...
[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]
March 30, 2009 at 10:45 am
OK, this is straight from Remus Rusanu himself:
You must enable broker before the mirroring session is enabled. You should
first check if the broker is enabled in the first place
(sys.databases.is_broker_enabled). If...
[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]
March 30, 2009 at 10:21 am
Lutz: XML datatype is SQL Server 2005. You'll need to use OPENXML instead.
[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]
March 30, 2009 at 10:09 am
dlongnecker (3/30/2009)
edit: in light of this, I'd definately go with the XML string concat method I originally proposed
Agreed. I am in the process of switching over to it myself...
[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]
March 30, 2009 at 9:01 am
longobardia (3/30/2009)
ie:
if not exists ( select * from xxxx where stageid = @stageID and...
[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]
March 30, 2009 at 8:58 am
Here's what I have so far that works:
[ code ] for SQL,
[ code="csharp" ] for C#
[ code="vb" ] for VB.net
[ code="xml" ] for XML
bit i still have to use "&...
[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]
March 30, 2009 at 8:53 am
Viewing 15 posts - 3,136 through 3,150 (of 7,631 total)