look in the script contributions for the split() function.

it takes a delimited list and turns it into a table, so your statement woudl simply change to this:

"user_accounts INNER...

here's the answer to both questions: change a login name:

--Usage: EXEC pr_RenameLogin 'webdev', 'WebDeveloper'

--modified from from http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=408&lngWId=5

---Code should be put in master database ---

CREATE PROCEDURE...

i think this is nothing more than adding a HAVING statement to the query you posted:you might need to select max(score), testcount as a separate subquery instead because of all...

is a design change so that the fields are stored as encrypted data instead of plain text/numbers out of the question?

I recently had to do that, redid the table so...

got to any forum. Upper right corner has a link to click "Forum Options"

first popup link says "Subscribe to Forum"

next page allows you to change to get instant email notifications....

typically, to insert multiple rows, you use a select statement to insert the data.

a simple example might be:

INSERT INTO SOMETABLE(ID,NOTES)

SELECT

CustomerId,

'This is a default note that...

sometimes it's easier to change something that exists, than to create something from scratch.

I would suggest just creating a default maintenance plan using Enterprise Manager to make a backup plan and...

Vladan's right, you MUST be able to identify what makes a row "unique"; it may be a combination of 5 fields, or it may be every field. that is the...

it sounds like you are entering some master...detail information into a pair of tables;

As Vladan identified, you should be doing this as a couple of set based operations, instead of...

the more details you can provide, the better the answer.

here's an example, but I'm not sure how helpful this will be:

Create Procedure PR_Sample(@somedata varchar(30),@moredata varchar(30) )

As

Begin

SET XACT_ABORT ON

BEGIN TRAN  ...

you use a technique using the TOP statement twice:

declare @payroll TABLE (

salary money,

firstname varchar(30) )

INSERT INTO @payroll(salary,firstname)

SELECT 400.01,'Bob' UNION

SELECT 800.02,'Bill' UNION

SELECT 1200.03,'Todd' UNION

SELECT 100.01,'Nick'

SELECT TOP 1 X.salary,X.firstname  FROM (

SELECT TOP...

something like this?

SELECT DISTINCT categories FROM sometable ORDER BY categories

will give you the list you described;

sorry, i cant seem to see how you know which column is which;there's no obvious pattern in the sample you rpovided.

If you could determine that column 3 was always an...

it's easier than you thought.

several ways.

add a constraint to the table where UserID <> @InvitedUserid.

Use the If example below.

this is one of those situations where the client side would have more functionality than server side.

once placed in an ADODB recordset, the recordset has the datatype and defined size...