Galahad Phillips

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 33 total)

RE: Re Pivoting a table

What you posted makes sense. I tried it out for those two entry codes WFC & DCM and it seems to work fine, with the exception that I had to...

August 2, 2005 at 8:09 am

#578844
RE: Percentage Calculation

Good point, I would create a view, however w/ the amount of data that will be contained in the table (millions of rows) the requirement is aggregate all data first,...

July 22, 2005 at 1:14 pm

#576550
RE: Percentage Calculation

Thanks for pointing me in the right direction. Utilizing your logic, I modified my query as shown below:
SELECT
cast(C.LABORLEV3DSC + '(' + C.LABORLEV3NM + ')' as varchar(255))AS Facility,
cast(C.LABORLEV2DSC + '('...

July 22, 2005 at 1:03 pm

#576548
RE: Percentage Calculation

Here's the table design
CREATE TABLE [dbo].[PunchTrend] (
[Facility] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[District] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Division] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EntryType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL...

July 22, 2005 at 11:10 am

#576513

RE: Output Individual Months w/ Total for Date Range

The requirements have changed a bit so I removed the date range clause and inserted the data into a flat table that looks like this:

July 20, 2005 at 11:01 am

#575880

RE: Output Individual Months w/ Total for Date Range

Wow, maybe someday I'll be as good @ sql as I am at Flash programming...Im impressed...

Thanks again, I assume you're a dba? TSQL is fairly new to me, in my...

July 19, 2005 at 1:43 pm

#575640

RE: Output Individual Months w/ Total for Date Range

Unfortunately, I can't change the layout. However, the project requirements have changed and now I will be able to use a stored proc. So I'll take your original query and...

July 19, 2005 at 1:26 pm

#575631