Hi folks, I have a procedure for custom/sorting paging a datagrid on a web page. It uses a sortparameter which (unfortunately) I have to pass in to...
I have a full text search sproc which accepts a string as a parameter i.e. @term nvarchar(120) I then have to do this within the sproc: declare...
Hi, how can I convert one date format to another? I have a procedure (below) where 2 dates are passed in (in UK format). Ideally I would like to...
Hi, I have been reading some articles on the site about index selection etc and keep reading the phrase "an index scan may be better if many rows are...
Hello, I'm querying a table where a lot of dates are stored per row. Each record can have up to 15 nullable dates i.e. productid, dateA, dateB,...
Hi, how can I get another inner join in here to improve the performance of this query? I'm querying a training courses database. The query below...
Hey, In a database I am designing for a website, one of the main tables is a products table. Users will need to be able to search using a search box...
Hello, I have a design issue with a table. To cut a long story short, users of a site need to be able to store their preferences in a table. Part of...
Separate names with a comma.
