User Profile

Reddeppa · Mar 27 '13, 08:10 PM

Client need the data in excel sheets..not from reportign services...

While running the above code excel sheets are generating with our column headers in the excel.

That to I need to seperate the data based on cname.

for your reference please find the attached data...
load the data into a table and runt he above script.

Kind regards,
Reddeppa G

Reddeppa · Mar 27 '13, 07:55 PM

Hi Rabbit,

IF the above code is not working in SQL 2008 because we don't have the SP_MAKEWEBTask system procedure.

So we have to implement with BCP Command.

Please find converted code in sql 2008...

Code:

USE [AexNS]
GO
/****** Object:  StoredProcedure [dbo].[sp_DHL_MultidimensionalReport]    Script Date: 03/27/2013 22:30:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER

...

Reddeppa · Mar 27 '13, 05:10 PM

hi Rabbit,

I have the procedure in SQL Server 2005 to create the excel sheets based on cname & Servername.

here I have few steps
1.I have the folders named

a).EMEA (under EMEA we have sub folders are SMP7_3741,SMP7_ 3742,SMP7_3743, SMp7_3744,SMP7_ 3745)
b).AM(under AM we have sub folders are SMP7_3746,SMP7_ 3747)
c)AP(under AP we have sub folders are SMP7_3759,SMp7_ 3790,SMP7_3791)...

Reddeppa · Mar 27 '13, 12:26 PM

Hi rabbit,

I need to run the script from stored procedure to create the excel sheet based on cname.
"'select * from tmp_ACS_MultiDi mensional where cName = 'CH All Workstations''"

Regards,
Reddeppa G...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

SP_MAKEWEBTASK system procedure avilable in sqlserver 2005?any equalent in sql2008?

Leave a comment:

Leave a comment:

BCP Command is not working. I need to pull the data from table and load into excel