Recent content by JUDGE27

Thankyou, For your feedback. I will exhaust all avenues, however if not satisfied i'll be back with avengeance.

Hello all, Is there a way to use the right mouse button to select an object from within a java program and select the required properties i have created. At the moment i am able to left click the object i have created which highlights the object, then i need to right click to select the...

Fantastic, You hit the nail on the head. Thanks for your contribution to this thread. Thankyou,

Hello, Can someone please explain the benifits of Sql Servers, Meta Data Repository. How would this benfit a data warehouse. Thanks in Advance

Thanks for your response. Ive managed to purchase a great read "Professional SQL Server 2000 DTS (Data Transformation Service)" which has most of the unanswered questions I require. Kishleo, can you elaborate on your ODS interms of design. Is it a mirror of your Data Warehouse or a...

Hello, Id like to know the simplest way to create a Database Schema from within SQL Server, or techniques to adopt. Thanks in Advance.

Hello, Id like to knows of any loading techniques or has recources on the topic of populating tables from operational data sources. Thanks in Advance.

Thankyou very much JGIRL. Your post has definately filled the void in my knowledge, of OLAP cubes.

Hello all, Ive been unsuccessful in finding any informative info on OLAP cubes. Can anyone please direct me to recources they found usefull defining what the function of an CUBE is. Thanks in Advance

Hello all, Ive been to BOL and looked at this area in depth and cannot make any sense of it. Can anyone outhere please explain the advantages and or purposes of full-text catalogs as opposed to not having them installed. Thanks in Advance,

Hello all, Has anyone been able to view reports from CE8 eportfolio which access both a lotus notes nsf database and cobol isam vision files. If so please reply to this thread as to how you have been able to retrieve data in a report format. It seems i can only view reports that access an SQL...

Surely, there must have other sites out there that have encountered this issue? I Demand Answers!

Hello all, Are there any special considerations in Crystal Enterprise CE) when reporting against Cobol isam vision files and Lotus Notes databases? Please reply with any personal experience in this area or soloutions to this query. Thanks in Advance.

I have managed to modify the code supplied by MeanGrean, and have it in a manageable state. The following is the modified code. select substring(cast([COLUMN HERE] as varchar(255)),4,10) as [NEW_COLUMN_NAME_HERE] from [DATABASE HERE] Thanks for you help guys!

The Datatype is integer. MeanGreen, the following statement returned: Server: Msg 1035, Level 15, State 10, Line 1 Incorrect syntax near 'cast', expected 'AS'. I am unfamiliar with the Casting function. Can you please take a look at this. Thanks in Advance!