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...

the above also would not take into consideration if there were 3 or more rows that should condense to a single time slot you'd need to handle it differently, most...

you gotta try what i posted: you end up with a 15 character string with the preceeding zeros you requested.

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,1),15)

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,86456),15)

SELECT RIGHT('000000000000000'...

you want to change all the objects back to smdb;

--find everything NOT owned by dbo, and create the sqls to change them to dbo as owner:

select 'EXEC sp_changeobjectowner...

it really depends on what your UDF is doing;

we need that code to determine whether this can be done cleaner; the more real details you post, the better we...