Search results for query: *

Hi, I was looking for some help for Dynamic SQL in Oracle 9i. My requirement is, I have a table, where a user's preferences are set. This table contains column_name, column_type & column_value. Now this information is organised in rows. I want to output this information using a REF...

Hi, I needto update the data in ntext columns. I need to search for specific set of characters in the ntext data and replace that with another set of characters. Anybody has a solution for this ? -Mukund

Hi, Anybody has any experience/idea of migration from Informix database to MS SQL Server database. From point of view of tables (design), Views (syntax) & stored procedures. Any pointer/comments/suggestions are welcome. Regards, Mukund.

Hi, I want to create a text file, from the contents of a ntext field. Can this be done ? Any help/suggestions is welcome. Mukund.

Hi, Anybody has any idea of the best way to pull data from Oracle to SQL Server ? This needs to be done on a daily basis and has to be a automated task. Also I wanted to know if there are any utilities for the same. Any help & suggestions are welcome. Regards, Mukund.

Hi Has anybody worked on Data Warehousing solutions ? If yes, can you tell as to how to go about it ? I have worked on SQL Server 7, for pat one year an thinking of exploring Data Warehousing. Regards, Mukund.

Hi, Does anybody know how to convert a timestamp column value to a valid datetime value. Any suggestions/help is welcome Regards, Mukund.

Hi, I have a PO Table that has some integer values. HubId is an officelocationid, different id is assigned to different offices e.g. 1 for US 2 for UK The procedure below is written, to return the missing range of PO Numbers the sample output is as follows FromNo ToNo -------...

Hi, When I am generating a script for table schemas and using that script to transfer tables from one database to another, the default values set for the columns in these tables are not tranferred to the target database. Anybody has a solution for this. I had checked the Table...

Hi, Has anybody written a script that can help me document my table's structure. Say in the following format TableName : RadioStation FieldName PK/FK DataType ----------------------------------------------------- RadioStationId PK int CountryId FK (Country)...

Hi, Has anybody has written a SP/script that will compare two databases and display the differences between the two databases ? This will come handy whenever changes from one database are to be effected on the other database. Regards, Mukund.

Hi, I want some help using CASE in the select statement. select ISgroup = CASE p.GroupId WHEN NULL THEN "NO" ELSE "YES" END from POHead p In this SQL statement I don't get the desired results. The SQL does not work for NULL values in the GroupId field. Anybody has a...

Hi, I have a set of records in one table for e.g. Singapore Singapore\Admin Singapore\Admin\Bank Singapore\Admin\Contacts Singapore\Admin\Finance Singapore\Admin\Finance\Payroll Singapore\Admin\HR Singapore\Admin\HR\TimeSheets Singapore\Admin\Insurance Singapore\Admin\IT...

Hi, Can I retrieve the datetime when my database design was last modified ? Thanks & Regards, Mukund.

Hi, When all the pages opened by a client browser are closed, the session variable needs to be destroyed. Any Suggestions/Help is Welcome, Thanks, Mukund.

How does one trap the Return value of a stored procedure. I want to call one stored procedure, that return a Integer value by using the Return Statement. I want to use this Return value in the calling Stored Procedure. Mukund.

Help required for a stored proc. Refer the stored proc given below. The id_val table has columns name nvarchar(25) val1 int val2 int val3 int val4 int These columns can increase till val9, which will be handled programatically through a VB component. The problem in...