Database

rskuchimanchi wrote:

it may not be properly installed.

rskuchimanchi wrote:

VERY VERY URGENT..

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

digvijay dobhal wrote:

BillingTerminationDate = NULL

digvijay dobhal wrote:

If BillingTerminationDate is null then ... BillingTerminationDate >= @MyeffectiveDate

digvijay dobhal wrote:

AND
CASE WHEN BillingTerminationDate = NULL THEN
(terminationDate is null or BillingTerminationDate >= @MyeffectiveDate)
ELSE BillingTerminationDate >= @MyeffectiveDate)

WHERE
(
    (
        EffectiveDate <= @MyeffectiveDate
    And
        (
            (BillingTerminationDate Is Null And TerminationDate Is Null)
        Or
            BillingTerminationDate >= @MyeffectiveDate
        )
    )
Or
    IsAdjustment = 1
)

select * from Mytable where ((EffectiveDate <= @MyeffectiveDate and BillingTerminationDate is not null  
			and (BillingTerminationDate > =@MyeffectiveDate)) OR IsAdjustment=1)
			
			
select * from Mytable where ((EffectiveDate <= @MyeffectiveDate and BillingTerminationDate is null  
			and (TerminationDate > =@MyeffectiveDate)) OR IsAdjustment=1)

WHERE
(
   (
      EffectiveDate <= @MyEffectiveDate
   And
      (
         (BillingTerminationDate Is Not Null And BillingTerminationDate >= @MyEffectiveDate)
      Or
         (BillingTerminationDate Is Null And TerminationDate >= @MyEffectiveDate)
      )
   )
Or
   IsAdjustment = 1
)

Select  *
FROM    Mytable
WHERE   (
    BillingTerminationDate is null
    AND
    terminationDate is null)
OR      BillingTerminationDate > =@ MyeffectiveDate

digvijay dobhal wrote:

Dear seniors,

SELECT TOP 1 MachineName
  FROM MyTable
 WHERE ProjectName = 'Web 8.0'
 ORDER BY [DateTime] DESC

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

Member 8407653 wrote:

I want all machines that now

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

WITH cteOrderdAssignments As
(
   SELECT
      MachineName,
      ProjectName,
      ROW_NUMBER() OVER ( PARTITION BY MachineName ORDER BY [DateTime] DESC ) As RowNumber
   FROM
      MyTable
)
SELECT
   MachineName
FROM
   cteOrderedAssignments
WHERE
   RowNumber = 1
And
   ProjectName = 'Web 8.0'
ORDER BY
   MachineName
;