Viewing 15 posts - 10,456 through 10,470 (of 13,879 total)
Lynn Pettis (9/7/2012)
Phil Parkin (9/7/2012)
In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised...
September 10, 2012 at 9:39 am
Do you mean a folder containing multiple .sql files?
September 10, 2012 at 1:44 am
Surely the Execution Plan would be a better place to start, if performance optimisation is your goal?
September 8, 2012 at 12:11 am
Lynn's solution is the way to go.
In her solution, basedata is a CTE - effectively a subquery in this case - from which the normalised data is being selected.
If...
September 7, 2012 at 8:27 am
Please provide some code which exemplifies this. And explain why you need to do this and what you are expecting.
September 7, 2012 at 5:10 am
I think that error is happening because the worksheets in the Excel files have different names. Presumably it's called 'SALES' in the one which is getting loaded and something else...
September 7, 2012 at 2:20 am
Ah yes, thanks guys.
Note to self: read more carefully next time 🙂
September 6, 2012 at 8:47 am
mssqlsrv (9/6/2012)
I think you can not use variable in order by clause.Variables are only allowed when ordering by an expression referencing a column name.
Yeah you can. Just tried this and...
September 6, 2012 at 8:33 am
Robin Sasson (9/6/2012)
September 6, 2012 at 3:41 am
Derived columns in SSIS do not use T-SQL syntax - they use SSIS Expression syntax, which is a bit like C#. So no selects, converts etc. You just need to...
September 6, 2012 at 3:32 am
Use the SUBSTRING() function.
Have a try and post back with how you get on.
September 6, 2012 at 3:03 am
1) Break down into multiple queries.
2) Use fewer characters.
3) Call a parameterised stored proc to do the work for you.
September 6, 2012 at 3:00 am
bhushan_juare (9/5/2012)
September 5, 2012 at 9:42 am
zyzy (9/4/2012)
Take a good look at your table columns, you might be converting a non date type to date datatype
You just answered a post which is three years old... 🙂
September 5, 2012 at 3:39 am
Just clarifying what you mean by 'external components' - I presume you are including SSIS and SMO routines?
August 31, 2012 at 1:55 am
Viewing 15 posts - 10,456 through 10,470 (of 13,879 total)