Viewing 15 posts - 1 through 15 (of 26 total)
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,...
April 4, 2014 at 11:27 am
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...
November 18, 2013 at 4:24 pm
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...
November 18, 2013 at 3:58 pm
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...
November 2, 2007 at 2:46 pm
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...
September 29, 2007 at 9:44 am
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...
September 21, 2007 at 10:55 am
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...
April 11, 2007 at 1:35 pm
Can the actions performed by a trigger affect the @@rowcount returned?
April 11, 2007 at 11:39 am
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...
October 5, 2006 at 5:20 am
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...
June 29, 2006 at 3:47 pm
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...
November 2, 2005 at 4:22 pm
You're welcome.
I'm glad it worked for you.
October 31, 2005 at 5:49 am
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'...
October 30, 2005 at 9:31 pm
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...
May 6, 2005 at 3:32 pm
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...
March 17, 2005 at 12:02 pm
Viewing 15 posts - 1 through 15 (of 26 total)