TRUNCATE command apart...

Thanks for reminding the basics 🙂

An easy one for the day!

Very Good Question Ron!

Keep pouring more of those SS2012 stuff..

If employeeID does not contain combination of both alphabets and numerals than you can use this also:

SELECT *

FROM employee

WHERE employeeId LIKE '%[A-Z]%'

In the earlier post, I assumed...

Like this:

SELECT *

FROM employee

WHERE employeeId LIKE '%[A-Z]%'

AND employeeId NOT LIKE '%[0-9]%'

Another Great question Ron!

I was not aware of this limitation and got the question wrong 🙂

Hugo Kornelis (12/13/2012)

---

Good question.

I am not sure why Lokesh chose to include a link to the SQL Server 2000 version of the documentation. Especially since the setup script uses SQL...

rightly said. This also made demonfox for fantastically quote like this

when I saw...

Glad to know that! 🙂

You can do it like this:

Creating temp table and inserting test values

create table #temp

(Receipt_key varchar(10),

Item_key varchar(10) ,

Position int);

insert #temp

values

('0001','02654',NULL),

('0001','35544',NULL),

('0002','02654',NULL),

('0002','85466',NULL),

('0002','84945',NULL)

Final update statement

WITH upd_recs

AS (SELECT Receipt_key,

...

sipas (12/12/2012)

---

Hugo Kornelis (12/12/2012)

---

As happens more often with a Question of the Day: Good idea, but badly executed.

If you exactly follow the instructions, executing the 'alter proc' script after making...

Explore Update() function to stop this behavior. Refer the link below:

http://msdn.microsoft.com/en-us/library/ms187326.aspx

Fortunate enough to get this correct. But the question required lot of reading and thinking!

Good question 🙂

I was also thinking upon this. Instructions in the Question should have stated something like this:

Right-click on...