check out "distinct" keyword. Another option would be using the Group By clause.

It is of course possible. The mechanism to control this is user permissions. You can setup a new database user, setup whatever permissions you want and then use that user...

None of your insert statements will work. They all have the datatypes in the middle of them.

INSERT INTO [dbo].[tblResources]

([CompanyName])

VALUES

('Research Opinions', varchar(50))

Also, I am totally unclear on what you are trying...

There are plenty of people on here willing and able to help you. However, you need to help us help you. Table create statements, test data and desired output. Would...

Wow Celko, I am surprised that you of all people would suggest to use NULL like this. In your proposed...

It really boils down mostly to your preference. Neither of them is really better than the other. They compile to the same CLR readable bits. I have disliked the way...

That was the article I was thinking of but misplaced the link. thanks Wayne.

The simple piece I posted should work fine for that format too. Simple, clean, fast. 🙂

Lowell, how right you are. If the format is like the OP with no spaces we could replace ,N' with ,' and then get the right of that result like...

You could use the replace function to remove N' and replace it with '

What is the error?

There are tons of examples all over this site. Just type "cross tab" in the search box at the top and you will have more examples than you can dig...

My thinking was that you should be able to provide a password and the called package would just ignore it. This is the only way it made sense to me....

Great question. Keep them coming!!

Security is one of those things that can so easily get cut. In planning meetings the decision is made to reduce the budget for security because "we have not had...