Viewing 15 posts - 1,921 through 1,935 (of 2,458 total)
I cleaned up your sample data and came up with a not so optimal solution . This can be greatly improved by removing the need for the DISTINCT clause. Using...
July 8, 2014 at 3:55 pm
To add Nevyn...
SSAS is one of the three core products that are considered part of what is commonly referred to as the "Microsoft BI Stack". You mentioned SSIS and SSRS;...
July 8, 2014 at 2:55 pm
JeepHound (7/8/2014)
July 8, 2014 at 10:59 am
Jeff Moden (7/2/2014)
Alan.B (7/2/2014)
Sean Lange (7/2/2014)
July 3, 2014 at 8:15 am
Sean Lange (7/2/2014)
July 2, 2014 at 1:54 pm
I think you are looking for this:
-- (1) create sample data
DECLARE @values TABLE
(FISCALYEAR int not null,
ACCTPERIOD int not null,
TrialBalanceDebit decimal(16,5) not null,
POSTINGTYPE varchar(20) not null
);
INSERT @values VALUES
(2014, 201401,...
July 2, 2014 at 12:53 pm
New Born DBA (7/1/2014)
Alan.B (7/1/2014)
You can get this information from msdb.dbo.backupset
SELECT name,description,
user_name,
database_creation_date,
backup_start_date,
backup_finish_date,
backup_size,
database_name,
server_name,
machine_name
FROM msdb.dbo.backupset
Thanks. It gave me all the details.
I also right clicked on the backup set -->properties and then...
July 1, 2014 at 11:10 am
You can get this information from msdb.dbo.backupset
SELECT name,
description,
user_name,
database_creation_date,
backup_start_date,
backup_finish_date,
backup_size,
database_name,
server_name,
machine_name
FROM msdb.dbo.backupset
July 1, 2014 at 10:14 am
Most people watch a lot more television than six hours per week. What do I do with that time instead? I read books and blogs. I "tinker" with SSIS and...
June 26, 2014 at 2:13 pm
That makes sense. No point evaluating all the 10,000 rows when they won't meet the condition anyway. I suspect if we changed my original (with the STUFF) it would perform...
June 25, 2014 at 2:17 pm
Sean Lange (6/25/2014)
Alan.B (6/25/2014)
First: Dang it Sean - you beet me to it! I had a very similar solution but you posted yours first. That said, I did do a...
June 25, 2014 at 1:45 pm
Gents
First: Dang it Sean - you beet me to it! I had a very similar solution but you posted yours first. That said, I did do a performance test and...
June 25, 2014 at 11:23 am
Eugene Elutin (6/20/2014)
Alan.B (6/19/2014)
Eugene Elutin (6/19/2014)
SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)
Yep,...
June 20, 2014 at 9:12 am
Eugene Elutin (6/19/2014)
SUBSTRING is more standard than PARSENAME so the code would be more portable using SUBSTRING (for those people that care about that stuff :-P)
Yep, as long you...
June 19, 2014 at 12:14 pm
Eugene Elutin (6/19/2014)
June 19, 2014 at 10:12 am
Viewing 15 posts - 1,921 through 1,935 (of 2,458 total)