Click here to Skip to main content
12,510,860 members (57,450 online)

Welcome to the Lounge

   

For discussing anything related to a software developer's life. Technical discussions are encouraged, but click here to ask your programming questions.

The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct, no programming questions and please don't post ads.
 
GeneralRe: Swatting a fly with a nuke Pin
Marco Alessandro Bertschi14-Jan-13 20:21
memberMarco Alessandro Bertschi14-Jan-13 20:21 
GeneralRe: Swatting a fly with a nuke Pin
BobJanova14-Jan-13 22:39
memberBobJanova14-Jan-13 22:39 
GeneralRe: Swatting a fly with a nuke Pin
Johann van der Smut14-Jan-13 23:51
memberJohann van der Smut14-Jan-13 23:51 
GeneralRe: Swatting a fly with a nuke Pin
Bassam Abdul-Baki15-Jan-13 1:36
memberBassam Abdul-Baki15-Jan-13 1:36 
GeneralRe: Swatting a fly with a nuke Pin
Kyudos15-Jan-13 10:04
memberKyudos15-Jan-13 10:04 
GeneralRe: Swatting a fly with a nuke Pin
Bassam Abdul-Baki15-Jan-13 14:56
memberBassam Abdul-Baki15-Jan-13 14:56 
GeneralRe: Swatting a fly with a nuke Pin
Kyudos15-Jan-13 16:13
memberKyudos15-Jan-13 16:13 
GeneralRe: Swatting a fly with a nuke Pin
Bassam Abdul-Baki16-Jan-13 0:37
memberBassam Abdul-Baki16-Jan-13 0:37 
GeneralWell, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 15:09
protectorAspDotNetDev14-Jan-13 15:09 
GeneralRe: Well, I Give Up (on SQL) Pin
Marc Clifton14-Jan-13 15:33
protectorMarc Clifton14-Jan-13 15:33 
GeneralRe: Well, I Give Up (on SQL) Pin
Chris Maunder14-Jan-13 15:35
adminChris Maunder14-Jan-13 15:35 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 16:14
protectorAspDotNetDev14-Jan-13 16:14 
GeneralRe: Well, I Give Up (on SQL) Pin
PIEBALDconsult14-Jan-13 16:54
memberPIEBALDconsult14-Jan-13 16:54 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 17:23
protectorAspDotNetDev14-Jan-13 17:23 
I did similar, though a LIKE '%Whatevs%' was too slow, so we split the strings and tossed them into a table like this (this is a simplified version):

















SectionCompleteType
yUglyName
lyUglyName
glyUglyName
UglyUglyName
3123ID
23123ID
123123ID
CABCSKU
BCABCSKU
ABCABCSKU
cUgDocDocument
ocUgDocDocument
DocUgDocDocument
gDocUgDocDocument
UgDocUgDocDocument
Then we could do SELECT DISTINCT Complete, Type FROM Sections WHERE Section LIKE @Input + '%'. That can use the index rather than a full table scan (and still allows for the middle of a string to be searched). Then we use the compete string to do an index seek in the other tables. But that was before the addition of "Color" as a filter. That's where things get complicated.

