I think this is along the lines of what you're looking for. Please let us know:

CREATE TRIGGER dbo.TBL_LOCATIONS_after_insert ON dbo.TBL_LOCATIONS

AFTER INSERT

AS

BEGIN

INSERT ...

In my experience when a manager talks about "teamwork" it typically translates into something along the lines of conformity and group-think. Innovation and improvement over current ways of doing things...

Not that I know of. Why do you need it?

Let's take a step back...

You are worried about protecting financial data. You go on to say that you cannot change the database schema. For future consideration: database tables contain columns,...

mikes84 (6/30/2011)

---

I'm not sure anyone really cares, but I earned my

MCTS: SQL Server 2008, Database Development

certification today. It took a lot of studying as many of you know, but...

Finding the n-th instance of a character in a string is greatly simplified if you use a Tally table. Here is a script to create one in your database if...

It looks like you asked the same question,...

Welcome rud. Next time please provide the sample DDL and DML to build your tables so we can setup your environment on our side.

This article is a great starting point:...

SQLRNNR (6/30/2011)

---

aarded (6/30/2011)

---

I kow!

But I mean that it works with SQL server agent and a proxy account.

I use this as a workaround.

The problem is: I can't set the 'GRANT EXECUTE'...

j.miner (6/30/2011)

---

I hope this explains your question in depth.

First, SQL Server only supports UTF16 with the NCHAR, NVCHAR and NTEXT datatypes. That means, a character is represented by 2...

No "shooting down" activities out of me. What you have provided will certainly get the job done Mike. All I'll say is that you'll be leaving money (in the form...

Attopeu (6/29/2011)

---

Hi Guru,

How can I write a case statement to substract these below dates to be one singe value?

DistributedDate

-------------------

2011-05-16 23:50:14.080

2011-05-16 23:50:32.407

2011-05-16 23:54:10.883

2011-05-17 00:14:12.333

2011-05-17 00:47:27.463

2011-05-17 00:50:32.757

Here is my query:

select CONVERT(VARCHAR(20), DistributedDate,...

ChacMoll (6/29/2011)

---

Thank you very much!

You are right, indeed this was a problem of understanding in my reading, but I'm interested to support me if you know of any technology or...

Murthy-152277 (6/29/2011)

---

I need to test some functionality for UNICODE. I would like to generate all possible characters for UNICODE. Is there any way in SQL Server to generate this data....

I think we narrowed it down...here is one more update...only the procs that make direct use of temp tables need the no-op:

CREATE DATABASE test_openrowset

GO

USE test_openrowset

GO

create table openrowsettest (

...