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

Thomas Abraham (1/12/2015)

---

Hugo Kornelis (1/12/2015)

---

I thought that using SELECT would have started the implicit transaction, but I tested after answering this question and nothing changes if I use SELECT instead...

Quick thought,...

Quick partial solution, missing the handling of negative stock count though.

😎

SELECT w.ItemId

,w.DateID

,w.OpenningWareHouseUnits

,w.FcastSales

,w.GoodsIncoming

,w.TargetRunningStock

, SUM((ISNULL(w.OpenningWareHouseUnits,0) + ISNULL(w.GoodsIncoming,0)) - w.FcastSales) OVER

...

Quick simple solution, note that the output is not formatted but that's easy

😎

USE tempdb;

GO

SET NOCOUNT ON;

--INVOICE DATA

IF OBJECT_ID('tempdb..#RawData') IS NOT NULL DROP TABLE #RawData;

CREATE TABLE #RawData (Invoice varchar(7), Quantity int,...

Quick questions, are these assumptions correct?

😎

1) Definition: Territory is a Geographical Area, defined by a collection of Zip Codes, each of which represents either a Geographical or a Pseudo location....

Slightly simpler solution for SQL Server 2008 and later, produces the same results

😎

declare @pSomeDate as varchar(20) = '04/2011';

SELECT

recid

,weeknumber

,title

...

chef423 (1/11/2015)

---

hmmm, that's why I put the output of the above code in the thread...

No worries...Ill figure it out on my own then.

If you don't understand the original code then...