I have a users table with a field to register the date the user was registered for the first time, and another field to register the user’s...
Hello, I have this SP, and I want to call another SP to update some data, how can I do it in this part of the code? (in bold) USE dataBase3 GO...
Hello, I#%92 m trying to use an Insert script to export data from a .csv file to a database table, but I receive errors in Query Analyzer saying...
I have a table called ‘Sessions#%92 where I store some information about every client that visits my website. In that table I have a column called...
I have a marketplace where users publish offers (like ebay) while others search which are interesting, so, sellers and buyers are the protagonists....
Is there a better way to do this insert?:<br /><pre id="code"><font face="courier" size="2" id="code"><br />CREATE PROC insert_defaults<br...
Hi, I have a ‘Users#%92 table in which I have a set of fields that I want the user decides if show them or not in the web application. How can I...
I have a table called ‘offers#%92 in which I store offers published by users in my website. Now I decided they can made its offers to be displayed...
Hi, I have an Offers table where I store data such as Offer_id, User_num, theDate, Product_num, Offer_title, City, … (Is a table to store...
Hi, I have a web page where users publish offers to sell products, then other users interested in these products go to search page, and specifying...
Hi, I want to search orders by date between two given dates by user (both included), and I don#%92 t know how to do it. In this way it doesn#%92 t...
Hi, I have a Dynamic SQL stored procedure that allows user search orders/offers by specifying different parameters. Now this SP works fine, but I...
I have a query in which the user can specify from the app several fields/variables (@Quality_num, @Caliber_min, @Caliber_max, @Image,...
I have a SP with Dynamic Sql that until now worked fine. But I made longer the Dynamic Sql code, and now the variable that holds the Dynamic code has...
I want to return @TotalRegisters parameter to web app, but I don' t know how to do it. I tried this: (But it doesn#%92 t work, I receive always...
I have a dynamic SQL SP that its ‘Select#%92 statement stars thus: Select @sql = 'Declare @offer_date As datetime, @Id As bigint...
Hi, I have a SP that makes a select in Offers table according to some parameters selected by user in the application: USE market3 GO ALTER...
Hi, I have a SP to filter/query around 30 fields from web application, and one of these fields to filter (if the user want) is Order_date...
Is it a good practice delete rows in a table when they are no longer valid? If so, it can be deleted whatever number of rows and in whatever...
Separate names with a comma.
