Programming SQL

CharIndex and Replace
I've got a varchar value that represents several values seperated by a dash. Some of the values contain dashes as well which is making it more challenging. An example would be 123,456-333,123-999,877 This is fine but sometimes I get 123,456-333,123-999,877-Could not find location-456,667 This I've manag... 28 Jul 2008 23:22

Query Help
Using SQL 2000 Here is the DDL and some sample data USE TempDb Go --Inks table consists of inks that can be made by combining cyan, magenta, yellow and black --e.g. Yellow and Magenta mixed together gives Red CREATE TABLE [dbo].[Inks]( [InkID] [int] NOT NULL, [InkName] [varchar](50) COLLATE SQL_Lat... 30 Jul 2008 17:55

ACREDITE FUNCIONA!!!!!
Ganhar dinheiro r�pido e honesto meu blog http://jet72.zip.net/ : QUER GANHAR UM BOM DINHEIRO? FA�A COMO N�S ! : COMO TRANSFORMAR 12 REAIS EM NO MINIMO DOZE MIL REAIS !! : EU TAMBEM N�O ACREDITAVA!! VOC� � CAPAZ, APENAS FA�A FUNCIONAR.! Encontrei esta mensagem em um f�rum no UOL e decidi tentar. Pouco cu... 27 Jul 2008 15:35

How to set the xp_cmdshell so that it will not overwrite the e
You could create an SSIS package that will append to the file, setup a job and still call it from inside your query. USE msdb ; GO EXEC dbo.sp_start_job N'Your_job_that_calls_the_package' ; GO You could also use CLR, but that is much more complicated since you would have to allow unsafe assemblies in th... 27 Jul 2008 15:35

How to refer to a databasename dynamically
Currently every one of our databases has its own audit database. We simply take the database name and append 'Audit'. I am writing some stored procedures that will perform DDL on the audit databases / tables. I want to write a single routine that can work with all databases and their audit databases. For example: ... 29 Jul 2008 18:52

password protected instance
i want to know how can i password protect my sql server 2005 express instance so thatnobody can go and play with database or even view it? ... 27 Jul 2008 11:28

OPENQUERY with stored procedures error
I am currently using SQL Server 2005 Express Edition and SSMSE. I have developed a unit testing suite for my stored procedures. The way it works is, all of my tests (stored procedures on the database that call the actual stored procedures to determine if they return the correct output) are executed and their ... 27 Jul 2008 18:41

How to set the xp_cmdshell so that it will not overwrite theexisting file if there is one?
This will not prevent an overwrite. But it does at least make a unique file name if you ensure that the query can't be called more than once a minute (and once a year passed by, all bets are off, if you keep files that long). Are you really wanting to create a new output text file more often than once a minute? I... 26 Jul 2008 23:15

How to set the xp_cmdshell so that it will not overwrite the existing file if there is one?
I have the following store procedure to execute a xp_cmdshell statement to export an view to a text file. Everything is working fine except I do not want it to overwrite the existing file. Currently the export file name is static. The file name is restricted to max 8 characters as it will export to a DOS progra... 26 Jul 2008 23:15

parse fields for value
I need to read my table and pull back values based upon criteria within the fields parsed. CREATE TABLE territories ( customer NVARCHAR(10), slspsn1 varchar(5), slspsn2 varchar(5), slspsn3 varchar(5), slspsn4 varchar(5)) INSERT INTO territories VALUES( 'jim',21000,,,); INSERT INTO territories VAL... 27 Jul 2008 17:39