Recent content by ericnet

Thank you for your aid

Hi, Thanks four your answer. If you don’ t mind I would like to clarify some issues About to split my users tables to allow multiple addresses, phone numbers, emails,.. Can I wait until I need those multiple records? Or is it better to prepare and split them now? Since for the moment I don’ t...

Is users table suitable for data such as user name and password? The context is one table in SQL 2000 Server for users data (Companies) in a Website marketplace who can access to it through a user name and password. And another table in the same database for users data (personnel of our...

Yes, I see.. Thanks to your last clarification I can see a more interesting solution (which I see you tried to explain from the begginig). I wanted to create two more tables after your first post (RegistersResignations and RegOrRes_type), but I’ve seen you have those two tables open to whatever...

Ok So, if I understand, you have users, RegRes, and accountActivity Tables? Instead of my two tables (user and RegRes)?

Hi, And something like this in that separate table? : RegistersResignations Table RegRes_id Reg_Or_Res (here type if we are referring to a Register or a Resignation) User_num (FK of user_id of users table) Date (the date of the register or resignation) Reason_num (FK of reasonsRegRes Table...

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 ‘reason’ of that registration. Now I’ m considering to add a field to register drops (when the user decides not continue with us, or we decide it). To do...

Perfect! Thanks again

Please one more question: 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 by the current date and user selected? ... INSERT INTO OffersPublished_Control (Date, User_num, OffersPublished...

I think I am going to consider to don't have to call the SP, and istead insert a 'future' value which will not change Anyway thank you

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 Declare @Date As smalldatetime SET @Date = '15/09/2007' --date format dd/mm/yyyy Declare @FirstDayYear As smalldatetime SET @FirstDayYear =...

It doesn’ t matter, I recommend me myself Structured Storage Files, because I don’ t have more time now. Anyway thank you for your answer!

Ok, I see, that it' s interesting, and which practice you recommend me? (msdb DB backup or save the packages as Structured Storage Files) the last one seems lighter..

Hello, Weekly I make a database backup from Enterprise Manager (right click to databaseName and I choose the option to make a copy to a CD). But now I want also to make a copy/backup of my DTS packages, Is this possible? If so, which are the steps to do it? Thanks

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 that the script recognizes only first column (whichever is), this is my .csv file: "(PDH-CSV 4.0) (Pacific Standard...