Thank you.

Hi, Thanks for reply, let me explain it again:

From the table1 you can see there are two fields(Pass/Fail) for each Rule, each rule corresponds to a category which is shown...

Let me explain a little bit why there are 255 columns:

cn

instanceType

nTSecurityDescriptor

objectCategory

objectClass

objectSid

sAMAccountName

accountExpires

accountNameHistory

aCSPolicyName

adminCount

adminDescription

adminDisplayName

allowedAttributes

allowedAttributesEffective

allowedChildClasses

allowedChildClassesEffective

altSecurityIdentities

assistant

badPasswordTime

badPwdCount

bridgeheadServerListBL

c

canonicalName

catalogs

co

codePage

comment

company

controlAccessRights

countryCode

createTimeStamp

dBCSPwd

defaultClassStore

defaultLocalPolicyObject

department

description

desktopProfile

destinationIndicator

directReports

displayName

displayNamePrintable

distinguishedName

division

dNSHostName

dSASignature

dSCorePropagationData

dynamicLDAPServer

employeeID

extensionName

facsimileTelephoneNumber

flags

fromEntry

frsComputerReferenceBL

fRSMemberReferenceBL

fSMORoleOwner

garbageCollPeriod

generationQualifier

givenName

groupMembershipSAM

groupPriority

groupsToIgnore

homeDirectory

homeDrive

homePhone

homePostalAddress

info

initials

internationalISDNNumber

ipPhone

isCriticalSystemObject

isDeleted

isPrivilegeHolder

l

lastKnownParent

lastLogoff

lastLogon

legacyExchangeDN

lmPwdHistory

localeID

localPolicyFlags

location

lockoutTime

logonCount

logonHours

logonWorkstation

machineRole

mail

managedBy

managedObjects

manager

masteredBy

maxStorage

memberOf

mhsORAddress

middleName

mobile

modifyTimeStamp

mS-DS-ConsistencyChildCount

mS-DS-ConsistencyGuid

mS-DS-CreatorSID

mSMQDigests

mSMQDigestsMig

mSMQSignCertificates

mSMQSignCertificatesMig

msNPAllowDialin

msNPCallingStationID

msNPSavedCallingStationID

msRADIUSCallbackNumber

msRADIUSFramedIPAddress

msRADIUSFramedRoute

msRADIUSServiceType

msRASSavedCallbackNumber

msRASSavedFramedIPAddress

msRASSavedFramedRoute

name

netbootGUID

netbootInitialization

netbootMachineFilePath

netbootMirrorDataFile

netbootSCPBL

netbootSIFFile

networkAddress

nonSecurityMemberBL

ntPwdHistory

o

objectGUID

objectVersion

operatingSystem

operatingSystemHotfix

operatingSystemServicePack

operatingSystemVersion

operatorCount

otherFacsimileTelephoneNumber

otherHomePhone

otherIpPhone

otherLoginWorkstations

otherMailbox

otherMobile

otherPager

otherTelephone

otherWellKnownObjects

ou

pager

partialAttributeDeletionList

partialAttributeSet

personalTitle

physicalDeliveryOfficeName

physicalLocationObject

policyReplicationFlags

possibleInferiors

postalAddress

postalCode

postOfficeBox

preferredDeliveryMethod

preferredOU

primaryGroupID

primaryInternationalISDNNumber

primaryTelexNumber

profilePath

proxiedObjectName

proxyAddresses

pwdLastSet

queryPolicyBL

registeredAddress

replPropertyMetaData

replUpToDateVector

repsFrom

repsTo

revision

rid

rIDSetReferences

sAMAccountType

scriptPath

sDRightsEffective

securityIdentifier

seeAlso

serverReferenceBL

servicePrincipalName

showInAddressBook

showInAdvancedViewOnly

sIDHistory

siteGUID

siteObjectBL

sn

st

street

streetAddress

subRefs

subSchemaSubEntry

supplementalCredentials

systemFlags

telephoneNumber

teletexTerminalIdentifier

telexNumber

terminalServer

textEncodedORAddress

thumbnailLogo

thumbnailPhoto

title

tokenGroups

tokenGroupsGlobalAndUniversal

tokenGroupsNoGCAcceptable

unicodePwd

url

userAccountControl

userCert

userCertificate

userParameters

userPassword

userPrincipalName

userSharedFolder

userSharedFolderOther

userSMIMECertificate

userWorkstations

uSNChanged

uSNCreated

uSNDSALastObjRemoved

USNIntersite

uSNLastObjRem

uSNSource

volumeCount

wbemPath

wellKnownObjects

whenChanged

whenCreated

wWWHomePage

x121Address

There is a need to replicate ad to sql, in our ad server, currently there are 255 properties, that's why...

Too bad, your method is not working.

I opened a case in Microsoft but this is ridiculous, MS can't fix the problem. What they are thinking is the file is corrupted, but I burned not only database...

All the databases are doing this. I stopped SQL before I burned the DVD.

Before I sent the disk to be re-imaged, I stopped the database and then I burned all the database files to a DVD. Then after I got my machine back,...

Hi Sergiy,

I know you mean to help, but your tone is not nice.

Your first post is:

SELECT ID -- integer identity field

FROM dbo.IP_Adresses

WHERE IP_Address = @IP_Address

Honorsly I have no idea about...

Hey guys, thanks for responding.

what about from a number to a real IP?

And what about Mac?

Thank you guys for responding.

I am having more and more trouble:

To do an experiment, I created a temp table, and tried to inner join that table. Unfortunately that sp is...

It works now, here is the change:

select @sql = 'SELECT distinct [' + @criteria + ']' + ', NextLevel = case ' + char(39) + @criteria + char(39) + @sql3...

If I run the exec like:

insert #t

exec (@sql)

It gave me:

Server: Msg 137, Level 15, State 2, Line 1

Must declare the variable '@criteria'.

Stored Procedure: SSER.dbo.spListDataStatisticByCriteria

Return Code = 0

The @sql is...

Hi Jez,

I followed your suggestion, it gave me error:

Server: Msg 214, Level 16, State 2, Procedure sp_executesql, Line 54

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

To others: the generated sql query(the...

Thank you Adrian, your query helps.

select EmployeeID, [count]=case when count(1)>0 then count(1) else 0 end from orders

where CustomerID = 'VINET'

group by customerid, EmployeeID

This returns:

EmployeeID  count      

----------- -----------

2           2

3           1

5           1

6           1

(4 row(s) affected)

What the...