You will have to write a select statemen to concatinate it. And if you have defauls on columns it won't tell you if they actuall populated the column with the...

Are you sure it is the trigger causing it and not so other piece. For instance if you have a unique constraint on the table and break that condition the...

I like the from ApexSQL even thou I don't use anything other than QA. But there are many options out there.

First and foremost for readability.

Second to constrain the joins so I cannot connect on unrealted items. Queries are interpreted innermost to outtermost joins, top to bottom.

So the join

dbo.RaceData rd

INNER...

The first is the old method and the second is the newer standard. Ultimately the engine will translte the first into the second. Also the second is more readable than...

From the standpoint of code itself this is how I would setup the query.

SELECT

 p.ParticipantID,

 pr.Age,

 ir.FnlTime,

 e.EventDate

FROM

 dbo.Participant p

INNER JOIN

 dbo.PartRace pr

 INNER JOIN

  dbo.IndResults ir...

My suggestion is this.

Create a Stored Procedure

CREATE PROC Get_Products_In_Catergory

 @CategoryID as int

AS

SET NOCOUNT ON

SELECT

 * -- You should list the columns you need as opposed to using *,

   -- makes...

This is what I came up with

/* Ex. Setup code */

-- SET NOCOUNT ON

-- 

-- Create table Ch_master (Ch_id tinyint, Ch_name char(2), Ch_placeid tinyint)

-- Create table Ch_detail (Ch_id tinyint, Ch_amount...

Are all fixed in format? Do you know the worksheet names?

You just setup two different publications, 1 for each and select the objects you want in each.

Again I am fairly sure there is a mechanism to recognize paterns in a batch of inserts, as stated I see the same low number as original when all the...

All you need if it is touch screen then is a virtual keyboard and all is well with the world.

Never looked but that is very interesting. I tried myself by creating a database R with a default size of 1 MB and grow by 10%. However you are right,...

But reporting services can output to excel.

Maybe what datatype is Date_A and what type is Date_B. If they are not the same type I suggest doing a cast. I would suggest doing like so personally

select *...