Dynamic Query in a Stored Procedure

I'm working on a web page that allows searching by date and by a specific parameter which also has an option to select whether to display records with complete data, with discrepancies, or those with no data but id.

I thought of having the conditions to be selected in the stored procedure based on the selected option passed as parameters. At first I thought of creating the query on code behind but I challenged myself to try it on stored procedures. A dynamic query is what I needed. I found a very useful information from this site with regards to creating a dynamic query.

The example is quite simple. It doesn't deal with queries containing quotes ('). I had an idea after reading this post.

As I try to save the stored procedure, I receive an error message that the select string I created cannot be converted into varchar. I had a hard time figuring out why I receive the error message until I finally figured out that i have to convert the parameter's result to varchar which is initialized as int. The solution is something like this: cast(@parameter as varchar(5)).

Don't miss LBC Express' (Hari ng Padala!) latest promos and discounts!

Become a Fan @ facebook.com/lbcexpress and Follow us @ twitter.com/lbcexpress

Latest promo: Panalo sa Padala


Click ad for more details.

START EARNING WITH NEOBUX! (PAID TO CLICK)

1. Register an AlertPay or PayPal account. Click any of these to start your registration:





2. Click this banner and start your registration on Neobux.



3. After completing the registration process, you may start clicking the ads. After clicking one of the ads, Click the red button will appear, click it and a new tab/window will redirect to the ad page. wait for the progress bar to finish and confirm that the ad is already credited to your account.



You may read more about Paid To Click and Neobux from this link:

I shouldn't be in front of the PC right now, its just that I can't help but share these quotes from the first few pages of the book Stress Free Life (from my bf) I've been reading this morning:

• How much do we lose out on the little joys of life when we cannot walk, talk, think or listen slowly?
  


• A handful of patience is worth more than a bushel of brains. He that can have patience can have what he wills. - Benjamin Franklin
  


• Anger controlled can move the world.
  


• You must connect yourself to God -- the source of the highest, purest and best energy in the Universe. Then you will not have to be pushed from outside. No one will have to wind you, or give you a boost. You will draw all the energy and wisdom of the Universe through your connection with God, and nothing can stop you!
  

Looking forward to read more as I take a rest (sick) and hopefully be back to work.

As I look for opportunities on the net, I saw this page that might be interesting for web programmers.. Check out this link:

11 Things Every Successful Website Needs