Viewing 15 posts - 6,256 through 6,270 (of 7,631 total)
Jack Corbett (7/21/2008)
You can actually eliminate the reference to the tblUsers table altogether and just do:
Actually, Jack, [font="Courier New"]@UserID[/font] matches to [font="Courier New"]UserName[/font], not [font="Courier New"]UserID[/font].
[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]
July 21, 2008 at 6:02 pm
My suspicion is that SSMS is keeping track of the transaction identities or else is receiving notifications for the transactions that it creates and thus knows that you have canceled...
[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]
July 21, 2008 at 5:01 pm
What error do you get?
[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]
July 21, 2008 at 3:57 pm
Jacob Pressures (7/21/2008)
I'm using VB6 with ADO.
In that case, I'd suggest that you stick with AppRoles. When combined with good stored procedure security, they provide very good ROI, security-wise....
[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]
July 21, 2008 at 3:46 pm
Michael Valentine Jones (7/21/2008)
It’s not arrogant if you can back it up.
No, actually, it is arrogant if you can back it up. If you can not back it up,...
[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]
July 21, 2008 at 1:02 pm
Brandie Tarvin (7/21/2008)
And yet a poorly written ETL process could inadvertantly orphan records.
Well, that's an argument for code reviews & good testing, not Triggers in the DW, remember,...
[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]
July 21, 2008 at 11:51 am
Jonathan Kehayias (7/21/2008)
What version of Oracle and is SQL running on x64 or x86?
Oracle 10g. SQLServer 2005, x86 for development and test, x64 is the production target.
[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]
July 21, 2008 at 11:19 am
Jonathan Kehayias (7/21/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]
July 21, 2008 at 10:48 am
b_boy (7/21/2008)
Hello AllI kinda found a way which is KISS (Keep It Simple and Simple), i used in my select query:
WHERE[ExpiryDate] BETWEEN getdate() AND getdate() +30
??? So I guess...
[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]
July 21, 2008 at 10:01 am
dlongnecker (7/21/2008)
Sweet, thanks.That should work because i'm doing this in a small database with few users. But is there a way to do it that isn't a triangular join?
Like this:
Select...
[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]
July 21, 2008 at 9:34 am
Seems reasonable to me. I might add that, if I cannot reproduce the problem, I would either go back to the user who originally reported the problem or (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]
July 21, 2008 at 9:12 am
b_boy (7/21/2008)
I am trying to write a query, that will retrieve records of customers that are about to expire within two week of expiry....
WHERET_Customers.ExpiryDate = (GETDATE() + 7)
Did you really...
[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]
July 21, 2008 at 9:06 am
Frankly, I am not much of believer in RI in a datawarehouse. I know that many people swear by it, but since there aren't any interactive users with write...
[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]
July 21, 2008 at 8:01 am
Like this:
Select Top 1 * From (
Select Top 5
Emp_ID,Emp_Name,Emp_Salary
From Employee
Order By Emp_Salary
) Order By Emp_Salary DESC
[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]
July 21, 2008 at 6:30 am
Please review the link the Michael Earl posted above and supply more information.
[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]
July 21, 2008 at 6:21 am
Viewing 15 posts - 6,256 through 6,270 (of 7,631 total)