kschwid (2/13/2012)

---

I would just like to comment: Sometimes the people asking the question give enough information but the people trying to answer the question either don't understand and shouldn't respond...

I'd be interested in seeing the table definition for the target table, if you can provide that.

I may have missed it in your description, but did you try inserting into...

jcb (2/13/2012)

---

Sure, even a hardware token can be cracked.

The only way to...

CELKO (2/12/2012)

---

Look at the 2012-02-12 Doonesbury comic strip (http://www.doonesbury.com/strip ) and you will see the real problem in US education.

My wife is an ordained Soto Zen Priest who could...

You can add any column in the sub-query to the outer Select statement.

A trigger can call a stored procedure, just use Exec the same way you would in any other place where you call a proc.

If the proc will need access to...

jcb (2/9/2012)

---

GSquared (2/8/2012)

---

...

Assuming the database is on a server the person trying to steal your code has access to, all they have to do to steal your code is start...

cengland0 (2/8/2012)

---

GSquared (2/8/2012)The best bet is, if the database is on their server instead of yours, assume they know everything about it. Since it's impossible to stop them from...

GilaMonster (2/8/2012)

---

20 or higher. Below that they terminate the statement or the...

Roy Ernest (2/10/2012)

---

Couple of weeks back I told you all that I got a great review from work. Now they have changed my role. They want me to manage more...

First, the "IF Update" probably isn't doing what you want because an Insert will count every column as being updated. It looks like you're trying to use "IF Update"...

You can use "derived tables" for this kind of thing.

Would look something like this:

SELECT User_Id,User_FirstName + ' '+ User_Name AS Name

FROM dbo.ADMN_User_Details

left outer join (SELECT Opp_View.Close_Date, Opp_View.Status, O_Request_New___Review.O_Request_New___Review,Opp_View.Owner_Id,

A_Super_Regions.A_Super_Regions, A_Total_no_of_Employees.A_Total_no_of_Employees,

A_Scheme_Code.A_Scheme_Code, Company.State_Province,...

Instead of adding a fudge-factor to the math, why not do something like this:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

CREATE TABLE #T

...

I've got an e-mail address that's associated with an SSC account I haven't used for a while (long story and boring, don't ask). It's never received any spam. ...

Samuel Vella (2/9/2012)

---

SQL Kiwi (2/9/2012)

---

Some people find it best to simply ignore the Joe Celko forum attitude (he's apparently very personable in real life). He posts this sort of...