Search results for query: *

I have a query (works just great in SQL Server 200) in which I need to test on one of two conditions which due to my schema are usually mutually exclusive of each other. Snipit: ...where (Field1 = 'aName' or Field2 is Not Null) The problem is for the most part when Field1='aName', Field2 is...

I have An ASP file in which I create two msxml2.domdocument objects. Populate one with an xml string, and the other with an xsl string. Then translate the xml using the xsl. Finally load the final translated xml into the xls object to write it to the hard drive. This seems to work in 3 out of...

IN SQL Server I am aware of two statements that drop the caching of a query plan. I am looking for the equivalent in Oracle to use when optimizing a query. The SQL Server statements are. dbcc dropcleanbuffers dbcc freeproccache

Need to be able to check if a Stored procedure already exists. I am familiar with SQL Server code as in Begin If Exists (select name from sysObjects where name = 'procName' and type = 'P) Drop procedure 'procName' End Can I replicate that in concept Oracle. I don't plan to replace...

In an attempt to compare two diff. SP methods I have created a T-sql batch to replicate the SP for the purposes of looking at the execution plan. One of my tests uses a simple temporary table but Quary Analyzer will not give me a plan instead I keep getting an error however I can run the query...

When tying to optimize some statements, I know that QA will cache the query plan and data buffers. However, this throws off the testing. I know there are some settings or statements that I can enable/disable these two built in features with. Thanks

This is difficult to put into words. I have a very long Stored Procedure (SP) for a collection of reports. The SP has 6 unioned selects in it and also has 6 optional parameters. By passing yes or no into each of those 6 parameters I can have the SP return data from only the unions that I want...

I will have the full street address in a database field and need to break it into 3 pieces street # street name street type (comparing it against a pre defined list of types. street - st, road = rd and so on) Thanks

Hello, Question: From within a xsl:for-each statement can I use an xsl:if statement to compare a node value from w/in the for-each branch to a node outside the for-each Example: <data> <app> <record/> </app> <tenant> <handle/> </tenant> <data> Can I have a for-each...

I am looking for a way to replace the XML entities from varchar type data in a query. For example if my query returns 'Bob&Mary' I want that to be replaced with 'Bob&amp;Mary'. My problem is what if the db field already has the replacement in it. I don't want to replace the & that is part...

Using the Record selection formula editor I am having difficulty illiminating NULL Dates. Per Seagates website ( http://support.crystaldecisions.com/library/kbase/articles/c2006588.asp ) They acknowledge this problem. However their solution will only work in either version 8 or version 9...

I have an option object that I need to evaluate the selection of by comparing the original value that was loaded when the page was sent to the new value on changes. Once the onChange() event occurs, I have lost the original value in object.options[obj.selectedIndex].value Question: &quot;How...

What system table and field values do I need to search to determine whether an index of a known name exists on a specific table and whether the index was created as Unique or not. SP_Help is not what i am looking for. Using sql 2000 I need to be able to do this from VB code Thanks

What system table and field values do I need to search to determine whether an index of a known name exists on a specific table and whether the index was created as Unique or not. SP_Help is not what i am looking for. I need to be able to do this from VB code Thanks

I have a cross tab that may only have 5-10 rows, lives in the report footer but but will not print on one page. If the last group footer finishes with some room left on a page, the cross tab is started on that page then continued on the next (whihc is the last) page. I have tried using the...

When using the debugger I get the above error. There is good instructions in the MS SQL Server Help files on how to configure dcomcnfg.exe to allow permissions to this service. THe instructions worked on my Windows 2000 machine. I am unable to duplicate the fix on a Windows XP machine. Largely...

I would like to create a stored procedure which utilizes some user defined functions if the DB version is 2000 if not don't look for the UDF. The following example displays what I would like to do, but does not work. It seems that SQL server will try to find the UDF even if it not actually...

I would like to use the &quot;Select Into&quot; syntax to populate a temptable but instead of using a select statement in the select into I would like to use an execute proc_name statement Standard Example: I know the following works Select * into #myTable from some_real_table What I want to...

BACKGROUND: I have a number of stored procedures used to return very detailed and wide (many columns) recordsetS for reporting. I have found that I can execute this SP recordset into a table or temp table to then manipulate the data further using a syntax as follows: Insert into #temp_Charges...

It appears as if the only options for text object rotation are 0, 90, and 270 (for version 8.0). I am wanting to put a bunch of column headings on a 45 degree slant. Has anyone figures out a way to do this? Thanks PL