Search results for query: *

Ok, I took your advice and learned how to do stored procedures. Here's the revised plan I came up with: /***************************************************/ CREATE PROCEDURE sp_locationInsert AS SET NOCOUNT ON insert into tblLocation WITH (TABLOCKX,HOLDLOCK) (zip, state, city, county)...

Ok, I'll have to find out what those two tools are first. I wonder if 300,000 records in the tblFISData is just too much to try and sort through in one statement? For instance, running just the last insert by itself still causes a timeout error.

I converted my insert statements into a stored procedure and still getting the error: [Microsoft][ODBC SQL Server Driver]Timeout expired -Shawn

Well, it's been awhile since I started this thread, but got pulled away to other things and finally back working on this. I'm trying to use somethink like what MrDenny suggested, however I think my sql code needs to be optomized somehow as I'm getting "Timeout expired" errors when trying to run...

Thanks. I understand what you mean about not using the @@identity. If I can grab the right identity through your method, I think my problem still lies in the fact that I am doing a multiple rows type insert statment like: INSERT INTO tblName SELECT something FROM otherTable WHERE...

I'm getting sql timeout errors with this code, so I'm wondering if someone could help me make it smaller. I was wondering if there was a way to grab the @@Identity while inserting records so I didn't have to do the third statement which searches the key column for a unique id. Here is what I'm...

Oh and yes we have asked them to change the permissions and they said they don't allow that. Probably because they only have a shared SQL box and not a seperate one for each account and are scared of us stealing too much cpu.

I'm not in control of the web host. It's for a company I'm working with and they are very happy with their hosting company they have been using for years and have many accounts with etc. I have been unable to sway them to another hosting company so I'm stuck with what I have to work with...

Hello all. I'm working on a project that is loading fairly large comma/return character seperates .txt files into a database. I know BULK INSERT is the fastest way to do this, however the company that is the web host for this won't allow me to have BULK INSERT permission so when trying it I...

Wow, that's some great coding there. I wasn't even thinking about putting a select statement after the where statement on the insert either. For instance when I put information in tblLocation, first I do a query like "where zip=<zip> and state=<state> and city=<city> and county=<count>". If I...

Hmmmm. I will look into that approach to see if it helps my problem. So you are saying that I should be able to load the file with an sql statement instead of a script to a multi-column table and then use sql commands to move the information to the apporpriate places? Maybe you can help shed...

Yea, I haven't done a trace yet, but I did find that the IP given to FTP files is different from the one used to access the web page. The FTP IP is similar to the SQL IP so that might be in the same location. The SQL has to be loaded through the web server as it is not a direct insert...

Thanks for the information! Just wanted to get a few things straight on this before I call and tell them that is not their local IP they say it is... Ok, the web page IP is not similar at all to the IP of the SQL server. It is like 66.165.XXX.XXX. So according to mr denny ( If it's within...

Hello all. I have a client that is signed up through a web service that has their sql database on a seperate computer from where the pages are hosted. We seem to be getting much slower connections than I am used to in SQL and I think the problem might be that we are connecting to SQL through...

Ok, thanks alot guys. I'll look into mySQL replication and once I learn how that is done Eric's ideas sound good. I'm getting a grasp on the theory of this, but not sure on the codeing I would need. All my PHP/Mysql references I have don't seem to mention this, or only vaugly go over...

Is it possible for you to save the file directly into a database instead of linking to a url? Then you could only access that with php if the user has been authenticated. Other than that my only other thought would be to 'htaccess' protect the directory that holds to files server side...

Ok, I think I'm really over my head on this one. I've been designing a Flash/PHP/mySQL database driven e-commerce site for the company I work for, however now I'm informed that they want to have this span across multiple servers. I can handle php/mySQL enough to get an e-commerce site up and...