Viewing 15 posts - 496 through 510 (of 3,666 total)
anthony.r.colvin (7/28/2015)
July 28, 2015 at 12:46 pm
OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
Dimensional modeling (DM)...
July 28, 2015 at 12:42 pm
sqlguy-736318 (7/27/2015)
declare @FieldVal int
while (select count(*) from @MyTempTable) > 0
begin
select top 1 @FieldVal = FieldVal from...
July 28, 2015 at 11:48 am
Eric M Russell (7/28/2015)
Iwas Bornready (7/28/2015)
Maybe in a thousand years.
If the AI robots are designed to think like humans, then hopefully they will turn on each other, killing themselves off...
July 28, 2015 at 11:39 am
SQL-DBA-01 (7/28/2015)
If the question could have been asked to check the returned value:
SELECT Value
FROM #tmpOldValue
WHERE Value NOT IN (SELECT Value FROM #tmpNewValue)
The answer would have been := 6
Please, lets...
July 28, 2015 at 9:28 am
SQLRNNR (7/24/2015)
Sean Lange (7/24/2015)
Alvin Ramard (7/24/2015)
Revenant (7/24/2015)
I cannot believe that this resulted in five pages of discussion.Thanks, Mike!
Make that 6.
Still on page 2 for me. 😛
Same here;-)
Can we drive this...
July 24, 2015 at 12:27 pm
Revenant (7/24/2015)
I cannot believe that this resulted in five pages of discussion.Thanks, Mike!
Make that 6.
July 24, 2015 at 11:08 am
This would be much easier if you could use regular expressions in SQL.
July 24, 2015 at 8:17 am
Ed Wagner (7/24/2015)
Alvin Ramard (7/24/2015)
SQLRNNR (7/24/2015)
Vimal Lohani (7/24/2015)
where is express edition mentioned in question.In the question title.
Just like many of the forum questions asked. You have to read the title...
July 24, 2015 at 8:04 am
nightowl23 (7/24/2015)
customer
product
sales
and i want to use SSIS package dynamically load data from database into three separate flat file, each table into each file.
i know...
July 24, 2015 at 8:02 am
I only read the title and got it right. 😛
July 24, 2015 at 7:42 am
SQLRNNR (7/24/2015)
Vimal Lohani (7/24/2015)
where is express edition mentioned in question.In the question title.
Just like many of the forum questions asked. You have to read the title too to get the...
July 24, 2015 at 7:39 am
rodjkidd (7/24/2015)
GilaMonster (7/24/2015)
rodjkidd (7/23/2015)
Gail, well done. Seriously impressive.I hope you are celebrating this weekend?
Taking myself and a good book to an expensive Chinese restaurant tonight. Yes, that's a celebration.
Well...
July 24, 2015 at 7:33 am
ScottPletcher (7/23/2015)
But a temp table / table variable won't begin to match the performance of a true array.
C'est la vie.
July 23, 2015 at 1:43 pm
By dropping the tables each time, you could break something that is dependencies related.
For example, you had to grant permission on a table for whatever reason. When you drop the...
July 23, 2015 at 12:00 pm
Viewing 15 posts - 496 through 510 (of 3,666 total)