Use this split function to return the comma delimited list of id's as a single column table.

http://www.sqlservercentral.com/scripts/contributions/850.asp

Then you can use EXISTS or IN to determine if the id you...

You would think the DBA would know to do this before talking to you. =)

I think I understand, but can someone verify I am thinking correctly (I got the answer wrong but think I see my mistake now)

UPDATE m SET MyComments = i.MyComments +...

SELECT YearNumber,

MonthNumber,

SUM(Occurances) AS CountOfData

FROM

(select YEAR(DateField) AS YearNumber,

MONTH(DateField) AS MonthNumber,

Count(datacount) As Occurances

FROM

datatable

GROUP BY SQLDate)Dates

GROUP BY YearNumber,

MonthNumber

Order By YearNumber,

MonthNumber

This should give you what you are looking...

I really hate these kinds of trick questions, but it's my own fault for not reading more carefully. As another poster mentioned, there really is no learning to be done...

Whoops, missed that key left join peice. Heh, Guess it's time for new glasses.

If you run the code presented as is, you will insert only null values into the unresolved table. I assume you are also going to include some other information and...

I agree with MrSQL. Load the data into a staging table with BulkInsert then you can insert the data into the final table doing any kind of programatic manipulation you...

Why not use variables to hold teh values then do math on the results?

DECLARE @CountA int,

 @CountB int,

 @CountC int,

 @CountD int,

 @CountE int

SET @CountA = (select count(*) from A as Count_A)

SET @CountB =...

You can assign the user permissions to roles, just not individual object permissions. It would not make sense to only have access to this role for adding and removing users...

I may be wrong, but I beleive you have to have a backup device defined before running a backup through DMO. I have not worked with DMO however so I...

It could be, but then that person is not really a good fit for the company, in my opinion. In business it has to be "What is best for the...

I believe the message means it cannot find a backup device named "Northwind24022004".

Wow, I cannot believe that a so called development manager would argue the benefits of stored procedures. Sounds to me like they are just being lazy and don't want to...

Actually, I do understand the difference and took a wild guess as I thought both 2 and 3 were correct. You need BOTH the physical file name or location and...