Search results for query: *

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...

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...

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...

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...

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...

Im using query analyzer to send results to a file. I have a series of queries that need a variable input. I want to declare the variable at the top of the page depending on an id. I'm not sure how to get past this point. Declare @Total int SET @Total='Select count(*) FROM tbl_A Where ID=3'...

I am trying to output the results of a query. I'd like to be able to flip how the results come out. Currently they come out like so Question1 Location1 count of Question1 likes/dislikes Location2 count of Question1 likes/dislikes Location3 count of Question1 likes/dislikes I'd like the...

I inherited a table used for a survey. Each question of the survey is a field name, and there are 35 questions in the survey. So each person that takes the survey adds one row to the table They want to results like outputted 1. by place evaluated (mall, school, etc) 2. the question with a count...

I'm pretty weak with vb, but think I need it for a particular issue I have. I made a little db that will combine test score data with the student data. The user imports an excel sheet, runs checks on student data, then spits out a report. There is one very cumbersome step for the user that I...

I am using a macro to transfer text the data from a spreadsheet into a new table. The spreadsheet can range from 10-70 columns. (It starts as a .dlm file which is an ascii delimited file. Since access doesn't recognice .dlm I save it as a .txt or .xls) The table made with data does not match...

I'm wondering if I can do this in a query or need to make a couple of temp tables. I want a count of many students scored in certain ranges of a test. (0-50/50-69/etc) I need the following: 1. A student is only counted one time for the test. 2. the highest grade should be counted for each...

I have a table that holds enrollment information. I need to know what students have been retained. In the table this will include 3 fields; the studentID, the gradelevel, and the schoolyear. I need to pull all the students who have been retained; they have the same studentid, the same...

I have a query that counts the demographics of students in the various classes (ie: 12 students in french 1 8 females/4 males) One problem. Sometimes a class will be made up of a couple of different courses (ie: Latin III and Latin IV may be taught in one class). I would like to consolidate...

I have a job that has several steps. It imports data from another database. Using a stored procedure, it then deletes the data from the current database and replaces it with the imported data. From there it goes on to run another series of stored procedures that update the data. Problem...

I need to run some counts on demographic data- it needs to all be in one report. But I'm having some problems figuring it out. I am using a case staement to do a count inside a select statement. (See below for code). Counts correctly when there's only a few things to count, however, the number...

I am running queries to do a count of data (How many males/females, how many speakers of spanish/french/etc). All is fine as long as the case statement uses an = sign. If I need an in clause (CASE WHEN EnglisProf IN('A', 'B') then count(EnglisProf) else 0 end as EnglisProf1) then it will only...

Hi. I need to make an xml file of all the courses the teachers teach. I am currently doing this from an Access database (If it works easier in sql let me know and I can move the data there). It needs to be in an exact format to be used by some palm software. My problem is I can not seem to...