Hi

What i would suggest you keep your jobs per database and keep them at different times so they dont overlap. Set up the jobs to run at a time u...

Hi

This query "select sCode_value from Codes where

gCode_Id = '853C63ED-D7CC-4E86-965E-F425A53E1BA2' " which you have mentioned will work.

As Carl said if no rows are being returned check whether the uniqueidentifier value...

Hi

Is this what you want...

SELECT COUNT(*) FROM (SELECT DISTINCT column1, column2, column3 FROM table1 where column2 = 'a') AS A,

Hi

Adding on to what others have said..

Try and keep your 2000 & 2005 database files on separate disks if possibe. This will give you better read/write performance specially write performance.

hi

You will have to check for newly created logins. Check for the create login event also.

Pls explain the question clearly

Hi

Image data type cant be used in a Group BY clause.

Why do you need to group by a image column, cant you use any other column?

No response 😉

Pivot is supported in Express edition.

Jeff that was a nice catch :w00t:

Use the PIVOT operator for this (not in SSIS) .

Nicely summarised by David.

Hi

Are you getting the Foreign key violation error. Foreign keys are mean to to enfore relationships between tables. A foreign key column(s) in one table points to PrimaryKey or Unique...

i agree with Karl about having a separate database for the developers to run their queries. But have to think twice about nolocks...

Hi

CTE's are maily used for recursive programming although they can be used instead of sub-queries. While its true that they have performance implications they do have some advantages. The thing...