I think it depends on how strongly your distribution requirements match those of the Exchange email groups.

If the groups are set up entirely at your request, then by all...

Scott has a point.  For small sets of data the cross-joins are acceptable.  For large sets, go to plan B!

1. It would be an easier problem if the emp_error_log had only one record per employee,

with a separate error field for each data column.  So, here's how to create such...

I agree with Vladan's approach.  For a more complex case, however, the ListingID's won't be in

continuous sequence.  For this technique to work, however, they at least have to unique in...

Here's a way to get the Fiscal Week, using the DatePart function.

However, the devil is in the details as they say, so I've included

some specification clarification....

1. Specification by example:

  Date: ...

I agree it is a messy search for an IP string. Consider a string like this:

  DECLARE @string varchar(255)

  SET @string = 'Title: Lawn Mower.  Cost: $125.67.  IP Address: 123.12.1.16'

There's...

Hello,

Yes of course MIN returns minimum,and FIRST returns first occurrence. However, faced with a "workaround" conversion requirement, I can't think of anything better than MIN() or MAX().

If the Access FIRST()...

I've found that MIN() does just about the same job as FIRST().

MS Access:

  SELECT customer_id,FIRST(order_date)

  FROM customer_table GROUP BY customer_id

SQL SERVER:

  SELECT customer_id, MIN(order_date)

  FROM customer_table GROUP BY customer_id

Re: "keeps on running forever".

Is it executing code, or is it "stuck"?  I recall that looking at the spid would tell me if the process was using CPU cycles or not. ...

Hello,

1. Regarding your current code, I don*t see the the closure for the loop: Do While Not objADORS.EOF

2. However, I'd approach it a bit differently -- here's how I...

Yes: Notepad (or in my case, Textpad) are the way to go.  You can think and type at your own rate.

I think you need the max(trip_id) for each boat_id and boat_type combination:

 SELECT S.record_count,  

         T.trip_id,

         S.compart_no,  

         T.boat_id,  

         T.boat_type,  

         S.recordor_id,  

         S.record_type,  

         S.record_loc_type FROM DRY_records S,...

Maybe create a view on the target table that does not include the Identity column -- and insert into the view?

Hello,

It looks like you are actually combining records based on the row number in each sub-table. To do that, SQL needs to have the Row# explicitly defined somewhere. The query...

Books on-line indicates that you can use QUOTES or brackets, and that the hyphen is allowed in a quoted identifier:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_03_89rn.asp

You might want to set Quoted Identifier on, and then...