Looks good.  It's a good thing you didn't have 64 or 99 fields.

Glad to help. Good luck with the report import!

Thanks for the fix, Jeff.  A second pair of eyes always helps.

Hello swtrans, here's an approach for you.  This code assumes that the Identity values have been assigned sequentially (!).  It also assumes that the AcctNo entries are all actually fixed...

Hello Jacob,

For the FK field in the Response table:

- Leave "Validation Rules" blank. 

- Put "No" in for "Required".

For MS Access, the "Required" attribute specifies whether to ALLOW NULLS or not.

That should do it...

Hello Karen,

Here's another alternative that counts the number of preliminary zeros. This assumes no null values in the fields.  I hope you really don't have 64 or 99 fields!  Change...

Re: Any shortcut

This might be faster?

SELECT ta.ID as ta_id, ta_check, tb.ID AS tb_id, tb_check

FROM

  (SELECT ID, binary_checksum(*) AS ta_check FROM TableVersion1) AS ta

INNER JOIN

  (SELECT ID, binary_checksum(*) AS...

Hello Michael,

A general solution would use a stored procedure or a UDF.  I like the UDF because it can be invoked in other T-SQL like a view or a table.

if...

It's been a while since I did this, but I think it still works:

- Download a trial version of the full SQL Server product from Microsoft.

- Choose Custom Install, and...

I like Goce's solution.  Be aware that often a recursion or iteration will never end if someone puts a bad assembly in your database:

Product 1 uses Component 2, QTY =...

Hello Mark,

Re: Do you think there would be a large performance hit running this query on a table of about 1 million rows?

Probably not.  I ran the query with SHOWPLAN_ALL,...

Here's a sample, using the following 3 tables:

 ChangeRequests

 Titles

 MagGroups

SELECT cr.bill_to, cr.title_id, tt.title, tt.mag_group, mg.mag_group_id

FROM

(dbo.ChangeRequests AS cr

  LEFT JOIN dbo.Titles AS tt

  ON cr.title_id = tt.title_id)

LEFT JOIN dbo.MagGroups...

Re: Selecting records without using a cursor.

This query gives you the true maximum date for each name.  Working assumption: the MaximumDate field is formatted correctly for processing...

Hello Dhaval,

RE: "On close calibration form i have macro which refresh the record."

The correct method is ".Requery" (which gets all data from the DB), not ".Refresh" (which re-calculates but doesn't...

Is this what you mean?

1. Using a table like this:

---------------------------

  CREATE TABLE [dbo].[ab_sum_nulls] (

    [sum_iid] [int] IDENTITY (1, 1) NOT NULL ,

    [item_grp] [char] (10) ,

    [item_value] [int] NULL

 ...