Viewing 15 posts - 4,786 through 4,800 (of 7,631 total)
On the "SAVE" button in the "Save Results" dialog, there is a little drop-down arrow. Click on that and select "Save with Encoding".
[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]
November 25, 2008 at 4:21 pm
devammehta (11/25/2008)
Hope .. you got it now guys.
Umm, No. You still have no way to relate the Employee table to the Hierarchy table. Please read the article mentioned...
[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]
November 25, 2008 at 1:10 pm
Lynn Pettis (11/24/2008)
On a personal note, this forum thread allowed me to break 3000 forum posts!Edit: And that does NOT count this post!
Woo Hoo! Way to go, Lynn!
[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]
November 25, 2008 at 8:57 am
Either Vladan's or Peso's queries should do it for you (I think that Vladan's "-7" should probably be "+7", but I am not sure). If they are not sufficient,...
[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]
November 25, 2008 at 8:51 am
Because you seem to be confusing the syntax for Creating a Table with the syntax for creating a View.
A table is a data storage object that is defined as a...
[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]
November 24, 2008 at 10:45 pm
Personally, I prefer multiple volumes, as long as they are all Raid 10.
[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]
November 24, 2008 at 10:26 pm
Excel's PV function is mathematically described in this online help article: http://office.microsoft.com/en-us/excel/HP052092251033.aspx
[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]
November 24, 2008 at 9:50 pm
This statement:
I want to only the records from the join + 7 days in the result.
is not intelligible.
Please provide sample data and examples of the result set that you...
[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]
November 24, 2008 at 9:32 pm
Paul:
What we are looking for is a Functional definition, not an Operational description. "I want to move my access query to SQL Server" is an operational description....
[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]
November 24, 2008 at 9:01 pm
You have no rational way to relate Employee ahd Heirarchy.
Please read this article on how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/.
[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]
November 24, 2008 at 8:44 pm
Jonathan Kehayias (11/24/2008)
SQLBatman is a hero, I am just Jonathan Kehayias. I should really come up with a witty screenname or something for my online presence.
Hmmmm, how about "Captain...
[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]
November 24, 2008 at 3:12 pm
Jack Corbett (11/24/2008)
Lynn Pettis (11/24/2008)
Jack Corbett (11/24/2008)
rbarryyoung (11/24/2008)
[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]
November 24, 2008 at 2:02 pm
Jack Corbett (11/24/2008)
rbarryyoung (11/24/2008)
And for the record, I like to sit up front because at my age, I cannot see the code slides well enough otherwise... :smooooth:
I would have...
[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]
November 24, 2008 at 12:25 pm
Jack Corbett (11/24/2008)
rbarryyoung (11/24/2008)
OK, I was sitting in the front row next to Gail.Oh, so you are one of those teacher's pet types:P
Heh, well I wasn't sitting up front for...
[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]
November 24, 2008 at 12:01 pm
OK, I was sitting in the front row next to Gail.
[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]
November 24, 2008 at 8:18 am
Viewing 15 posts - 4,786 through 4,800 (of 7,631 total)