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'...

cbrammer1219 (6/12/2014)

---

Yes, I am not looking to count the spaces, I want the count of characters before each space, I can find the spaces, but I am needing for example...

:smooooth:

It certainly looks, smells and tastes like a CDR, question is what is the originating system, record type and record format? Many CDR formats are slightly...

Here is a solution based (loosely) on DelimiterSplit8K.

😎

USE tempdb;

GO

DECLARE @STGTXT TABLE

(

STGTXT_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL

,STGTXT_TEXT VARCHAR(MAX) ...

Quick thought on this, I think there is a slight mix-up in the conversation. Using integer in a YYYYMMDD format as a date dimension key in a datamart is not...

Jeff Moden (6/13/2014)

---

Since you brought it up,...

You have to use BIDS or SSDT, not SSMS....

Kuzey (6/13/2014)

---

When I run this;

EXEC...

Kuzey (6/13/2014)

---

SET @sql='SELECT @aId, @dId, @dStatusId, d.DateCreated, d.DocumentSize,...