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...
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 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...
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!
Hello all,
I have a column in a table with about 3000 rows. I need
to truncate the values in this column to remove the
first 3 values eg.
345753 = 753
Is there anyone who can help with this request.
Thanks in Advance.
...that return line.Here you go,
SET NOCOUNT ON
DECLARE @LogicalFileName sysname,
@MaxMinutes INT,
@NewSize INT
-- *** MAKE SURE TO CHANGE THE NEXT 4 LINES WITH YOUR CRITERIA. ***
USE [db_name_here] -- This is the name of the database...
Hello all.
Since the beginning of the my contract, this server has
continuously emitted the following error, on an intermittent basis, frequency monthly.
C:\..SYSTEM32\KERNEL32.dll failed. The process is terminating abnormally.
I have tried registry hacks to increase the size of the Desktop...
Hello all!
I am in the process of an application upgrade on one of our
many application Servers.
I would like suggestions on the types of file bakups i could
perform on the server for a quick recovery for the system critical files.
In NT4 i would only backup " \System32 ",
"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.