PiMané (10/2/2012)

---

Thanks... using the column number isn't as much readable friendly as is the column name.... but it works fine 🙂

Is there any problem using the column number besides risking...

Charles Kincaid (10/2/2012)

---

I would agree with you except for name collision. ...

You should read this article from Gail about catch all queries. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

And if you are going to have to modify column names after you create them I don't see how this saves you any effort or time. At any rate instead...

charles.byrne (10/2/2012)

---

Besides the .* issue which sounds like you plan on fixing. What was also odd was the naming prefix for the views being 'tbl_' for a view. ...

Of course this is nothing more than a cursor. Take a look at the code.

Jeff Moden (10/1/2012)

---

Perhaps it's just the way I've been using them but I've had no such problems with a properly constructed EAV. Certainly, I've not had to do a...

I don't understand how this determines which time zone. To truly get the format in the way you...

PSB (9/28/2012)

---

Updated 2nd case data

IF we have same relNum,DDate and differnt MAXBOLTIME

Insert into FACT

SELECT 4,400,7999,2012-1-27,1234,1111,3333,489

UNION

SELECT 5,500,7999,2012-1-27,2000,2222,1111,499

UNION

SELECT 6,600,7999, 2012-1-27,1,2,3,466

we need the row with maxbol (499) and delete the two e.g...

jhtein (9/28/2012)

---

Thanks Sean, that worked and got me the results I need.

Those number were just examples; not taken from the data. I probably should have clarified that.

I'll remember to following...

Pretty sparse on details but I think something like this is what you want.

;with Data as

(

select 1 as ID, 'A' as Status, 1 as Sequence union all

select 1, 'C', 2...

We are getting there...your ddl doesn't actually run as is.

Try this for the Fact table

create table FACT

(

ID int identity(1,1),

OrderID INT,

relNum int,

DDATe DATE,

BGallons numeric (14,3),

GGallons numeric (14,3),

NGallons numeric (14,3),

MAXBolTime...

chinni_16 (9/28/2012)

---

I need to display time with timezone and date when executing the report.

I was trying with format but I did get the desired results.

It has to be displayed like...

Where are you getting this from? There have...

Yes there is. The answer starts by reading the first link in my signature.