kangarolf (4/29/2014)

---

Hey all,

I have a rather complicated report using a stored procedure that uses the;

SELECT @vals = @vals + ' ' +

REPLACE( REPLACE(

then lots of case statements to pivot...

ArtoisBB (4/29/2014)

---

Hi Jeff,

Would the below be a better solution?

CREATE TRIGGER [TriggerName]

ON [InsertDataIntoThisTable]

INSTEAD OF INSERT

AS

BEGIN

DECLARE @Count INT

SELECT @Count = COUNT(*) FROM inserted

END

IF

@Count > 0

UPDATE

[AuditTable]

SET LastUpdated = GETDATE()

WHERE ...

Many...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

robin.pryor (4/28/2014)

---

Can someone please give me advise on a better way to write the following?

SELECT a.BoxId, b.field1 as value1, c.field1 as value2, d.field1 as value3, e.field1 as value4

FROM boxes...

Informer30 (4/28/2014)

---

Hi Sean,

thanks for reply, please let me know what further information is required...

I have a select statement that I need to run 15 times with a different where clause...

dba.sql29 (4/28/2014)

---

All ,

Thanks for your help.

This trigger is not going to work for me. I am trying to capture user name, data and couple of other thing when something is...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1565668-1633-1.aspx

TheSQLGuru (4/28/2014)

---

Jeff Moden (4/28/2014)

---

Just a thought...

The looping is going to cause a full table scan of a 100 Million row table for each and every loop. That's a shedload...

Informer30 (4/28/2014)

---

Hi All,

I have an select statement which needs to be run 15 times with a slightly different where clause and outputted

to excel.

Rather than me running 15 select statements...

SQL is delicious (4/28/2014)

---

Sean Lange (4/28/2014)

---

SQL is delicious (4/28/2014)

---

polo.csit (4/28/2014)

---

Dear friends,

my table have 100000000 records....

SQL is delicious (4/28/2014)

---

polo.csit (4/28/2014)

---

Dear friends,

my table have 100000000 records. i update the data with...

To further add to Eirikur's comments, sql does not care which application is connected to it. You don't control permissions by where the connection was originated. You control permissions by...

There are several ways to achieve what you are trying to do. Some of it...

That seems to be dealing with the symptom rather than the cause. 😉

Hints should be used as a last resort. The concurrency issue...

rash3554 (4/24/2014)

---

What I mean by vague is that I do not have control over third party API result. All we know by experience and analyzing records is that if the...