I didn't Google much on the subject, assuming that you probably did but I did rifle through BOL and came up empty (or...

Charles, could you share more about good design with CE?

I will have to rewrite a stand-alone, data entry heavy, laptop app for very occasionally connected users. This sounds like...

Yes, I wondered. Wondered, too, why almost half the respondents chose a different answer...

I wondered the same thing and came up with the following:

DECLARE @Output table( ID int, Code VARCHAR(25), Name VARCHAR(50), Salary Numeric(10 , 2))

INSERT INTO TempTable ( Code , Name, Salary)

OUTPUT...

I've been googling for some backup info, and came across this statement on Devx: Choosing the Right Backup in SQL Server

In the backup file, SQL Server stores the...

Try this:

select P.ParentID, Title, NumChildren

from ParentTable P left join

(select ParentID, NumChildren = count(*) from ChildTable group by ParentID) as C

on P.batch_id = C.batch_id

The above gives NULL...

Melvin, that's an excellent idea that will be very helpful to me. One question, though. Why not assign all permissions through one cursor, like so?

DECLARE cursAllExecutables...