GeneralRe: Well, I Give Up (on SQL) Pin
Chris Maunder14-Jan-13 18:14
adminChris Maunder14-Jan-13 18:14 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev14-Jan-13 18:55
protectorAspDotNetDev14-Jan-13 18:55 
GeneralRe: Well, I Give Up (on SQL) Pin
Nagy Vilmos15-Jan-13 0:10
memberNagy Vilmos15-Jan-13 0:10 
GeneralRe: Well, I Give Up (on SQL) Pin
PIEBALDconsult14-Jan-13 15:52
memberPIEBALDconsult14-Jan-13 15:52 
GeneralRe: Well, I Give Up (on SQL) Pin
Rutvik Dave14-Jan-13 18:32
memberRutvik Dave14-Jan-13 18:32 
GeneralRe: Well, I Give Up (on SQL) Pin
Jim Meadors14-Jan-13 20:05
memberJim Meadors14-Jan-13 20:05 
GeneralRe: Well, I Give Up (on SQL) Pin
digimanus14-Jan-13 21:58
memberdigimanus14-Jan-13 21:58 
GeneralRe: Well, I Give Up (on SQL) Pin
AspDotNetDev15-Jan-13 3:40
protectorAspDotNetDev15-Jan-13 3:40 
GeneralRe: Well, I Give Up (on SQL) Pin
digimanus15-Jan-13 3:43
memberdigimanus15-Jan-13 3:43 
GeneralDell Buyout Pin
Kevin Marois14-Jan-13 11:16
memberKevin Marois14-Jan-13 11:16 
GeneralRe: Dell Buyout Pin
DaveAuld14-Jan-13 11:29
mentorDaveAuld14-Jan-13 11:29 
GeneralRe: Dell Buyout Pin
_Maxxx_14-Jan-13 12:26
member_Maxxx_14-Jan-13 12:26 
GeneralRe: Dell Buyout Pin
DaveAuld14-Jan-13 12:31
mentorDaveAuld14-Jan-13 12:31 
GeneralRe: Dell Buyout Pin
_Maxxx_14-Jan-13 12:47
member_Maxxx_14-Jan-13 12:47 
NewsHMV Next? Pin
DaveAuld14-Jan-13 9:59
mentorDaveAuld14-Jan-13 9:59 
GeneralRe: HMV Next? Pin
Clifford Nelson14-Jan-13 10:04
memberClifford Nelson14-Jan-13 10:04 
GeneralRe: HMV Next? Pin
DaveAuld14-Jan-13 10:08
mentorDaveAuld14-Jan-13 10:08 
GeneralRe: HMV Next? Pin
Clifford Nelson15-Jan-13 7:12
memberClifford Nelson15-Jan-13 7:12 
GeneralRe: HMV Next? Pin
Mark_Wallace14-Jan-13 20:24
memberMark_Wallace14-Jan-13 20:24 
GeneralRe: HMV Next? Pin
DaveAuld14-Jan-13 20:50
mentorDaveAuld14-Jan-13 20:50 
GeneralRe: HMV Next? Pin
GuyThiebaut14-Jan-13 21:49
memberGuyThiebaut14-Jan-13 21:49 
GeneralRe: HMV Next? Pin
PHS24115-Jan-13 1:40
memberPHS24115-Jan-13 1:40 
GeneralRe: HMV Next? Pin
PIEBALDconsult15-Jan-13 13:53
memberPIEBALDconsult15-Jan-13 13:53 
GeneralTo the Rescue Pin
Andy_L_J14-Jan-13 9:10
memberAndy_L_J14-Jan-13 9:10 
GeneralRe: To the Rescue Pin
OriginalGriff14-Jan-13 9:12
mvpOriginalGriff14-Jan-13 9:12 
GeneralRe: To the Rescue Pin
Andy_L_J14-Jan-13 9:51
memberAndy_L_J14-Jan-13 9:51 
GeneralRe: To the Rescue Pin
OriginalGriff14-Jan-13 10:16
mvpOriginalGriff14-Jan-13 10:16 
GeneralRe: To the Rescue Pin
Andy_L_J14-Jan-13 10:28
memberAndy_L_J14-Jan-13 10:28 
GeneralScrew You, SSMS Pin
AspDotNetDev14-Jan-13 9:00
protectorAspDotNetDev14-Jan-13 9:00 
GeneralRe: Screw You, SSMS Pin
Ennis Ray Lynch, Jr.14-Jan-13 9:18
memberEnnis Ray Lynch, Jr.14-Jan-13 9:18 
GeneralRe: Screw You, SSMS Pin
AspDotNetDev14-Jan-13 11:40
protectorAspDotNetDev14-Jan-13 11:40 
GeneralRe: Screw You, SSMS Pin
S Douglas14-Jan-13 10:03
memberS Douglas14-Jan-13 10:03 
GeneralRe: Screw You, SSMS Pin
snorkie14-Jan-13 10:21
membersnorkie14-Jan-13 10:21 
GeneralRe: Screw You, SSMS Pin
mark merrens14-Jan-13 10:05
membermark merrens14-Jan-13 10:05 
GeneralRe: Screw You, SSMS Pin
AspDotNetDev14-Jan-13 11:42
protectorAspDotNetDev14-Jan-13 11:42 
GeneralWindshield Stress Crack Pin
Colin Mullikin14-Jan-13 7:52
memberColin Mullikin14-Jan-13 7:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.160929.1 | Last Updated 30 Sep 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid