I think we have gotten past this error - we were using a port that was also being listened to by SQL server. Still having a problem with the certificate,...

Scott,

So after doing the restore, all log and diff backups that run after the database is brought back up can be added to the initial backups used for second the...

Thanks for all of the input,

To spell out the specific example:

Fri. evening after normal work is done, I do a diff backup so that with the last full backup, I...

I have used the following function for managing delimited strings in a list. It uses a Numbers table

to return the string as a table.

Do a search for Numbers table for...

Are you just wanting to grab the first unused barcode each time a new customer is generated or processed? Then use Jeff's/Lowell's statement with Min() on the insert/update.

SELECT MIN(Tally.N) as...

I am justing beginning to use SSIS and there may be a better way, but I have had to use a work around to edit packages saved in msdb.

I...

Thanks,

I thought that was the case.

So maybe there is an insert trigger on table1 that is changing the @@rowcount that is being returned. This would explain why the select...

Can the actions performed by a trigger affect the @@rowcount returned?

Itzik Ben-Gan has an article in sqlmag.com on this topic. He describes both a SQL Server 2000 a simpler 2005 solution.

You might see if you can adapt it to your...

Thanks Sergiy,

I think that NULLIF(EffectId, -1) is going to do the trick.

The business rule actually dictates that the original record added will have an EffectID of 0, but in most...

I have done something similar with a union. It would require a separate query to create the summary line and union it on the detail. In order to make it...

You're welcome.

I'm glad it worked for you.

Since it seems to be char or varchar, if field only stores numeric values, the following might give the results you want:

select * from testid order by rtrim(co_id) + 'ZZZZZ'...

Hello,

I have a table where I rely extensively on almost the same type of query. After reading this post, I just tested it again to be sure, but it does...

noeld,

When the where clause was uncommented was when the VB app began getting the: "Row cannot be located for updating. Some values may have been changed since it was last...