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
Zones:
MS SQL ServerDate Answered: 06/21/2004 Rating: 8.2 Views: 4
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
Zones:
MS SQL ServerDate Answered: 06/22/2005 Rating: 9.4 Views: 0
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
Zones:
MS SQL ServerDate Answered: 03/14/2006 Rating: 9.4 Views: 0
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
Zones:
MS SQL ServerDate Answered: 04/16/1999 Rating: 7.6 Views: 0
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 Rating: 7.2 Views: 0
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
Zones:
MS SQL ServerDate Answered: 12/30/2003 Rating: 7.6 Views: 0
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 Rating: 8.6 Views: 0
I have the following path data
c:\windows\config\setup
c:\window\cache
c:\windows\internetlogs\aaaaa
c:\windows\internetlogs\aaaaa\bbbb
c:\windows\internetlogs\aaaaa\cccccc
c:\windows\in...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21769137.html
Zones:
DatabasesDate Answered: 03/13/2006 Rating: 9.0 Views: 0
