Brandie Tarvin (11/5/2015)

---

BWFC (11/5/2015)

---

Woolly nebulous request of the month alert.

I've been asked to look into ad-hoc reporting solutions so users can create their own reports.

All I know is it's a...

DROP TABLE #MyBigTable

SELECT * INTO #MyBigTable

FROM (VALUES

('JOHN DOE',CAST('20150423' AS DATE),''),

('JOHN DOE','20150424',''),

('JOHN DOE','20150425',''),

('JOHN DOE','20150426','<- 1 EPISODE'),

('JOHN DOE','20150503','<- 1 EPISODE'),

('JOHN DOE','20150510','<- 1 EPISODE'),

('JOHN DOE','20150616',''),

('JOHN DOE','20150617',''),

('JOHN DOE','20150618','<- 1...

drew.allen (11/4/2015)

---

The OUTPUT clause is very limited. You can either output the data directly to the client application or you can output your data to a table/table variable. Period....

Resender (11/4/2015)

---

OK I'll try to summarise

The company I work for produces a certain type of machinery used from factories to common households around the world.

The database is where data being...

mcoleman15902 (11/3/2015)

---

I want it to say, okay, here is a business class "L", now let's see if there are any other sub classes along with it being a large business....

GilaMonster (11/3/2015)

---

No spare time this week, but given the...

For each CASE, the column lists look the same to me.

(SELECT V.VEND_NAME_EXT

,LNHS.CST_AMT

,VCHR.VEND_ID

,V.CL_VET_FL

,V.CL_SD_VET_FL

,V.CL_ANC_IT_FL

,V.CL_DISADV_FL

,V.CL_WOM_OWN_FL

,V.CL_LAB_SRPL_FL

,V.CL_HIST_BL_CLG_FL

,V.CL_ANC_IT_FL

,VCHR.VCHR_KEY )

I'm lost now - you've gone to some length to tell us that they...

mcoleman15902 (11/3/2015)

---

I think it needs to be separate columns for reporting purposes because it's going in SSRS. I tried using a case statement like so:

select case when V.S_CL_SM_BUS_CD = 'L'...

Resender (11/3/2015)

---

In the meantime 123883 tables (yes 30 new tables got added) the total recordcount is

89,372,968,620

I wish I knew but I'm frequently being...

Any folks out there with a little time to spare with this thread - it's just exceeded my comfort zone. Thanks.

ChrisM@Work (11/3/2015)

---

Resender (11/3/2015)

---

ChrisM@Work (11/3/2015)

---

Resender (11/3/2015)

---

Total number of machine tables (3/11/2015 13:44 CET) 123851

Those tables are the same

[MachineRegisterId] [int] NOT NULL,

[UtcTime] [datetime] NOT NULL,

[Value] [float] NOT NULL

With primary key on...

Resender (11/3/2015)

---

ChrisM@Work (11/3/2015)

---

Resender (11/3/2015)

---

Total number of machine tables (3/11/2015 13:44 CET) 123851

Those tables are the same

[MachineRegisterId] [int] NOT NULL,

[UtcTime] [datetime] NOT NULL,

[Value] [float] NOT NULL

With primary key on the...

Resender (11/3/2015)

---

Total number of machine tables (3/11/2015 13:44 CET) 123851

Those tables are the same

[MachineRegisterId] [int] NOT NULL,

[UtcTime] [datetime] NOT NULL,

[Value] [float] NOT NULL

With primary key on the combination of...

How many of these tables are there in the db?

Are...

Resender (11/3/2015)

---

Before proceeding any further,

The largest table contains above 1.5 million records,the smallest about 16, and their hundreds on hundreds that are currently...