Viewing 15 posts - 4,171 through 4,185 (of 8,731 total)
This is a slightly different way. But it will also give different results depending on the data.
Be sure to know what you want.
WITH BASE_DATA AS
(
SELECT
...
September 18, 2015 at 12:22 pm
It depends.
If you're inserting on a table, you might not want to read from it until you finish your insert, unless you don't want to use the inserted rows.
If...
September 18, 2015 at 11:54 am
Kristen-173977 (9/18/2015)
Eirikur Eiriksson (9/18/2015)
I've found the method I use for timing more accurate than the time statistics
Ah ... 🙂 Not to dis Luis or anything, but when I ran...
September 18, 2015 at 11:43 am
Stuart Davies (9/18/2015)
djj (9/18/2015)
BL0B_EATER (9/18/2015)
whereisSQL? (9/18/2015)
Luis Cazares (9/18/2015)
BL0B_EATER (9/18/2015)
anthony.green (9/18/2015)
BL0B_EATER (9/18/2015)
Ed Wagner (9/18/2015)
anthony.green (9/18/2015)
Stuart Davies (9/18/2015)
Eirikur Eiriksson (9/18/2015)
SQLRNNR (9/17/2015)
DTAdistrust
circumspect
reckless
Driving
Fast
Limit
stop
GO
Green
Hornet
Sting
Police
Roxanne
September 18, 2015 at 9:27 am
This post has good suggestions as well: http://www.sqlservercentral.com/Forums/FindPost1718291.aspx
September 18, 2015 at 9:06 am
The main or basic book you should read to learn the concepts of data warehousing is: The Data Warehouse Toolkit[/url]
It's a great book.
September 18, 2015 at 8:22 am
BL0B_EATER (9/18/2015)
anthony.green (9/18/2015)
BL0B_EATER (9/18/2015)
Ed Wagner (9/18/2015)
anthony.green (9/18/2015)
Stuart Davies (9/18/2015)
Eirikur Eiriksson (9/18/2015)
SQLRNNR (9/17/2015)
DTAdistrust
circumspect
reckless
Driving
Fast
Limit
stop
GO
September 18, 2015 at 7:26 am
You're welcome. Be sure to understand it and ask any questions that you might have.
I added an additional row and column to show totals.
September 18, 2015 at 7:11 am
September 18, 2015 at 6:43 am
You can use WITH ROLLUP, GROUPING SETS or other GROUP BY options.
More info: https://technet.microsoft.com/en-us/library/bb522495(v=sql.105).aspx
September 18, 2015 at 6:37 am
The following article will show you how to work with dynamic pivots and cross tabs. http://www.sqlservercentral.com/articles/Crosstab/65048/
I usually use a different method for concatenation than the one explained in the article....
September 18, 2015 at 6:33 am
You could use the Import/Export Wizard to dynamically create the package to handle all the sheets in the workbook and create the tables.
What seems weird is that you mention different...
September 17, 2015 at 1:05 pm
It's not to move away from selects and unions as those will still be of use. It's more about keeping it simpler.
September 17, 2015 at 12:49 pm
Phil Parkin (9/17/2015)
Steve Jones - SSC Editor (9/17/2015)
Brandie Tarvin (9/17/2015)
September 17, 2015 at 12:10 pm
JKSQL (9/17/2015)
INSERT INTO @Temp
SELECT * FROM (SELECT @QuantityID as ID UNION
SELECT @LengthID UNION
SELECT @CostID) Temp
WHERE id is not null
Better idea than this?
Using a table value constructor?
INSERT INTO @Temp
SELECT...
September 17, 2015 at 11:18 am
Viewing 15 posts - 4,171 through 4,185 (of 8,731 total)