Lynn Pettis (5/13/2016)

---

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot, just a few short...

What do you mean by this?

😎

Date is obviously better than int or char but the OP was exactly on those conversions to...

karthik M (5/13/2016)

---

All,

I have a thought on converting integer value (whereas date is stored in INT format) to Date. The same column is declared as char(8), so the convert...

zahid.techk (5/14/2016)

---

Hi All

I have facing problem to display information like Lag function, but Lag is not working on sql server 2012,

I want wo display data like tha...

Month_NameTotal_Test ...

TheSQLGuru (5/11/2016)

---

Alan.B: You have escaped the primary performance problem of chewing through unnecessary rows of each month on the date dim table with the filtered index. Well done. That was...

Good stuff (literally) and thanks for the heads up Steve

😎

Jeff Moden (5/13/2016)

---

jasona.work (5/13/2016)

---

So at the Detroit SQL PASS meeting last night, got to put faces to the names of those shining beacons of SQL knowledge and all things pork...

I realize this is an old conversation but still valid, my thought is that in today's media marketing, freebies are considered a must, no carrot no catch in a way....

Discrimination in any...

Neeraj Pal (5/13/2016)

---

This Query will Return current and Previous 12 month Start Date..

==========================================

DECLARE @month int=0

DECLARE @table TABLE (LastYearDate DATETIME)

WHILE @month<12

BEGIN

INSERT @table

( LastYearDate...

Quick suggestion

😎

DECLARE @cap2 TABLE

(

id int primary key,

ten varchar(100) not null,

SoCV varchar(100) not null

)

INSERT @cap2

VALUES (1,'user 1|user 2|user...

Suggest you add first...

etirem (5/11/2016)

---

Hello All...need your help ,

I have 2 db's(@DName1 and @DName2). Need to change the logical names of @DName1 to @DName2 names.

Executing --Stmt_1 gives --Stmt_2 and then executing --Stmt_2 will...

Alan.B (5/11/2016)

---

I think my performance test proves that a calendar table is a viable high-performing alternative. In the end I would go with a tally table solution because of the...

Eric M Russell (5/11/2016)

---

TheSQLGuru (5/11/2016)

---

Eric M Russell (5/11/2016)

---

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

For what it's worth, this one can be paramaterized in terms of the number of dates returned, and it...