What are you using for pulling the data?

😎

areed (6/16/2014)

---

My query pulls data from two separate databases, and it runs extremely slow. The queries run well when they are pulling from their own database. When I join them...

mister.magoo (6/15/2014)

---

It's not very fancy, but I have found a query where NOLOCK really is desirable...

SELECT result FROM fifaworldcup2014 [highlight="#ffff11"]WITH(NOLOCK)[/highlight] WHERE team='ENGLAND'

Here's hoping for that "incorrect data" we are constantly...

Doesn't make much difference at execution time, but often helps at design time, especially with more...

:-DBrilliant!

😎

Now we are getting somewhere, looks like an utility extract from a CDR, possibly MiTel (hence the table name in the earlier post), will look...

Jeff Moden (6/15/2014)

---

Gosh, I hope that...

cbrammer1219 (6/15/2014)

---

I don't need all of the data, I am inserting the data from my original post to create a SSRS report, the data is coming from the flatfile which...

Jeff Moden (6/15/2014)

---

Eirikur Eiriksson (6/15/2014)

---

Didn't see Lynn's code before I wrote the example, almost the same but without a string thingy

😎

/*Converting INT date and time to datetime */

DECLARE @INT_YYYYMMDD INT...

Forgot to answer the question:-D

It's not possible to programmatically set or concatenate the variables...

peacesells (6/11/2014)

---

:setvar Instance SUBSTRING(@@SERVERNAME,7,3)

:setvar FolderPath "\\Here\there\where"

I have two sqlcmd variables that i need to concatenate and store the values in the third variable and use that variable in...

As an idea for an alternative, here is a window function based solution. Still needs a CTE as window function cannot be directly used as a parameter in another window...

Could you share some more information such as execution plan, sp_lock and sp_who2 output?

Also check out these two articles

😎

How To Monitor Deadlocks in SQL Server

Detecting and Ending Deadlocks

Didn't see Lynn's code before I wrote the example, almost the same but without a string thingy

😎

/*Converting INT date and time to datetime */

DECLARE @INT_YYYYMMDD INT = 20140704;

DECLARE @INT_HHMMSS ...

Guessing a little bit here but this is what I think:rolleyes: you are after

😎

; WITH cte AS (

SELECT * FROM (

SELECT 200 CustID, 110 Amt, 1 MM, 'Jan'...