Recent content by mmetze

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