Enter Keywords:
1 - 10 of 59(0.012 seconds)
Sort By:
 
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...
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...
Zones: Oracle Product InfoDate Answered: 01/18/2005 Rating: 7.8 Views: 4
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/...
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...
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...
Zones: Databases, SQL Syntax, MS SQL ...Date Answered: 09/03/2007 Rating: 7.8 Views: 34
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...
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...
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...
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...
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...
Zones: DatabasesDate Answered: 03/13/2006 Rating: 9.0 Views: 0