Select C.Computername, Count(s1.softwarename) as [Microsoft Excel], Count(s2.softwarename) as [MicrosoftAccess], ...

FROM Computers C

LEFT JOIN Software S1 ON C.Computername = S1.Computername AND S1.softwarename = 'Microsoft Excel'

LEFT JOIN Software S2 ON C.Computername = S2.Computername AND...

There was recently an article on main page.

http://www.sqlservercentral.com/columnists/mmorin/2573.asp

What is datatype definition for column Trans_Detail.LedgerID ?

You compare it to @LedgerIDsL which is varchar(500). If column type is shorter than varchar(500) SQL Server will implicitly convert it to varchar(500) . That...

Sergei,

the split function Sql_2005_fan has posted here is not the best from split functions you can find on this forum.

I use the one which accepts ntext string (up to...

You probably need to read about sp_executesql in BOL.

It allows you to use parameters in dynamic string.

Again, if you have a business requirement to have the same application in 2 or more different locations - what would you do?

Do you call functions or methods from another applications?

Another server is absolutely isolated instance. You can request data from it but you cannot rely on its functionality.

It may isolated, may...

Did anybody appreciate the fact I kept silence about this topic?

Oh, no!

Again!

File system is quite enogh for rational expression solution. This solution does not take any advantage of relational model.

That's why I was asking...

Probably you have some data kept in relational DB datastructure.

Probably you process it using native T-SQL capabilities.

But it's definetely not all of the data.

At least example we discussed...

First day of the month:

SELECT DATEADD(dd, 1-DAY(@Date), @Date)

@Date must have time portion = '00:00:00.000'

If it's not use this:

SELECT DATEADD(dd, 1-DAY(@Date), DATEADD(dd, DATEDIFF(dd, 0, @Date), 0) )

  INSERT INTO tb_CARDs_MTLInformation 

     (IN_MatNum, IN_VerNumMat, IN_MatDesc, IN_SpecSta, IN_OldMatID, IN_MatTypeCode, IN_MatSubTypeCode)

 SELECT MatNum, VerNumMat, MatDesc, SpecSta, OldMatID, MatTypeCode,  MatSubTypeCode

   FROM DS07108TEST.CurwSpecLocal.dbo.tb_MatSpec S

   WHERE MatTypeCode IN (7,8,15)

   AND NOT EXISTS (select 1 from tb_CARDs_MTLInformation I where I.IN_MatNum = S.IN_MatNum)

UPDATE I

SET IN_VerNumMat = COALESCE (S1.IN_VerNumMat, S2.IN_VerNumMat, S3.IN_VerNumMat),

..... --...

IF (

SELECT COUNT(Q.QuestionTreeUID ) - COUNT(A.QuestionTreeUID)

FROM tbl_NSP_QuestionTree AS Q

RIGHT OUTER JOIN tbl_NSP_Answer AS A ON (Q.QuestionTreeUID = A.QuestionTreeUID)

WHERE (Q.ParentUID = 510095)

AND (A.InspectionUID LIKE '00076_0000001481')

) <> 0

mj,

noone is trying to be rude.

But thist problem is really created by you.

You are stuck with single solution you know and you are trying to use it where it's not...

Jeff, I would not suggest it.

I did it once and I end up in deadlock situation.

Command shell waits for transaction to be finished to start execute not rollable back command.

And...