Programming SQL

Password field in user table
Any recommendations on implementing a password field in a table. I want to use it for log in by a an ASP application. I could just handle it all in the ASP code but I wondered if there are any good techniques used in SQL TIA Nigel Ainscoe ... 27 Jul 2008 20:43

TSQL - self joined table
Hi all, I am working with the SSRS catalog database to create a report and got stuck on this query. The subquery is bringing back more than one row - so it errors out. Basically I want to return report names (Type=2) with the associated Parent Path. Here's my faulty query so far... SE... 25 Jul 2008 21:44

How to get Identity column value for later use
I am doing three separate INSERT...SELECT FROM statements to write to three related tables. The first table has an IDENTITY column the value of which must go into the seond 2 tables. Each insert will insert multiple rows. How do I get the IDENTITY values from the first insert to use for the second two inser... 27 Jul 2008 06:22

UDF not returning data in Query Analyzer
I am trying to build a UDF to generate an employee ID and to make sure it is unique. Our employee ID's consist of first initial of first name + first initial of last name + 38 (our location) + Last 4 of SSN. An example is, dd381234. If the employee ID isn't unique, then we just add an underscore + a number ... 26 Jul 2008 20:11

Inserts to a Log table in a seperate transaction from my processlogic?
Log to a table variable and then you can insert into the real log (or build a call to the logging proc based on the data you stored in the table variable) after you have rolled back. On 7/25/08 12:37 PM, in article ey9E7Sn7IHA.3724(a)TK2MSFTNGP03.phx.gbl, "Thomas Malia" <tommalia(a)worldnet.att.net> wrote: H... 25 Jul 2008 13:31

Inserts to a Log table in a seperate transaction from my process logic?
Hey folks, I want to insert records into a process logging table to keep track of what's happening in a stored procedure. The problem I'm running into is, the inserts to my log table are contained within the same logical transaction as the process they are suppose to be logging so if the process gets rolled... 25 Jul 2008 13:31

Declaring variables to store error information
I found this code in Help file Declare @ErrorMessage As ErrMsg /* nvarchar(4000) */ Declare @ErrorProcedure As ErrProc /* nvarchar(126) */ Declare @ErrorNumber As ErrNum /* int */ Declare @ErrorState As ErrState /* int */ Declare @ErrorSeverity As ErrSev /* int */ Declare @ErrorLine As ErrLIne /* int */ Set ... 25 Jul 2008 15:34

Noise Word and Thesaurus UDF
Can anyone help me create a function that will accept a string of words, then remove any that are listed in a noise word table, add any that match in the thesaurus table, and returned to whatever called it? Cheers, Steve ... 28 Jul 2008 11:02

Combine multiple details rows into one column on master (sql 2000)
I find this at: http://www.sqlservercurry.com/2008/06/combine-multiple-rows-into-one-row.html ================================== -- Query to combine multiple rows into one DECLARE @str VARCHAR(100) SELECT @str = COALESCE(@str + '|', '') + [Numbers] FROM #Temp Print @str You can also achieve the same resu... 28 Jul 2008 06:55

Adding data to partitioned table
Hello all, I have a table partitioned in sql 2005 using partition function and partition scheme using different file groups. The table is partitioned using Tax year as partition column. Now, I want to add more data to the current table let's say for tax year 2006. How can I do It? Any help will be greatly a... 25 Jul 2008 12:29