I have a standard search stored procedure I use to search all the products. I pass it the search term parameters and it returns a table of all the...
I've got a select statement I want to tell how many rows I want to select. Is there a way to do something along these lines DECLARE @numOfRows int...
Our website is largely database driven with about 8000 dyanmic pages, but we have about 300 static informational pages. Before with .asp pages it was...
I have a column just for search terms. People can enter their search terms and submit them. My sql then does a: itemSearchTerms LIKE '%' +...
I'm not sure if this is possible or if its extremely easy, but what i'm trying to do is have one database join a table from another database. They...
I am creating a search, using a stored procedure, which involves a dynamic sql being developed for each user. So there are going to be many different...
I'm looking to create a function which would take the a two digit number and return a varchar, but I can't seem to figure out all this syntax. For...
Yes, its a general question, but here's my scenario. At every page I need to look up a few columns of information. So for every user and every page...
I'm trying to find all the products which X and Y fall within different ranges. Its hard to explain, i'll just get into it: Sizes -------------...
I have two statements going, first one is a CTE and the second is a select statement which narrows down the results to only show 10 rows. So when I...
I have a table with about 80 columns in it, and 90% of them are bits. I need to make a where statement based off of checkboxes on a webpage. If they...
Separate names with a comma.
