Well the query that Chris posted returns the exact output you specified. If you need something different you have to explain it. We can't see your screen, we are not...

Take a look at the link in my signature about cross tabs. That article explains how to use pivot in addition to cross tabs.

You're welcome. Glad we can help. I actually thought about suggesting using the Import Wizard but Gus already posted it. Either one of them should help.

Something like this?

declare @ViewName varchar(255) = 'YourViewNameHere'

select name as UserName, permission_name, state_desc

from sys.database_permissions p

join sys.database_principals dp ON dp.principal_id = p.grantee_principal_id

where major_id = object_id(@ViewName)

briancampbellmcad (1/16/2013)

---

Yes using "opening a CSV file in Excel, copying the contents, then pasting directly into a table via "Edit top 200 rows" in SSMS"... which works well for about...

Yes as Steve suggested...

koln (1/15/2013)

---

Thanks guys...I like that merge function, and I will read up a bit more.

Overall, I only want this trigger to fire when a row is added or a row...

tonynasc (1/15/2013)

---

Hi.

I need some directions about UAC in SQl Server 2008. My questions:

1. Is it something inside SQL Server 2008 or is it related to UAC of Windows?

2. Is it...

As you said the data here is horrible to start with. Here is one way to deal with it. Use the DelimitedSplit8K function to first parse each string element apart...

koln (1/15/2013)

---

Thank you MM, that did the trick...but could you please expand what you meant with INSERTED virtual table function ?

Doesnt my trigger now only update future rows in Table...

AND it allows for...

Or even better create 3 stored procs to retrieve your data. You are using the "one query fits all via dynamic sql" approach. This is full of issues. It is...

Lowell I dropped the million to pull only 1,000 and it is painfully obvious that the MailAddress method blows the doors off the regex version for performance.

Here is the output.

(1000...

Sql Student-446896 (1/15/2013)

---

TableX

-------

Name Chg Amount PrevAmt

ABC 1 100 0

ABC...

Why don't you just combine all the scripts into a single file? Then you just add GO where needed and it can all run at once.