Please follow the link in my signature to find how to post your question in order to attract relevant and prompt ANSWERS 😉

J.Moden "must read" article should help you:

http://www.sqlservercentral.com/articles/Crosstab/65048/

SELECT SchoolID

,REPLACE(REPLACE(SchoolName, '-',' - '),' - ',' - ') AS SchoolName

FROM #x1

Looks good! But...

The above will return every possible transaction for the every sales person...

That what a "quirky update" is about...

But!

To make it bullet-proof you need to read J.Moden article and see what else should be added into your query, so it...

Please stop spamming the forum!

What do you mean by that?

There are build in T-SQL datetime function to...

All of these looks like a homework to me.

In the real life this one better to be done using calendar table.

And you would only use the script to populate it...

Also,...

There are few ways to implement such thing.

Actual strategy would depend on many factors.

In general, I would use SSIS to perform such task.

I would not use this method of uploading files at all for many reasons. Do you have 32-bit or 64-bit system?

Anyway you can try specify your delimeter in a connection...

Could you please post your sql which builds dynamic SQL your INSERT INTO statement.

You cannot upload differenet files at once.

I dont' think anyone would have a cript which you could use "out of the box".

There are two main ways for uploading flat files...

As you have mentioned about using the audit data for building cube, I would recommend to create a dedicated table to keep all audit history of Product changes.

Then you...

Luis Cazares (6/28/2013)

---

Ok, won't argue on this, but will definitively search on why I was told that.

EDIT: I believe they told me to change a non-clustered index (only index on...

SELECT

y2013.[Year]

,y2013.[SKU Number]

,y2013.[Country]

,y2013.[Units]

,y2013.[Sales]

,y2013.[ASP]

,y2012.[ASP]

FROM [Wirt].[dbo].[Basal_Media_2] AS y2013

JOIN [Wirt].[dbo].[Basal_Media_2] AS y2012

ON {whatever keys for this tables are}

ORDER BY y2013.[SKU Number]

,y2013.[Country]

,y2013.[Year]

WHERE y2013.[Year] = 2013

AND y2012.[Year]...