No, if there is 1 or more Billing, then do not return the Primary.

The current query as shown, returns them all.

There can be 0 to Many Addresses of Type BillingAddrType.

There must be and can be only 1 PrimaryAddr

If there is 1 or More Billing Addresses, it would return all of...

The basic requirements are that I need something that allows me to define column aliases as well as the ability to exclude which columns the users can see and choose...

Thank you for the quick replies.

Does it have to be in columns, No. I have something that works (parsing the datasets), but it would be less overhead / more efficient...

Like many others in the forums I am trying to find a secure method for a non sysadmin to execute a DTS Package.

xp_cmdshell appears to be out since I cannot...

Thanks - thought for sure I tried those variations - obviously not.

So much for long weekends of banging on TSQL - I need to stick to .Net...

Of course (slaps head)!

Sometimes the forest gets in the way...

Thanks for the quick reply.

FWIW - I think the journal style is fine and easy to read.

Clustering / high availability is something we too have considered. Unfortunately the cost of traditional clustering is prohibitive.

I...

That works - thanks a lot

Thanks - I did see that review.

The only one I have found and no talk about it in the groups. Google search comes up almost empty (except for company...

Thank you for your replies.

I had not considered using the SPID to track back to my loginname, that will resolve that issue.

For anyone else that may read this thread and...

Thank you for the replies.

The bitwise OR with the Inner Join returns only those rows with the included bits selected, so I have resolved that part of the issue.

Programatically, having...

Ok, I think I got it using an Inner Join and a bitwise OR '|'

SELECT * FROM persontypes Inner Join Persons on Persons.PersonTypeBits = (PersonTypes.PersonTypeBit | Persons.PersonTypeBits)

where PersonID =...

Thank you for the reply, but I think I'm missing something.

Let me provide a bit more information-

In the example, the PersonTypes table has four records

PersonTypeBit Desription

...

Andy,

Thanks for the reply - but performance aside, what about maintainability?

Assuming using GUIDs, it would seem that having SProcs that can handle varying amounts of parameters without being edited and...