Database

noislude wrote: I created the database paddock in lowercase: The server doesn't care about upper- or lowercase; the name is case-insensitive. Same goes for tables and column-names. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Check out this: The ultimate guide to the datetime datatypes[^] And to select everything form today you can use something like this: SELECT * FROM table WHERE DATEDIFF(day, date, Getdate())=0

You've got a good point there - as there is some ambiguity in the word dynamic. I just answered the question based on how I dynamically generate columns in SPs - so yes,. if the columns were generated through the .net code or based on some meta data in a table it would be possible to know information regarding the columns before they were generated. “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

fledep wrote: object-oriented database which links to a website? You probably don't. Presumably however that you actually want a website that uses a object oriented database then you do the following 1. Research creating websites 2. Write a website 3. Research object oriented databases. 4. Pick a object oriented database 5. Write a interface layer in 2 to use 4 6. Test, test, test.

I am sorry that I was not clear, what I am trying to do is I have a register user who is building a personal family tree, when the user registers, (this is complete), the user creates a password and username, after the user register he taken to a default page where the user starts entering data to build his tree. At this point in time the user can enter the data but he can not save it to his personal tree, that what I mean by ownership. I want the user to be able to build the family tree by entering, saving and search the information in the database, it is a genealogy database. The Username and password is his personal genealogy tree in the database, that is what I call ownership of the personal genealogy tree. Can you help me with this ownership part, I look forward to hearing from you and thank you for your patience, I am fairly new to this. Thanks ;) ;) ;)

You could always setup a SQL Job to run: BACKUP DATABASE MyDB TO DISK = N'G:\SQLBackup\MyDB_Backup.bak' WITH INIT, NAME = N'MyDB Backup', SKIP, NOFORMAT, COMPRESSION

The UI (report layout) has absolutely NOTHING to do with the database. Use the stored proc to prepare the data for you. Use the UI (excel or a reporting tool) to do the formatting and layout. You sub/grand totalling should be done in the reporting app, the pretty currency format belongs in the reporting app as well. Never underestimate the power of human stupidity RAH

You are in Switzerland, that is not a 3rd world country (you don't have the excuse that you cannot afford/access .Net tech), why the hell are you developing in VB6, the language is dead and is no longer supported. You should be using VB.Net express which is FREE and supported. [edit] sorry I seem to be repeating myself [/edit] Never underestimate the power of human stupidity RAH

Are you using a SQL Express User Instance[^] (AttachDBFilename in your connection string)? These databases will automatically be closed and removed after a period of inactivity, which is why you can't see them in SQL Server Management Studio. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

chdboy wrote: We have only numeric bank account numbers The fact that they have numeric digits does not make them numbers. A street address has numeric digits but that doesn't make it a number.

Wrong forum, you need web development, this is not a database problem. Never underestimate the power of human stupidity RAH

hmm I was right :) the problem is with the DATEDIFF but I still don't know what is it.. I just used TO_DAYS instead and everything is working fine now. SET param_days_since_last_visit = (SELECT TO_DAYS(NOW()) - TO_DAYS(created_date) FROM visits WHERE file_no = param_file_no ORDER BY created_date DESC LIMIT 1); Thanks, Jassim Rahma[^] RMC[^] - Universal Medical Equipments[^] Technology News @ www.JassimRahma.com

Excellent! I may need that too. :thumbsup:

Please update your question with what the actual problem is, and what you have tried. We can't read your mind nor your monitor. Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

Mycroft Holmes wrote: This argument goes out the window if you need to maintain backwards compatibility with a crappy design. No it doesn't :) You can always keep such stuff in a view, sp or a query. I'm accepting one argument only for keeping a crappy design, and that is: If it's not broken, don't fix it. Ooh, it still feels like Monday to me. :zzz: Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

Thanks GuyThiebaut. I Solved the problem even with the warning: I just printed the content with concat. delimiter // drop procedure if exists sp_exemplo_cursor; create procedure sp_exemplo_cursor() reads sql data begin declare var_salario numeric(8,2); declare var_empregado_id int; declare var_departamento_id int; declare flag_nao_encontrado int default 0; declare csr cursor for select employee_id, salary, department_id from employees; declare continue handler for not found set flag_nao_encontrado = 1; open csr; exemplo_loop:loop fetch csr into var_empregado_id, var_salario, var_departamento_id; if flag_nao_encontrado = 1 then leave exemplo_loop; end if; select concat(var_empregado_id, ' ', var_salario, ' ', var_departamento_id); end loop exemplo_loop; close csr; end //

iCanDivideByZero wrote: any clues as to why I am receiving this error message Because "dbo.sp_GetData" uses a FOR XML clause. iCanDivideByZero wrote: How can I get around this? Remove the XML clause. iCanDivideByZero wrote: I really just need to get this data into a temp table. Than what's the use of using XML? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]