Quick solution, similar to the one Ozzmodiar posted, with an additional POC index which eliminates any sorting operations in the execution plan.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.testTable') IS NOT NULL DROP...

Mark Cowne (4/17/2015)

---

Try this

WITH CTE AS (

SELECT cust_Id,sDate,budget,

ROW_NUMBER() OVER(PARTITION BY cust_id ORDER BY sDate) -

ROW_NUMBER()...

Further on Alan's reply, this is an incomplete query, first guess would be that it's from a BMC Dashboard, try to capture the whole query.

😎

Yes it is, I would ask...

Quick and somewhat naïve ( compared to Dwain's ) solution

😎

Note: added 'a'-->'@' for demonstration purposes 😉

USE tempdb;

GO

SET NOCOUNT ON;

/* sample data */

IF OBJECT_ID(N'dbo.ReplaceCharStrings') IS NOT NULL DROP TABLE dbo.ReplaceCharStrings;

CREATE TABLE...

Passed

Conflict

Build

kcj (4/16/2015)

---

I have two string variables each has Varchar(8000)

Declare @VariableA varchar(8000)

Declare @VariableB varchar(8000)

How can I concatenate these two variables without converting them to varchar(max) ?

If...

Alan.B (4/16/2015)

---

Looks like you have duplicate column names in both tables but you are not using a table alias

You query should look something like this:

SELECT a.col1, a.col2, b.col1

FROM a

Join

(

<Subquery>

)...

Have you checked the tempdb, congestion there is a possible cause.

😎

Ink

GF (4/15/2015)

---

SQL 2008

I have a table that has company id, attachment file name, folderexists columns.

First what I need to do is create a series of folder or directories on...

Pretty cool!

😎

IaaS