Programming SQL

How to return comma delim
my select stmt will retun the following result set: State ------- CA NV UT AZ I want this to return as 1 field with the following comma separated list: State ------- CA, NV, UT, AZ How to? Thank you in advance, Chris ... 26 Jun 2008 02:18

Possible to perform filter/lookup on encrypted SSN field?
We have an application where a user may look up an employee based on name or last 4 digits of SSN. If we implement a requirement to encrypt the SSN column, can searches still be applied? One developer said that the entire column would have to be decrypted before performing the search. That having been stated, a... 26 Jun 2008 15:40

Resetting Identity within a temp table
Here is the situation. I have to create a temp table the could possibly hold multiple records from one or more different people. I need to create a "line number" for each record that the person has, however, when it's a new person I need to reset the line number at 1. I will know that it's a new person by th... 25 Jun 2008 15:01

Filling a table variable with the results of a stored procedure
Wintin a new stored procedure I would like to work with data returned from an existing stored procedrue which returns a table, but T-SQL retuns an error message: "EXECUTE cannot be used as a source when inserting into a table variable." Short of using the code contained within the original procedure How can I ... 26 Jun 2008 01:17

Loop through records to Update data?
I am trying to update a table, based on what was in the previous record. Let me try to explain better - the code is at the end. In my table, I have projects, activities, credit amount, debit amount, and starting balance. Each project can have several activities associated with it. Each project has a startin... 25 Jun 2008 16:03

Is it possible to check the syntax of parameterized queries without actually returning a result set ?
My parameterized queries are written in C# and have a number of sub-clauses in the where clause. dotNet just sees them as strings returned from a method. Is there a way to check the syntax of these parameterized queries without actually having SQL Server create a result set for them as well? ... 25 Jun 2008 16:03

How can I alter a default column value that does not have a constraint name ?
If I want to change the default value of a column I can do so by dropping the constraint and then creating a new one with the same name. e.g. ALTER TABLE Member DROP CONSTRAINT DF_Member_TrialDays GO ALTER TABLE Member ADD CONSTRAINT DF_Member_TrialDays DEFAULT(0) FOR TrialDays GO But how do I change th... 25 Jun 2008 15:01

Tool to chase down the consequences of adding a new field to my DB
First, I would script out all objects from your database server as seperate files into a folder. Next, I would use a good regular expression search tool like InfoRapid that can identify all scripts that contain a reference to the table containing the new column. InfoRapid will extract all lines containing your ... 26 Jun 2008 14:38

Question about getting the day of the week based on single int
How about: select datename(dw, d - 1) as d_of_week ,d from ( select 1 as d union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 ) w ML --- Matija Lah, SQL Server MVP http://milambda.blogspot.com/ ... 25 Jun 2008 12:57

Question about getting the day of the week based on singleinteger 1 - 7
Did you look at the DATENAME() function in Books Online? On 6/25/08 11:54 AM, in article f9de9a57-6c84-49e5-8985-5bdaee611061(a)m73g2000hsh.googlegroups.com, "jmDesktop" <needin4mation(a)gmail.com> wrote: Hi, I have a column, "day," that is an integer. It will hold a single value, 1-7. If it is a one it is... 25 Jun 2008 12:57