Not sure you need the not null... cause if there's no price then there's no row so the join won't update the line at all.

Yes, you should always specify the column names for the insert before inserting the valu.

ex :

Insert into dbo.DummyTable (col1, col2, name) Select col1, col2, name from dbo.Table2.

That way sqlserver...

My mistake.. I was referring to this script :

CREATE TABLE [dbo].[TypesCommentairesADPS] (

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

[DescTypeCommentaireADP] [varchar] (50) COLLATE French_CI_AS NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TypesCommentairesADPS]...

I already posted something that disproves that in this very thread... I think this is a lost cause. Let him not use the order by and get bitten later...

HTH.

On a last note, and outer join (left, right or cross) with a where condition like : where SomeCol = @SomeValue basically becomes an inner join if the search criteria...

Select C.CategoryID, C.name, count(*) as Total from dbo.Category C LEFT OUTER JOIN dbo.Comments CM on C.CategoryID = CM.CategoryID and CM.UserId = @UserId

GROUP BY C.CategoryID, C.name

ORDER BY C.name

Are the columns chars() or varchars()? If you use varchar instead of char then the trailing spaces will be removed automatically (or actually not added at all).

You should always use owner.objectname. You only need to add the database name for cross database/cross server queries.

BTW this assumes that Pattern and Color cannot contain nulls

INSERT INTO tblCatalog ( Product_ID, img )

SELECT Product_Id, Pattern + '-' + Color + '.jpg' as img

FROM dbo.Product_Dimension

Do you mean something like this?

Select C.CategoryID, C.name, count(*) as Total from dbo.Category C LEFT OUTER JOIN dbo.Comments CM on C.CategoryID = CM.CategoryID

GROUP BY C.CategoryID, C.name

ORDER BY C.name

I can't help you any further than this... maybe some dts guru will be more fit to solve your problem than me.

Wow, that's a nice quote.

you don't need to specify the dbname unless you are connection do northwind and want to get data from pubs.

It's considered a best pratice to ALWAYS specify the owner of...