Did you check the link Jon posted?

If you did, then please post what you have right now and...

krypto69 (3/15/2016)

---

Hi,

I have a query below that I think is close to what I need, but I need to add a column(s) that has the

Number of APPROVED claims

Number...

This appears to be the same code you also asked help for in this topic: http://www.sqlservercentral.com/Forums/Topic1767785-3411-1.aspx.

In the future, please keep questions on the same issue in the same topic, and...

SQL!$@w$0ME (3/13/2016)

---

Hi Hugo, I have made some changes to the trigger so that users won't be able to make updates on the audit columns.

Can you please take a look into...

Starting with the obvious: For any new work, always...

SteveD SQL (3/12/2016)

---

The question is, does anyone know a data pattern for this requirement that is different from something basic like:

- A Data Source

- A Keyword Source

- A Data/Keyword...

Hi Nader,

I would be very careful before replacing all nvarchar columns with varchar columns. What if the database actually has to store data that requires a Unicode character set?

Another important...

In my opinion, pure T-SQL is not a good tool for this. T-SQL expects exact and precise specification, and how do you specify "sort of matches". And even if you...

And that's exactly the problem. A lot of things are not allowed in...

So maybe my mindreading skills are not as good as I hoped they were. Perhaps this is what you actually intended?

SELECT m1.memberid, m1.fromdate,

...

Try this:

SELECT m1.memberid, m1.fromdate,

m1.todate AS TodateEntered,

...

SQL!$@w$0ME (3/11/2016)

---

Thanks Hugo.

The vendor does not want to track all the history of audit columns. They want to keep the audit information(last insert/update) on the same table. Also want to...

SQL!$@w$0ME (3/10/2016)

---

Thanks a lot Hugo.

Did you already try the approach with column-level permissions? Have you considered the (IMO much better) alternative to have a separate audit table?

Not able to...

It helps if you post CREATE TABLE and INSERT statements for the table layout and sample data. Without that, I can only provide a generic pointer.

Join the table, using APPLY,...

SELECT resultA

FROM YourTable

UNION ALL

SELECT resultC

FROM YourTable;

If that's not what you need, then please post a CREATE TABLE statement for the table, INSERT statements with sample data,...