Search results for query: *

I have the following function Below. I was attempting to use TempTables within in it, but apparently temptables aren't supported within functions. So, thinking I was really slick, I decided to replace the temptables with table variables. Only to find out that: EXECUTE cannot be used as a...

When using a treeview with checkboxes, how can I get the node of the box that was just checked? IE. if one node is selected and someone clicks the checkbox of a different node, TreeView.SelectedNode returns the originally selected node. And the Selection does not move from the selected node...

Hello, I am somewhat new to stored procedures. I'm trying to create SP that adds a column to a table, Accesses the column in a select statement, and then drops the column. It seems fairly straight forward to simply add the appropriate sql to the SP. However, when I Run the Create SP, it...

I'm new to C#, so pardon any assumptions I make... I have 2 datatables, in a dataset. both bound to their own datagrid. The idea would be that the user scrolling through datagrid one would see the records in datagrid2 get updated with the child records from Table1. Tables are as follows...

All, I am converting an application which used to run all client side to process mostly within SQL Server. My question: I have an Update that I run that Calculates the Mileage between 2 cities based on the Latitude and Longitudes of the 2 cities. The calculation is written, and my update...

I have an application which downloads data from one database, does some formatting, and moves it into my proprietary database format on SQL server or Oracle. In the past, I've always downloaded, dumped to Paradox .db tables, formatted, and batch moved into to the server from the Paradox .db...

I have an application that moves data into a temp table to work it over and then moves data from the temp table into the actual production data. Sometimes the data being imported already exists in the production table. Depending on the month, it could be just a few lines from the TEMP table...

MS SQL server includes an ISDATE() function which evaluates a string and returns a 0 or 1 indicating whether or not the string is a valid date. Is there an equivalent function in Oracle? I've looked around, and can't seem to find anything. TIA

Hello All, I have an application that has to cursor through fairly large amounts of data moving up and down to determine the state of specific record groupings. I've decided to use a Ramdrive to speed running up and down throught the queries...Which actually speeds things up quite a bit...

cmgaviao (Programmer) May 1, 2003 Ack, I didn't include enough info in my original post. here goes again with some modifications: Just a question in passing: I am writing a data extraction app for the travel industry. Given that a ticket from point A to point B might actually have several...

Just a question in passing: I am writing a data extraction app for the travel industry. Given that a ticket from point A to point B might actually have several segments involved, I'd like to pull the data for the First segment only. Heres a sample data set: Recordkey SegmentNum SvcCat...