RE: Dynamic queries v/s Stored Procs

2006-02-28 Thread rtroiana
sql string embedded in C# code? Thanks, Reema -Original Message- From: James Black [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 10:54 AM To: rtroiana Subject: Re: Dynamic queries v/s Stored Procs -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 rtroiana wrote: > Al

Re: Dynamic Queries followup

2004-08-25 Thread SGreen
By Jove! I think he's got it! BTW - Rhino, that was an EXCELLENT response. Stuart, I believe you have seen the light. What you figured out, thanks to Rhino and your own intuition, is basically how to normalize your data. Normalization is critical to database performance, scalability, and st

Re: Dynamic Queries followup

2004-08-23 Thread Stuart Felenstein
Thanks again for a wonderful detailed response. The part that was still bothering me was the multiple-same-category fields. I get locked into this thinking and well, it's difficult to let go. Then I tried something on a table that had MemID, Doc1, Doc2, Doc3 I had put Doc1 in a few hours earli

Re: Dynamic Queries

2004-08-22 Thread Stuart Felenstein
I think I failed to make something clear. The form and table that has the multiple selections from one category into multiple columns / same category is where users are inserting information. Hope this helps. Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > Rhino, > First, thank you f

Re: Dynamic Queries

2004-08-22 Thread Stuart Felenstein
Rhino, First, thank you for the great response. Also, sorry cause on the reply , Yahoo was truncating the part I wanted to reply about. Anyway, yes it was the second case. I ask a user to pick 5 colors, so in my table I have fields In my uneducated mind I "thought" that would make for

Re: Dynamic Queries

2004-08-22 Thread Rhino
- Original Message - From: "Stuart Felenstein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 22, 2004 7:32 AM Subject: Dynamic Queries > Not sure what to call what I'm attempting to do, > decided on dynamic queries. I should mention that I've > been working with datab