Jeff Moden (3/30/2012)

Careful now... that's actually been deprecated not to mention that it will return...

Have you exclusively granted CONNECT to that security login for the DB

Ex:

USE [mydatabase]

GO

CREATE USER [xyzINC\SVC_SQL] FOR LOGIN [xyzINC\SVC_SQL]

GO

GRANT CONNECT TO [xyzINC\SVC_SQL]

GO

You could try this, works pretty wellSELECT

Pin,

CDate,

btn,

callduration,

charge

FROM #gmreport

ORDER BY pin

COMPUTE SUM(callduration), SUM(charge) BY pin

I believe you can do this directly within SQL but first you'll need to make sure you have the "Data Connectivity Components" update, available at http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

See this article for more...

GOOD LORD JEFF!!! :w00t:

The efficiency of this using the TVF is incredible. I processed a years worth of data in just under 2 minutes...WOW - THANK-YOU!!!

The ROLLUP is not something...

Have you thought about running the exe using the windows OS job scheduler?

Could you use xp_cmdshell?

I didn't think about the fact that because the file was an attachment it might keep you from opening it

SELECT '292596778','876887','427512','May 4 2009 12:00AM','0002 ...

I thought I posted the DDL in the first post (apologies)

CREATE TABLE [dbo].[tmpQTY_LocalFleets_WORK](

[tranid] [int] NULL,

[ctrl-number] [int] NULL,

[tc-number] [varchar](20) NULL,

[pos-date] [datetime] NULL,

[tc-card] [char](10) NULL,

[trans-code] [int] NULL,

[prod-code] [varchar](160) NULL,

[prod-qty] [varchar](400) NULL,

[Month] [int]...

Hey Jeff, thanks for that (really)...just not certain how I would work your splitter into what I already have posted a couple posts above...

With using the CTE's that GSquared provided...

I've got to say, your solution is elegant and incredibly slick all at the same time. I can honestly admit I never would have come up with it on...

So just a table with 1 col, values 1 - n?

Thanks for the hints, I never bothered attempting CTE's for this...definitely something to try - In your example though, where is dbo.Numbers coming from?

USE [SSRS_Run_Reports]

GO

/****** Object: UserDefinedFunction [dbo].[fx_ArrayList_IP_9378] Script Date: 03/26/2012 11:23:25 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/* =============================================

Author:John Doe

Create date: 03/20/2012

Description:To be able to parse over...

Please attach your execution plan