This gets posted at least once a week. . .

BEGIN TRANSACTION

CREATE TABLE mytable (id INT identity(1, 1),PersonID INT,Unit VARCHAR(10))

INSERT INTO mytable VALUES (1,'Che')

INSERT INTO...

You might find this a little better (only hits the table once, instead of twice as your code does)

DECLARE @exist TINYINT, @exist2 TINYINT

SELECT

@exist = CASE WHEN fid = @fid...

Revenant (1/15/2012)

---

Jeff Moden (1/15/2012)

---

Then, totally switching gears, are such sample tests actually helping to learn those things necessary...

Sorry, I looked in on your post a couple...

Don't know if you'll still be checking the notifications for posts on this thread, but I was thinking about ways to make it more efficient and came up with this...

Here's the standard test environment I use, normally customised slightly to fit the issue at hand.

--Standard TestEnvironment of 1,000,000 rows of random-ish data

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment

END

--1,000,000 Random...

GSquared (1/12/2012)

---

Bex (1/12/2012)

---

Cadavre (1/12/2012)

---

I'm going to continue posting, reading and answering questions on this site for one simple reason: I learn as much if not more than those that I've...

ramadesai108 (1/12/2012)

---

Hi All,

I have a view where I get the result from a decimal as 8.55, 90.07, etc. I want the result as 08.55 and 90.07....

I'm going to continue posting, reading and answering questions on this site for one simple reason: I learn as much if not more than those that I've helped. Either from...

mtillman-921105 (1/12/2012)

---

This is an older thread, but I'll try to give an example and explain more.

If you have one temp table named #Summary in the "parent" or calling procedure, then...

SQL Kiwi (1/12/2012)

---

It's not at all evident from the plan - I only came across it after running the...

First things first, we could do with some information from you 🙂

Read through this link[/url] to find out how best to post your performance related question.

Also, DDL may be useful.

Below...

Cadavre (1/11/2012)

---

In this case, you'd have to use a CLR as you can't execute a string in a function. If you need help writing one (and someone else doesn't post...

BEGIN TRAN

CREATE TABLE test (indkey NVARCHAR(2), datakey NVARCHAR(4), landline NVARCHAR(11), mobile NVARCHAR(11), email NVARCHAR(20))

INSERT INTO test

VALUES ('1', '0001', '01234567890', '0712345679', '1@test.co.uk')

INSERT INTO test

VALUES ('2', '0001', '01234567890', '', ...

I can't quite match your requested results, can you double check them?

I make it: -

Total ...