Viewing 15 posts - 316 through 330 (of 2,894 total)
karim.boulahfa (7/3/2013)
ANSWERS
Please follow the link in my signature to find how to post your question in order to attract relevant and prompt ANSWERS 😉
July 3, 2013 at 9:02 am
SELECT SchoolID
,REPLACE(REPLACE(SchoolName, '-',' - '),' - ',' - ') AS SchoolName
FROM #x1
July 3, 2013 at 8:28 am
kapil_kk (7/3/2013)
You can use LIKE keyword for this-SELECT dbo.Trnasction.Salesorder, dbo.SalesPerson.SalesPersonName
FROM dbo.Trnasction CROSS JOIN
dbo.SalesPerson
WHERE dbo.SalesPerson.SalesPersonName LIKE 'John%'
Looks good! But...
The above will return every possible transaction for the every sales person...
July 3, 2013 at 5:13 am
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...
July 3, 2013 at 4:41 am
Please stop spamming the forum!
July 3, 2013 at 4:20 am
engstevo (7/3/2013)
the script that will enable you to create the new values for each of the measures
What do you mean by that?
There are build in T-SQL datetime function to...
July 3, 2013 at 4:01 am
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,...
July 3, 2013 at 3:30 am
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.
July 1, 2013 at 9:35 am
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...
July 1, 2013 at 9:26 am
Could you please post your sql which builds dynamic SQL your INSERT INTO statement.
July 1, 2013 at 6:50 am
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...
July 1, 2013 at 6:47 am
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...
July 1, 2013 at 2:40 am
Luis Cazares (6/28/2013)
EDIT: I believe they told me to change a non-clustered index (only index on...
June 28, 2013 at 10:50 am
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]...
June 28, 2013 at 10:45 am
Viewing 15 posts - 316 through 330 (of 2,894 total)