One more thing that may help, a separate SPAM ALERT button. It sends a report regarding the post, and sets an Invisible flag so that the post is kept...

mayankminawat (8/10/2014)

---

Thank you for all the assistance. I am able to get the function to run but when I do the following in a T-SQL block, I am getting an...

Eirikur Eiriksson (8/10/2014)

---

LutzM (8/10/2014)

---

I'd like to change Eirikurs 2nd method just slightly to cover partitioned tables, too:

CREATE FUNCTION dbo.FN_COUNT_ROWS2

(

@TABLE_NAME NVARCHAR(128)

)

RETURNS TABLE

AS

RETURN

SELECT SUM(rows) AS ROW_COUNT FROM...

New_2SQL (8/10/2014)

---

Hi Lynn Pettis,

On my laptop the old source code took 546ms whereas your new source code took 124ms only. Very good improvement.

Can you also explain to me if it's...

Not enough info to really help. Unfortunately we can't see what you see. May help if you post the procedure that is being run for this report.

jasona.work (8/7/2014)

---

We're required to comply with the DoD STIG guides for our systems, and one of the requirements is "data files containing sensitive information must be encrypted" and "SQL Server...

Duplicate post, please post answers here.

Initial response, not possible.

Follow up question, however, what do you mean by a backup of the index?

Jeff Moden (8/9/2014)

---

GilaMonster (8/9/2014)

---

sqlfriends (8/8/2014)

---

But my question is why bother to grant all these permssions, but just grant this account db_owner role. Becaue it pretty much need all the permissions:...

Here is my rewrite. For a quick test and comparison create two empty sandbox databases. Then in one sand box run your code and in the other run...

As this is your thread, I'd just post it here.

Based on what you posted, give this a shot:

/*

TableA:

id | Descr |name

1 |ab |h

2 |bc |K

3 |de |m

5 | |mn

6 |jk |hb

TableB:

id | Name | Descr

1 |h |

2 |k |

4...

Let's make this easier for others:

http://db-pub.com/news-10013929/data-driven-subscriptions-in-sql-rs-standard.html

First, do not store dates as strings....

It is was obvious that one of the data elements is DOB but that didn't answer the question.