Prettiness and speed are apparently not conflicting requirements:

PRINT 'Dwain.C COLLATE + CROSS APPLY'

SET STATISTICS TIME ON

SELECT @Email=RIGHT(

STUFF(a.email

,CHARINDEX('@',...

This probably isn't what you're looking for either but we'll give it a shot:

;WITH Amounts AS (

SELECT *,

...

Mark-101232 (11/21/2012)

---

Modded version of Dwains, much quicker

PRINT 'Dwain.C COLLATE'

SET STATISTICS TIME ON

SELECT @Email=RIGHT(

STUFF(email

,CHARINDEX('@', email COLLATE Latin1_General_BIN2)

...

Boys, boys. If you're going to argue about performance may I interject a new dog into this race?

DECLARE @Email VARCHAR(100) = 'John.Doe@companyabc.com'

SELECT Email=RIGHT(

STUFF(@Email

...

kramaswamy (11/19/2012)

---

A few questions:

1) What's the difference between using an UPDLOCK and using a higher-level lock? Should I also be using ROWLOCK and XLOCK, or is that overkill?

2) How long...

BTW I forgot to mention this.

Kudos to you for trying to think ahead to the concurrency scenarios. Many people don't and that causes untold problems that are only seen...

Interesting problem, but you may have missed something. Shouldn't your PU table also include the quantity of product a particular user has on loan?

The code below should handle your...

Eugene Elutin (11/19/2012)

---

Have you tested it? You should try:

CREATE TABLE [dbo].[MyTable](

[col1] [int] NOT NULL,

[col2] [int] NOT NULL,

[col3]...

While many have suggested that I should be committed, my board handle is actually Dwain.C!

You're welcome anyway.

VegasL (11/18/2012)

---

Thanks Dwain.

I tried

select LEFT(127.0.0.1,len(127.0.0.1-charindex('.',reverse(([Ip]))

from [dbo].[TestTable]

but am getting

Incorrect syntax near the keyword 'from'.

127.0.0.1 is column name.

Since I'll probably have a list of over 100k I don't think the...

Many ways. Choose your poison:

DECLARE @T TABLE (IP VARCHAR(30))

INSERT INTO @T

SELECT '102.89.93.101'

UNION ALL SELECT '100.100.10.1'

UNION ALL SELECT '123.94.9.121'

SELECT PARSENAME(IP, 4) + '.' +

PARSENAME(IP, 3)...

Under All Programs/Microsoft SQL Server 2008/Configuration Tools

run: SQL Server Installation Center

Then select Tools/Installed SQL Server features discovery report

To start with, the XML you provided won't parse:

DECLARE @XML XML = '

<RuleData ReturnVariable="">

<MateProperties>

...

Job security?

So you can be promoted to a management...