Search results for query: *

Hello, I have setup Tomcat to work with IIS on Win 2K. I successfully configured the ISAPI filter in IIS to point to Tomcat. I checked the IIS_redirect logs and they show that IIS is able to initialize the ISAPI filter and talk to Tomcat over AJP 1.3. The tomcat web server returns an HTTP...

Hello, I have a table, the table has as subset of columns N I need to Sum( N ) and set the value in a column Rank Below I am showing an example, with Rank showing the calculation I must achieve. ******************************************************** Table...

Hello, I have an update query which is being created dynamically. The update query needs to select a value from a temporary table and use that value to make the update. If the value was in a variable @var_val the query is Update <Table_Name> Set Column_Name = @var_val where Column_Name >...

Hello, I am constructing a dynamic T-SQL query. code snippet ---------------------------------------------------------- set @value_string = ' Select @temp_val = isNull( ' + @curr_char + ' , 0) from ##' +@input_table_name EXEC(@value_string)...

Hello, I am using some code to dynamically create a table. The columns of the table are determined at run time. The code is creating the proper TSQL statement and when I execute the statement independently it creates the table. However, in the code body after Executing the TSQL when I try to...

Hello, I am trying to make a calculation on two tables: Table # 1 --------- #words (Word varchar, A float, B float, C float,.. Z float) Table # 2 --------- #input_word #input_word table has a subset of the columns (A .. Z) Example: #words Word---A---B---C--...E.....S....T....... X Y...

Hello, I have a stored procedure: SP_SPLIT Input: Input_Word varchar(1000) Output: Select * from #temp_table which returns a temporary table with 2 columns: #temp_table-------------- ------------------------- Word-----------Varchar(80) Value----------Float I need to retrieve this...

Hello, I am using SQL 2000 to test the query. I have a Temporary Table: #Temp_Word_List And a second table: #t I am dynamically executing a select query on #Temp_Word_list The select query is implemented as an Insert into a Temporary Table #t and then I try to read the temporary table #t...