Recent content by jmj

Here's the steps of what I want it to do 1. dump all the data from the sql table. 2. Run a macro in Access that takes linked Dbase4 tables (dbase4 linked to Access) and appends them to the linked sql database table. Our system uses a dbase 4 databases- each location has it's own copy of the...

I have some tables that have to sit in an Access database. I have a macro that takes all these tables and updates them into a SQL linked table. I would like to set it up so that the Access macro is run from a sql stored procedure. Is this possible? Or is there a different/better way...

Has anyone been able to import db4 files into sql2005. In sql2000 there was a driver specifically for db4 databases. I found one resource that said to download the foxpro driver and from there you could import any db4 file. The problem is that when using that driver it asks what foxpro...

We have a database that has a sql backend and has been working fine for months. Suddenly the ODBC call is failing, but it only fails for a link to a specific view. All other links are fine/unaffected. Any ideas why this one would fail? When I run the view from sql analyzer, the data shows up...

Thanks George. That was quick, simple, and exactly what I was looking for. I'm sure I will get a lot of use out of it! J

I have a table that holds an array of id numbers. I'd like to use this in a stored proc to pull up all the info associated with id. Would this be possible? I can't figure out how to do it because the id is an integer field and the idarray is a varchar field. For example: I have a wish list of...

That is the strange part. There are NO linked tables in this database, all local tables. I've copied lots of dbs with local tables and never saw this issue before, usually you can make a new copy anywhere. That's why I can't figure out why it's linking back to the old table. There are some...

Hi, I've never seen this before. We were copying a db to its new server. This is usually a simple copy/paste. Not only did copy/paste not work, I also made a brand new db and imported all of the objects into it. However, both ways seem to corrupt, this is what happens: 1. When adding new...

Thanks for the code- that worked great! I am definitely putting it in my code sample file! J

I need to create a table. The field names are sequential a1, a2, a3, a4, a5....to a100. The datatype is the same for each field. I have other fields that need to be in the same table, but I only need them to loop to 10 (in1 to in 10 or com1 to com10) Needless to say I don't want to write...

I have a series of queries that I need to run based on an in statement in the where clause. I need to set the variable at the beginning of the script. No matter how I declare it I get "Syntax error converting the varchar value ' 4,15,22,23,26,28,32,39' to a column of data type int." I have...

That takes out the count, but I still get a whole blank line between queries. Any way to get rid of that?

I need to output a bunch of queries from Queyr Analyzer. I'd like them to be exported without any space between each query. I've turned off the header. But after each query there are a couple of lines with a msg like "(10 row(s) affected)". Is there a way I can do this cleanly? I saw one...

declare @blah int select @blah = count(*) FROM tbl_A Where ID=3 I kept getting errors trying to get the actual count trying to do it this way. It reads it as the actual string, not as a query statement.

Ooops that should be varchar (that's what I get for typing vs. copy/paste. But yes I need this as the overall total. (The ID will actually be a loop) Declare @Total varchar(100) > SET @Total='Select count(*) FROM tbl_A Where ID=3'