you cannot put a recordset into a parameter.

try sp_execute_Sql

select @SQLStatement = 'select @Myvar = low FROM [' + @servername + '].master.dbo.spt_values WHERE number = 1 and type = ''E'''

exec sp_executeSql...

Without your table schema, relationships, data, and desired result it is extremely difficult to help you.

Please post what your tables, relationships, and sample data.

http://www.aspfaq.com/etiquette.asp?id=5006

Count(distinct email) only counts the distinct emails from your resultset.

if you do

select distinct region, c2.classID, count(*)

From MyTable

Group by region, c2.classID

But I'm not exactly sure, post some data if you...

Built myself a

P4 2.8c ghz hyperthread

MSI 865PE NEO PLS Motherboad w/ dual channel memory.

1.5 Gig Ram

80 g seagate barracuda IDE HD

Lite on CD-RW

EVGA NVIDIA Fx5600

LeadTek TV2000XP Video Capture...

Use DTS, BCP, or Query analyzer.

For QA you first have to set your results to be comma delimited.

Tools --> Options --> Results tab --> Results output format pick comma delimited. ...

Correct, your replication will fail if the data is not right when that row is updated from the publication.

The only type of replication you can use if you want to...

I suggest you pick up a book, or read books online about dts.

Also http://www.sqldts.com/ is a great place to pick up information about dts.

Does your destination table have a column,...

doesn't matter

what are you trying to do?

what is the value of the @ReverseFields?

Replace the exec with a PRINT and what is output in the messages window?

You need to see...

The error means exactly what it says.

Your inserting data into a column in a table that the data type is a numeric, but the data your inserting is in a...

I'm pretty sure you'll need dynamic sql to pass the servername as a parameter, and also pretty sure you cannot declare a cursor in dynamic sql, so I don't believe...

Example

declare @String varchar(100)

set @String = 'M Carlos'

select Stuff(@String, Patindex('[A-Z] %', @String ) +1, 1, 'h ')

Result

'Mh Carlos'

OOPS EDITED:

update mytable

set myColumn = Stuff(@String, Patindex('[A-Z] %', myColumn) +1, 1, 'h ')

where Patindex('[A-Z]...

You can run a profile trace analyzing locks, Pick the events you want to monitor and wait for it to happen again.

Its likely in the @ReversFields parameter.

Try to do a Print 'SELECT ' + @ReverseFields + ' = COUNT(ItemID) FROM biditems where EventID in (' + @EventID + ')'

and see what...

when you are creating your package on your pump task it asks you for a table/view or a query. In the query window type in your stored procedure name.

Dts will...

You'll have to do it in a couple of updates though. And you may have to create an additional update if there are single characters at the beginning of the...