Looks more like a rounding trick in the insert, pretty certain the column's datatype...

J Livingston SQL (9/5/2015)

---

TomThomson (9/4/2015)

---

Eirikur Eiriksson (9/3/2015)

---

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

Quick thought, yes you will have to sum up the quantity, probably similar to the PackageTotals.TotalActualWeight

😎

Although one could try to decypher the query it is unlikely that answers derived from...

Quick thought, make certain that you use an inline table value function and NOT a scalar function, the performance of the latter is horrendous, see the simple test harness and...

jacksonandrew321 (9/5/2015)

---

I need to develop a client side XSLT that can transform that can extract only the required information that should be published e.g. Full name of scholar, department name,...

You are very welcome and thank you for the feedback.

😎

MotivateMan1394 (9/5/2015)

---

No It's not true.

If I Group by Cartid,SHCode , I get all records in my result.

I Need sort of Group BY cartid And get max(editDate) >>> at...

hegdesuchi (9/4/2015)

---

Hi,

I have a scenario where ID has three flags.

For example

ID flag1 flag2 flag3

1 0 1 ...

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