Search results for query: *

Once again, thanks for the posts...greatly appreciated. As I am pretty new to this side of SQL Server, any info is a great help. So after much research here is my latest SQL Server config: -SQL Server Standard, for the time being. -Windows 2003 server -Dual CPU ~3Ghz -4GB RAM. I guess I will be...

Another question for you guys.... We have 2 different applications here that both utilize SQL Server. My plan is to have both of these apps to use this new server that we have been discussing. The only problem is that both applications are job # based therefore it is highly possible that we...

Thanks to all that posted, the information was awesome and we are well on our way to a new server, YEAH! So here is what I had in mind for my server setup, please feel free to make any comments or suggestions. - RAID 1 (30 - 60 GB Drives) for the OS and SQL installation. - RAID 5 (4 drives...

Hey, I recently was asked to review the status of our current SQL Server and whether it was going to be sufficent to accomadate our companies current growth. I am a developer by trade so any advice would be greatly appreciated. The current server is a Windows 2000 box with SQL Server...

Thanks for all of the replies (and code!!). Greatly appreciated!!

I currently have a client whose webpage contains multiple hyperlinks to folders on their network. Unfortunately, these links are quite static and the folder structure is always changing, therefore a real pain in the butt for support. What I would like to accomplish is upon loading of the web...

synap, I had no idea that crystal reporting was limited to graphing for just each row... :( If I was to pivot the data, are you saying that is should fit the crytal graphing model then? I am not really sure how to do this, could you provide a little detail? If I cannot get this to work...

I have a table that contains the following data: JOB Field1_Acutal Field1_Budget Field2_Acutal Field2_Budget --- ------------- ------------- ------------- ------------- 1 10000 15000 1000 4000 2 25000 27000 1250 5650 What...

I have a table that contains the following data: JOB Field1_Acutal Field1_Budget Field2_Acutal Field2_Budget --- ------------- ------------- ------------- ------------- 1 10000 15000 1000 4000 2 25000 27000 1250 5650 What...

Thank everybody for your help, I got it working. Yahoo!!

Thanks for the help so far..greatly appreciated. Thus far, I think the way to go will be to use the @@identity within my stored proc since this will be a multi-user application. Well this leads me to another question.. The code that I am using to call the stored proc from VB is: strSQLSave =...

Thanks in advance for any help that you can offer me: So here is the scenario. I am working with a SQL Server 7 backend end and a VB front end. I have a table that we can call ‘class’ and that table has two fields: 1. Class_Id – int(identity increment.) 2. Class_Name – Varchar 3...

Thanks in advance for any help that you can offer me: So here is the scenario. I am working with a SQL Server 7 backend end and a VB front end. I have a table that we can call ‘class’ and that table has two fields: 1. Class_Id – int(identity increment.) 2. Class_Name – Varchar 3. etc.. Once I...