Hi
Can anyone help with this section of code.
I testing some new software that speeds up the fulltext search in sql.
problem is my original code will not work properly with it and I'm unsure ho...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21030465.html
Can anybody translate the following t-SQL code into PL/SQL code:
--CREATE PROCEDURE crosstab
DECLARE @select varchar(8000), @sumfunc varchar(100), @sumval varchar(100), @pivot varchar(100), @t...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_21227035.html
Database name: HCCAContact
Table name: People
Field name: Internal1, nvarchar, 75
The contents of this field consist of a network ID and a subnet mask separated by a / such as:
10.105.0.0/...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21467154.html
I have record that is like this:
Domain: SomeDomain.com
I want to return:
SomeDomain.com
I have tried:
SELECT RIGHT(username,CHARINDEX(' ',username,1) - LEN(username)) from TABLE1 where us...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21773765.html
Hi,
Only yesterday i asked for some help in a query to enable me to get part of a string out of a field.
I recieved many answers back and this worked the best, however i am relatively new to thi...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22797115.html
I currently have a stored procedure that I want to pass a string of characters that may exceed SQL 6.5's limitation of 255 characters for the VARCHAR and CHAR datatypes.
I have experimented with t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10150844.html
I have a DW that pulls out some segments of data on the pull.
3 lines cause me an Invalid Datawindow Row/Column error when I run the application.
SELECT <Various Column names>,
charinde...
http://www.experts-exchange.com/Programming/Editors_IDEs/PowerBuilder/Q_20300548.html
Zones:
PowerBuilderDate Answered: 08/22/2004 Grade: A Views: 4
Hi
The following code below worked OK when only entering 2 words, unfortunatley when I increased it to 6 words it no longer works properly.
Can anyone find the reason why.
*********** Code...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20835985.html
Hi
I have just received word from Macromedia about the problems I has having with ranking.
The problem is due to the code in section 1 below and so I need to remove it from the sp.
But at th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20862785.html
How can i use the sql to the following in order
1. trim out the last 3 charactor
2. then get the last character and converted into upper letter and place to variable A
3. trim the last 4 charact...
http://www.experts-exchange.com/Database/Sybase/Q_21531446.html
Zones:
SybaseDate Answered: 08/18/2005 Grade: A Views: 44
