Hi, Yes, I am considering this user registration/dropping history. How could I design the database so that I can keep history of user registration...
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...
Do you know how can I do it in my first posted code so that my OffersPublished column shows 0 value instead of Null value when none offer is counted...
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 see one interesting thing, when I execute my insert statement returns errors for all columns of .csv file except for the first column. So, seems...
Because every day I have to export a different .csv file name to a DB table, and having to follow all DTS wizard every time is very long. Instead,...
Hi Frank, <br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Now,...
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...
Perhaps I haven#%92 t explained my idea in a clear way. All I want to do is track user activity of my website using the DB, and specifically...
I have a marketplace where users publish offers (like ebay) while others search which are interesting, so, sellers and buyers are the protagonists....
This looks very good <img src='/community/emoticons/emotion-1.gif' alt=':)' />, I think I will implement it.<br />By the way, instead of...
Hi again, In ‘data_visibility#%92 table I have also other records that are from other parts of the website, and in this case I only want to...
Hi ji06, that#%92 s a very good idea!, thank you so much [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
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...
Ok thanks, finally I changed a bit my code [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]. Now 'status_num' column is NOT NULL, so only...
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...
Brilliant, simply brilliant! This is the explanation I was looking for, you are the best!! I can#%92 t say anything else because the explanation is...
Separate names with a comma.
