Viewing 9 posts - 136 through 144 (of 144 total)
That gets me almost there I think. What if I wanted the results to return the actual date of the Monday of every week?
May 4, 2005 at 10:27 pm
We use identity fields all the time and have never had a problem with them. It is just a lot easier to let SQL take care of them. We have...
January 19, 2005 at 9:33 pm
The DocID field is an Identity field in the ac_dochead table and the system we are using places the DocID along with the blob into the ac_docdetail table once the...
January 13, 2005 at 9:28 am
Thanks Phil. That made a lot of sense and it helped. I think I may have simplified too much though. I'm actually dealing with three tables and now that I...
January 9, 2005 at 12:47 am
Right now the agent is set up to use SQL Server authentication. Should it be set up for NT authentication instead or do we just need to make sure the...
November 5, 2004 at 12:57 pm
You are correct, I want to create the second select using Inserted and I've attempted that as well without much success.
July 27, 2004 at 1:52 pm
Here you go. Both of these work. The minor changes were really just trying to figure out the company table because it is set up as a linked server. (That's...
February 4, 2004 at 7:35 am
Thanks everyone. Based on your input I was able to change the query so it was SQL compliant. A couple minor changes on the queries Frank and Gary wrote and I was...
February 3, 2004 at 10:17 pm
Viewing 9 posts - 136 through 144 (of 144 total)