Jim Shaffer (1/16/2015)

---

Lets say I have some data where a bit value changes over time and I want to rank it by the repeating groups, how do I write the...

Still further on the subject, here is a table value function spawned by Lynn's function

😎

USE tempdb;

GO

create view dbo.MyNewID as

select newid() as NewIDValue;

go

CREATE FUNCTION dbo.ITVFN_DO_SHAKESPEARE

(

@BATCHSIZE INT...

Jeff Moden (1/16/2015)

---

Eirikur Eiriksson (1/16/2015)

---

Jeff Moden (1/16/2015)

---

sqldriver (1/16/2015)

---

Oh my word! That's bloody well...

Stefan Krzywicki (1/16/2015)

---

The "seed" for the...

Further on this, if you want more normal looking text then something like this might help

😎

DECLARE @BATCHSIZE INT = 255;

DECLARE @ROWCOUNT INT = 10000;

;WITH T(N) AS (SELECT N FROM...

Quick alteration of the code, changed to set based double loop, the trick is to a add variations to the inner loop

😎

DECLARE @BATCHSIZE INT = 255;

DECLARE @ROWCOUNT INT =...

Jeff Moden (1/16/2015)

---

sqldriver (1/16/2015)

---

Oh my word! That's bloody well insane. :hehe: Do...

For fun, few different counts/metrics

😎

USE tempdb;

GO

SET NOCOUNT ON;

;with UnionTables as

(

SELECT CAST(TestDateTime AS Date) TestDate,

SerialNumber,

TestType

FROM Coat

UNION ALL

SELECT CAST(TestDateTime AS Date) TestDate,

SerialNumber,

TestType

FROM Cutoff

UNION ALL

SELECT CAST(TestDateTime AS Date) TestDate,

SerialNumber,

TestType

FROM Geo

UNION ALL

SELECT CAST(TestDateTime AS...

sqldriver (1/15/2015)

---

Yeah, I just do this and replace the TOP with whatever target number.

USE tempdb

DECLARE @cntr BIGINT = 0;

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))

,NUMS(N) AS...

Many ways of doing this, here is one

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

[Date] DATE ...

Certainly there is a branded Witbier on it's...

Quick though, unless you have an under-performing/resource starved system, 10000 sounds like a very small number for an insert batch size, any particular reason for this number? Cannot see it...

kiran 4243 (1/13/2015)

---

Hi,

How to get the lowest U.Price along with FX and Rate.

ID-U.Price-FX-Rate

1280 19.1196 EUR 3.85

1280 46.2462 USD 3.63

1280 6.32 RM 1.00

Required output.

ID-U.Price-FX-Rate

1280...

Congratulations, good job and well done, justly deserved I would say!

😎

srinivas.akyana (1/12/2015)

---

Hello,

I have a scenario where I would need to add +4 IDs with the existing IDs, below is an example:

IDWorkloadUnits

1EXO 3

7SPO ...