Search results for query: *

This may well be more of a Crystal question than a SQL question. If you can execute your current stored procedures outside of Crystal (say, in SSMS) and they perform well, then this is more of an issue of how the report is constructed than the sp(s). Also don't know how, in Crystal, a stored...

That makes sense. If the table header has no knowledge of any IDX files that are built against it, then it certainly can't use it. Is there any other way to tell VFPOLEDB about an IDX file, such as thru a config file? Thanks

Queries executed from SQL Server against Foxpro free tables via the VFPOLEDB Provider do not seem to recognize IDX files. I have a linked server setup in SQL Server 2005 to a set of Foxpro free tables using the VFPOLEDB provider (v.9). If I execute a query against a table that has a CDX index...

No quick and dirty way that i know of short of scripting out the database and running the script against Access -- as i've suggested. The wizard takes care of data only. It won't even handly indexes and other such structure You may want to try the SQL Server Programming forum, as your...

You can execute Access DDL commands from T-SQL code to create the indexes in the Access mdb. You'll need to create a linked server to the mdb. Then you can execute DDL commands against that linked server. For example, you can run this command from SSMS, where the linked server name is...

SQLSister, not sure i agree that "Joins are significantly faster than subselects. MS suggests that SQL will optimize them in the same way, assuming ALL ELSE IS EQUAL. For example, if i put these two queries together and run them, then Execution plans are the same: select productcode from...

Database design aside, if you define the table with an Identity field (say you name it RECNO) with an increment of 1, each inserted row will get numbered sequentially as in your example. Just make sure they are in the order you want them as you insert them. A value in RECNO will never change...

Never done this against MySQL, but i've had explicitly type the source fields before. Not sure what type you need to map correctly to the "text" type in MySQL, but you can try a couple. Like this: insert into openquery(Archer,' select Orig_Alarm_ID,ProbableCause,Item from...

EXCELLENT solution, George. And about as simple and efficient as you can get! An ingenious way to take the commas out of the picture! I don't think i would ever have thought about that approach. I am adding this to my "tool kit" of helpful query examples, with one small improvement in case the...

Good point, George. katelhol suggests that she has control of the design. So i'll amend my comments to add: "And sometimes business priorities do not allow revising existing designs as part of a defined project." But my point is appropriate, I think. Good discussion, although maybe not an...

One easy option: Setup the ACCESS files as linked servers , then use a set of queries to get the data. For example, if you have a linked server called MDB1 you could use either of these queries to get the data from a table called XYZ: select * from openquery(MDB1,'select * from XYZ') select *...

SQLDenis, do you live in the real world? For those of us that do, we are constantly working with and integrating to databases and systems that we don't "own" and thus do not have the luxury of redesigning as you suggest. Perhaps you could provide sample queries that katehol could use to put...

Can you give a couple example rows of data in each table? The right solution may depend on what the data looks like and how much data there is (especially in TableA). Might be able to create a udf and do this with one query. Or perhaps a cursor to run thru each row in TableA looking for the...

@@rowcount returns the number of rows retrieved by a SELECT, or updated by an UPDATE, etc. So, for example: SELECT .... FROM ... if @@rowcount > 0 BEGIN -- Do whatever you want here END Be careful, @@rowcount is only good for the previous statement, so if you need other statements before...

Yes, we do it. We use an ODBC Data Source, then OLE DB for ODBC. We use a linked server, but you wouldn't have to.

Thanks. Is there an MS KB article that lists the properties you cannot get to or modify with DDL?

No, not using DAO. Using SQL DDL.

BFT1303, to do this in an automated approach, you'll have to use Integration Services, which is how SQL wants you to move data from one type of repository to another.

You can create "views" in Access. They end up as "Queries", but same thing, just different name. Try this: CREATE VIEW ML_CUST (FirstName, LastName, Phone) AS SELECT CUSTOMER.FirstName, CUSTOMER.LastName, CUSTOMER.Phone FROM CUSTOMER WHERE...

Does anyone know how to use a DDL command to remove or change a field's "Validation Rule" in an Access table? I have an existing MDB (2002) with a table that was created using the Access table designer. Table is named 'GlidePath', with a field named 'DaysOnly'. The 'Validation Rule' property...