Viewing 15 posts - 5,911 through 5,925 (of 7,631 total)
K. Brian Kelley (8/14/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]
August 14, 2008 at 11:03 am
I'm still trying to figure out the point of IM'ing! :w00t:
It makes about as much sense to me as getting a DSL/Cable/Fiber service and then trying to run my...
[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]
August 14, 2008 at 10:56 am
JBANKO (8/14/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]
August 14, 2008 at 10:45 am
The obvious supporting views:
--====== add some views
Create View vwBookTags as
Select BookID
, TagID
, Min(Tags.Label)
, Count(UserID) as TagCount
From BookTagUsers
Join Tags ON BookTagUsers.TagID = Tags.TagID
Group...
[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]
August 14, 2008 at 10:25 am
Well, this is how I would start; The straight-forward relational way:
/*
User table, Author and Book tables and an AuthorBookLink table.
Instead of giving each book a single category,...
[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]
August 14, 2008 at 10:18 am
Chandru (8/14/2008)
one more thing the random generated number it should notrepeate again
As Gus alluded to, this constraint...
[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]
August 14, 2008 at 9:14 am
I agree with Lowell, I know lots of ways to write a pseudo-random number generator but I am not going to bother until I understand what the real constraints are...
[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]
August 14, 2008 at 9:07 am
This should work:
Select * From (
Select A.Material, A.Maint_status,
CASE When CharIndex(Substring(A.Maint_status,1,1), B.Maint_status) > 0
Then ''
Else Substring(A.Maint_status,1,1) End
+CASE When CharIndex(Substring(A.Maint_status,2,1), B.Maint_status) > 0
Then ''
Else Substring(A.Maint_status,2,1) End
+CASE When CharIndex(Substring(A.Maint_status,3,1), B.Maint_status) > 0
Then ''
Else...
[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]
August 14, 2008 at 8:54 am
Questions:
1. Can the characters (K, C, V, D, B) be in any order in both tables?
2. should we worry about records in Table A that have no matching Material value...
[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]
August 14, 2008 at 8:33 am
I would suggest checking your master procedure.
[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]
August 14, 2008 at 8:27 am
Not sure about the rest of it, but the CAST(Varbinary as Varchar) Injection trick has been around for at least 3 months. There are several instances reported here from...
[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]
August 14, 2008 at 8:13 am
On the other hand you are right about how to finesse the Fencepost error out of the string concatenation. I couldn't remember how to do it, which is why...
[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]
August 14, 2008 at 7:52 am
Peso (8/14/2008)
Add this sample data
union all
SELECT 205,null,'',null,''
Actually, your examples are out-of-spec Peso and make two additional assumptions: First you assume that zero-length strings are permitted in the first place....
[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]
August 14, 2008 at 7:38 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]
August 14, 2008 at 6:24 am
I think that SD is looking for something less than that, John.
Try this:
Select 'Set No '+SetNo+ ': '
+ CASE When Reasons='' Then ''
When Left(Reasons,1) = ',' Then Substring(Reasons,2,Len(Reasons))
Else Reasons
End 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]
August 13, 2008 at 6:25 pm
Viewing 15 posts - 5,911 through 5,925 (of 7,631 total)