Please Help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Please Help

Author

Topic

rebooot
Starting Member

9 Posts

Posted - 2009-12-01 : 17:12:46

I need someone to re-write this code for me for the SQL server 2008. I would greatly appreciate it:

PARAMETERS SQLPeriodIndex Text ( 255 ), theMarket Text ( 255 ), theSegment Text ( 255 );
TRANSFORM Sum(Choose([SQLPeriodIndex],[L4],[L12],[L24],[L52],[YTD],[YTG])) AS SumOf
SELECT Data_3.Tag
FROM Data_3 INNER JOIN SKU_CONTENTS ON Data_3.Tag=SKU_CONTENTS.TAG
WHERE (((Data_3.Market)=[theMarket]) AND ((SKU_CONTENTS.SEGMENT)=[theSegment]))
GROUP BY Data_3.Tag
PIVOT Data_3.Fact;

Cheers for all of your SQL Server gurus,

Rebooot

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-01 : 18:27:41

What language is it in?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

rebooot
Starting Member

9 Posts

Posted - 2009-12-01 : 19:38:29

This is written in MS_ACCESS VBA code and I am trying to write it to upsize it to SQL Server 2005.

rebooot
Starting Member

9 Posts

Posted - 2009-12-02 : 18:47:14

WOW no answer!
Is this problem that hard? No one has enough knowledge to tackle this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-02 : 18:51:50

I don't have any Access VBA experience, so I'm not able to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

rebooot
Starting Member

9 Posts

Posted - 2009-12-02 : 19:28:05

Hi Tara,
What if I tell you what the final product needs to look like in SQL Server, would you be able to form a dynamic crosstab query?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-02 : 19:30:51

Someone here should be able to help you. I'm strong on the DBA side, whereas a lot of people here are strong on the SQL development side. I'd suggest opening a new topic so that you get fresh eyes on your issue when you explain what you need for the final product.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

X002548
Not Just a Number

15586 Posts

Posted - 2009-12-02 : 21:12:03

FIRST of all...this is NOT VBA

It MAY be Access SQL

BUT...it surely isn't something you did in a QBE grid

You must have wrote it yourself

What virgin of Access is this?

Go Post Here

http://www.dbforums.com/microsoft-access/

OR

http://www.dbforums.com/visual-basic/

And go look for a Blind Dude

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

X002548
Not Just a Number

15586 Posts

Posted - 2009-12-02 : 21:12:37

quote:
Originally posted by rebooot

WOW no answer!
Is this problem that hard? No one has enough knowledge to tackle this?

This has got to be Jon

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources