You are very welcome!

😎

Ed Wagner (9/3/2015)

---

Given what you were given, I think you did pretty well. If you nailed it, then we know who has...

You are welcome.

😎

Quick question, will you always know the number of columns in the output?

In simple terms there is hardly any difference on smaller sets (10K rows or less),...

Ed Wagner (9/3/2015)

---

Given what you were given, I think you did pretty well. If you nailed it, then we know who has...

Jayanth_Kurup (9/3/2015)

---

pivot makes sense if the message column is a int or numerical data type on which aggregations need to be performs else if the number of messages is static...

Quick cross-tab suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

Declare @Store table(id int primary key identity(1,1),StoreId int);

Declare @Message table(StoreId int, Messages varchar(100));

Insert into @Store(StoreId)

select 100 union all select 200 union all select 300 union...

Has anyone seen the Crystal ball?

😎

rsrvas (9/3/2015)

---

Hi All,

I have 2 tables as defined below. I want to calculate PS1time and Ps2 time.

Table 1

O_IDP_TYPEP_startdateP_enddate

ABCP8/24/2015 13:148/24/2015 13:41

ABCP8/24/2015 14:038/24/2015 15:31

ABCP8/25/2015 12:098/25/2015 13:25

XYZP8/28/2015 13:108/28/2015 21:44

Table 2

O_IDS_TYPES_startdateS_enddate

ABCS28/24/2015 13:148/24/2015 19:22

ABCS28/24/2015 19:228/30/2015...

Colony

TomThomson (9/3/2015)

---

Ed Wagner (9/3/2015)

---

I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

Those who have never heard of it will sit...

Brand

Ed Wagner (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that...

Quick suggestion, don't use the Fn_split function, use DelimitedSplit8K [/url]instead

😎

sandhyak16 (9/3/2015)

---

Hi,

I am using FOR XML to generate the HTML and following is my query. I am using td { white-space:nowrap;} for the columns to used no wrap. But i...