Viewing 15 posts - 41,866 through 41,880 (of 49,571 total)
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 9, 2009 at 12:39 pm
Please post the full error message, the exact version of SQL that you are on and what seems to cause the error.
January 9, 2009 at 12:38 pm
Steve Jones - Editor (1/9/2009)
January 9, 2009 at 12:36 pm
JPLeBlanc (1/9/2009)
January 9, 2009 at 9:00 am
crfenix (1/9/2009)
January 9, 2009 at 8:53 am
The inserted table will contain all the rows that were updated. There may be more than one, SQL doesn't have row triggers.
So, what you need is something like this
UPDATE tbl_Question1Answers...
January 9, 2009 at 8:41 am
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic633463-8-1.aspx
January 9, 2009 at 8:39 am
JPLeBlanc (1/9/2009)
January 9, 2009 at 8:26 am
There's no equivalent on SQL 2000.
On SQL 2000, check to make sure the log backups are running and check that there are no old open transactions or old unreplicated...
January 9, 2009 at 8:24 am
Mat Cottrell (1/9/2009)
Is there a way to get an idea on this?
How long is a piece of string?
It depends on the activity in your database, the frequency of your log...
January 9, 2009 at 8:22 am
Grant Fritchey (1/9/2009)
Oh heck yes. I've got no issues with heat. You sweat, what's the big deal?Cold hurts.
I'm actually the other way around. The heat just kills me. Day...
January 9, 2009 at 8:13 am
Please post table definitions, sample data, the query and show what you think you should be getting, and what you are. Read this to see the best way to post...
January 9, 2009 at 7:39 am
Grant Fritchey (1/9/2009)
There's about 3 inches of completely frozen snow in my yard and another 4-6 inches of the fluffy crap on the way tomorrow night.BLECH!
It's been 30+ degrees here...
January 9, 2009 at 7:31 am
jonas_granlund (1/9/2009)
January 9, 2009 at 7:27 am
jonas_granlund (1/9/2009)
Im not sure if you mean to store claims in a traditional (relational) way with each attribute for the claim in an own column?
Absolutely. SQL is a relational...
January 9, 2009 at 1:17 am
Viewing 15 posts - 41,866 through 41,880 (of 49,571 total)