Database

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
;

Dan_K wrote:

What is the required script to return the login mapped databases?

Dan_K wrote:

I'm able to do this in Management Studio by right-clicking on the login->Properties->User Mapping which shows the mapped databases as checked.

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

viaducting wrote:

As MS is apparently no longer recommending we use ADO

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

Please note that VB6 and .NET ADO interop are not supported anymore. This forum post does not imply any future support of these out-of-support technologies.

we drastically underestimated the number of customers who were recompiling ADO applications on Windows 7 SP1. Even worse, when I say drastically, I really mean DRASTICALLY."

viaducting wrote:

Please note that VB6 and .NET ADO interop are not supported anymore

viaducting wrote:

suggest to me that MS aren't expecting people to still be actively developing ADO-based projects.

viaducting wrote:

suggest to me that MS aren't expecting people to still be actively developing ADO-based projects.

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