Phil Parkin (9/24/2015)

---

aldous.chris (9/24/2015)

---

Hi All,

I am having trouble with a certain query - being the only SQL resource in my company, I do not have anyone to confirm or...

myjobsinus (9/23/2015)

---

Hi All,

I have a table as following . i am writing a query to extract data for a report. i need the output as the #DesiredOutput table. please help!

--...

Alan.B (9/23/2015)

---

@Wayne

Was this your intended 2012 solution:

-- SQL SERVER 2012 version:

SET STATISTICS IO ON;

SELECT

RowID,

CODE,

COLUMN1,

COLUMN2,

RunningTotal =

...

If you've already got a primary key on this table, you can also use a unique index.

Here is a method that is usually faster.

But first, here is the data, adding a few columns and not inserting those total rows:

IF OBJECT_ID('tempdb.dbo.#t1') IS NOT NULL DROP TABLE #t1;

CREATE...

robinwilson (9/23/2015)

---

Please can I ask if anyone knows the answers to these questions:

Primary Key vs Clustered Index

Would a clustered index or a primary key (which seems to always create a...

I'm inquiring as to whether there are any other options that could be utilized to handle this, but I can't think of any.

Eirikur Eiriksson (9/23/2015)

---

Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only done few millions (£) worth of...

acheras (9/23/2015)

---

Hi all,

Lately, I faced the below strange situation in SQL Server 2008R2:

The parent table has the column OrderID which is the primary key. There is a unique non-clustered index...

Joe-420121 (9/22/2015)

---

Hello Wayne,

Thank you so much for your time & efforts. Very much appreciated. I could never get to this level of complexity.

Very much impressed with your technical ability and...

Grant Fritchey (9/23/2015)

---

Ed Wagner (9/23/2015)

---

Eirikur Eiriksson (9/23/2015)

---

Lynn Pettis (9/23/2015)

---

Steve Jones - SSC Editor (9/22/2015)

---

jasona.work (9/22/2015)

---

I think I need an intervention...

I keep going back to the "Jet" topic, it's like watching...

Holy cow... I've been avoiding that thread, and curiosity got the better of me. Sure with it hadn't.

Everyone needs to just walk away from there. No more posting to it,...

randyetheridge (9/22/2015)

---

I have a field I am trying to bring into a SQL statement

,ISNULL(Convert(nvarchar(50),OPP1.OriginatingLeadId),'') AS 'OriginatingLeadId'

I get this error message

Conversion failed when converting from a character string to uniqueidentifier.

the field...

The obfuscation obtained by using the "WITH ENCRYPTION" clause on T-SQL objects is easily bypassed. Just search google for how to do it. Heck, 3rd party tools will even show...

Thanks Grant.