Not much in the way of details to work with here. You say you want to use this function in your proc but no explanation of where or why. Your...

I prefer to type the name of the datepart. It really helps avoid confusion and you don't have to resort to the documentation very often to figure out some of...

Truncate and load.

vba317 (10/28/2013)

---

I get this error when I am running one of my jobs. If I run the steps manually everything works well.

This is step 3 in a process. It...

p.shabbir (10/25/2013)

---

Sean,

At my work i used to specify "NOLOCK" at the end of select statement.Hence, by habit i mentioned...

ofg1983 (10/25/2013)

---

Guys,

I believe I am putting this up on the correct section, if not, please let me know.

My Question:

What is required in order to take the...

Why NOLOCK???

Here are a couple of other ways.

;with MyEmail (email)

as

(

select 'pearson.charles@companyname.com'

)

select *

, LEFT(email, charindex('@', email, 0) - 1)

, SUBSTRING(email, 1, CHARINDEX('@', email) - 1)

, REPLACE(SUBSTRING(email,1,CHARINDEX('@',email)),'@','')

from MyEmail

Sure no problem. Just roll your code...

priest Ivan Delic (10/25/2013)

---

Hello all!

I have a simple issue but couldn't resolve it yet. About four years ago I managed to build Reporting Services project using SQL Server 2005 Express...

You were so close...at least as I understand your requirements.

Select COUNT(*) / LEN(x.Vals) TCRuns, x.Vals

FROM

(

SELECT t1.ID as RunID, msv1.Val as Vals

From trial t1

CROSS APPLY

...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

kennethrbell (10/25/2013)

---

Hey Sean,

Boy how time flies.

I just wanted to thank you for your code.

This particular project got reprioritized by my boss (I'm sure you know how that goes.)...

Actually they are both cross joins. I prefer to be explicit when using a cross join instead of the shortcut of...

isuckatsql (10/25/2013)

---

I am trying to sort some data with known duplicates.

In an effort to 'clean up' the sort, is it better to use the 'sort column + a unique...