Search results for query: *

Anyone have a work around for using sp_executesql like in the situation below within a user defined function. EXEC sp_executesql @rule,N'@check_rule bit OUTPUT',@check_rule OUTPUT I have tested the function parts in query analyzer the results are what I want but when I create the function I...

What is the Math function that returns the division remainder? Thanks in advance, Bygs

I am having a hard time finding a detailed object model for the pivottable component with a few examples. Has anyone worked with the activedata portion. I am trying to enumerate through the record set to write the details to a .csv. I think I am close but the problem is I can't find key words...

Has anyone run an MDX query in a stored procedure through an MS SQL Server to an OLAP Database??? Thanks in advance, Bygs

I am new to Cold Fusion and was wondering if anyone has tried to query a MS SQL OLAP database??? If so could you give me the appropriate connectstring for the query tag.. Thanks.... cfquery name="testOLAP" dbtype="dynamic" connectstring="" thanks in advance, Bygs

Im new to crystal reports (ver8.5) and having a hard time changing the database source to point to a similar stored procedure just a different name without losing the current report format. The new stored procedure has all the same field names. The final outcome is all the fields are lost. I...

This is on MS SQL 2000 with service pack 3 installed. I have recently added a new table to my already existing replication model. The subscriber has received 415 more records than the publisher has. All the other tables in the model are exactly the same. The funny thing is that the new table...

I am trying to create a scrollable recordset using the CallableStatement with MS SQL SERVER 2000. When I test the stored proc FORWARD only its fine, but when I try to move through the record set I get an error saying recordset is forward_only. here is my snippet: DBMS.JDBCsetup(); Connection...

I would like to change the sharing status on some of my dimensions. I would prefer to have a specific cube's dimensions only available to one specific cube. Where do I change this status. Thanks in advance, Bygs

how can I declare the name of a vector instance dynamically? I am passing an array of Strings to a function, each element of the String array needs to create a vector. for(int i; i < array.size(); i++){ //Vector array[i].toString() = new Vector; Vector ???? = new Vector(); } I am looking for...

Has anyone ever used Query of a Query in Java? Similar to how Cold Fusion lets you use record sets. I am also trying to cache a query and set how long I want it to stay cached in the database. I am using MS SQL 2000.. Thanks in advance, Bygs :-)

I am trying to dynamically create variables and set them. Does anyone know the syntax. declare @loop int set @loop = 4 WHILE (@loop > 0) BEGIN declare @sql+convert(varchar(1000),@loop) varchar(8000) set @sql+convert(varchar(1000),@loop) = 'select * from table' set @loop = @loop - 1 END...

Does anyone know of a utility that can do a comparison of an entire database to another database? Both databases have the same infrastructure, but one was archived and one contains new data. I am looking for some sort of built in utility that can tell me all the differences in each of the...

Has anyone come up with a solution for keeping leading zeros in a number field when you write to a csv file. e.g. 00000045 --> 45 (on csv when open in a spreadsheet) Currently, the only solution I have is putting a dash in front of the number before it writes to the file. e.g. -00000045 -->...

I am trying to dynamically remove options from a select box. Does anyone know the syntax for removing the option element and adding an option element.. e.g. for (i = 0 ; i < document.cycend_range_selection.StartDay.options.length - 1; i++){...

I have been running the same SQL scripts for about a year now. Just yesterday I received this error, for a bunch of queries that were run which normally have not been a problem. Server: Msg 913, Level 16, State 8, Line 5 Could not find database ID 8. Database may not be activated yet or may be...

Hi all, We are finally implementing permissions on our MS SQL 2000 (sp2) server. I have an issue with something though. When I create a table from the enterprize manager the table is created as DBO but when I open a query analyzer and create the same table it is created with the user Account...

I was trying to bulk update one field in a table that contains 200million records. The table is indexed by this field and all I am trying to do is trim the spaces off of both sides of the containing data. To no avail the process was running for 20 hours and I had to stop it cause other system...

Hello All, Is there a way to control frames in a frameset? If there is does anyone have an example of syntax to open and close a frame with a frameset structure like this: <frameset rows=&quot;45,*&quot; border=&quot;0&quot; framespacing=&quot;0&quot; bordercolor=&quot;white&quot...

Is there any way to get the alt message to stay up for more than 10 seconds when you mouseover an image?