Search results for query: *

I am looking for a method to create and deploy generic, reusable functions on multiple databases across multiple SQL servers. For example, what I would like to do is to provide a wrapper for the scripts I have for doing things such as searching for a given text string within all stored...

also... thanks to skuhlman for the tips. the joins work as advertised and take the guesswork out regarding which tables will be affected.

it appears that it is valid to include 2 FROM clauses in a single DELETE stmt. the 2nd is used soley to allow a JOIN to be performed and only rows from the 1st are removed. special thanks to 'cutiger93' for the following tip... Create table #TempCurCred(ssn int,vcAreaCode int) Create Table...

in my 1st update stmt- yes, i did leave off the column name in the where clause. in the delete stmts, are rows being deleted from only the #TempCurCred table? this concept is confusing relating to the normal stmt: 'DELETE FROM table WHERE condition'

i'm looking at a stored procedure that uses temp tables in an UPDATE...SET...FROM...WHERE stmt- i've never seen this combination before. i will note that in the example below, a column was created (AREA_1) with a very similar name as the temp table (#AREA_1) UPDATE #TempCurCred SET...

i have created an xml schema and am trying to ensure the syntax is correct. i am using the on-line validator from the w3c site... http://www.w3.org/2001/03/webdata/xsv. the schema can be found at the location... http://cougar.freewebpages.org/SNACSClaim when i try to validate the schema using...

is there a way to programmatically full expand a drill down report? i have a report that i would like to present the user with an option to print the full report or drill down to the desired level & print.

thanks for the tips. i had finally accomplished this by using a global variable to hold the sum & pass to another formula. the 2 suggested approaches would be much easier to implement! thanks again to both of you!

i have a report with the following 4 fields as illustrated below... district members days average ====== ====== === ===== Northeast 10,000 10 1,000 Southeast 20,000 10 2,000 i have set up the report for grouping by district and members is a summary field that is...

by adding... Response.AddHeader "Content-Disposition", "filename=mydata.xls;" ... does this open an existing excel file within the browser? i am attempting to dynamically display data populated from a recordset into an excel workbook within the browser. i do not wish to...

i have a client who tries to execute the following code which displays data in an excel workbook within the browser. however, the result of executing this code is 'unable to initialize visual basic environment". i am unable to duplicate this problem locally on my box. could this prob be...

when attempting to perform a 'get latest' from the project explorer, the following error is received... Failed to reload the project. fyi... i am running VS-SP5 on Win2000

i have an interdev solution that contains approx 20 asp files on the project level and an additional 6 asp files under an include folder. when i run the application within interdev, i can see the changes that i make on the asp files on the project level, but the changes to files under the...

I am trying to update all rows in a table based upon values found in another table. Below is an example of what I am trying to accomplish... UPDATE table1 t1 SET t1.column1 = SUM( SELECT t2.column1 FROM table2 t2 WHERE t1.column2 = t2.column2 AND t1.column3 = t2.column3 AND...

Does anyone know if there is a freely available ODBC or OLEDB driver for accessing a DB2 database on an OS/390 mainframe? Would this be included in a version of MDAC? I found an article referencing this in the MSDN Library that mentioned a freely downloadable driver from Neon systems and it is...

Check out Dezign for Databases (The current sponsor at the top of the tek-tips page...) for a more economical alternative @ $139. They offer a trial version that can be freely downloaded.

I'm a VB guy with no VC experience. However, when you use ADO in VB, you use thee connection object to connect to the datasource (not a specific table). For example... Dim cnMyConnection as Connection Set cnMyConnection = New Connection cnMyConnection.Provider = "SQLOLEDB&quot...

Thanks for the help! I never thought about joining the 2 tables with a LIKE condition, as I have always joined where a primary key of one table equalled a foreign key of another table. Does joining tables using a LIKE have performance implications?

Personally, I have found ole db to be pretty straight forward (in a VB environment, anyway) and yes, I would suspect there would be some (not sure how to quantify 'some') overhead in using ODBC drivers. Perhaps the following MSDN Library article could give additional insight...

I am trying to select values from one table which meet the criteria of a range of values found in another table. Perhaps displaying the SQL would provide a better illustration... Below is the SQL statement that I currently have that returns an error: "Subquery returned more than 1 value...