Viewing 15 posts - 1,621 through 1,635 (of 2,458 total)
Do you have some DDL (the create table statement) for ETL.STG_LETTER_RQST?
April 8, 2015 at 10:33 am
This will get you the data grouped as required.
-- sample data
DECLARE @yourtable TABLE (Clt char(5), Part char(5), Date_a datetime, Val_b decimal(8,2), percent_b varchar(6));
-- only did the first three groups...
April 8, 2015 at 10:25 am
PSB (4/8/2015)
For the interval between 8-8:30 , it's showing multiple rows2015-04-08 08:00:00.000300
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.0001150
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
2015-04-08 08:00:00.00000
should be
2015-04-08 08:00:00.000,145 ,0
I edited...
April 8, 2015 at 10:03 am
You said 15 minute intervals but your example shows 30 min. To do 15 change @interval to 15. You could also dynamically calculate the start and end dates. This should...
April 8, 2015 at 9:35 am
In what tool? Are you looking for an SSRS, SSIS or SSAS expression?
April 8, 2015 at 9:12 am
In addition to what everyone else has suggested you can use SSIS and do a loop task (if you are familiar with SSIS). This is good if you don't want...
April 8, 2015 at 8:43 am
If you can get a consulting job with a company that focuses on BI and has lots of consultants and clients I think that would be ideal. I live in...
April 8, 2015 at 8:36 am
Alan.B - You did notice that your solution truncates the average number of days right?
Yep. I'm out of gas for today. I'll post a correct solution in the morning.
April 7, 2015 at 8:32 pm
Walton (4/7/2015)
dwain.c (4/7/2015)
Walton (4/7/2015)
I have one stored procedure being called by the job that runs everyday. It generally takes 2-3 minutes to run. But sometime, for some reason it...
April 7, 2015 at 8:09 pm
dwain.c (4/7/2015)
dwain.c (4/7/2015)
-- Some nitwit posting under the moniker of Dwain.C with a big fish for an avatar
-- gave me this...
April 7, 2015 at 7:42 pm
If your server supports it you can add memory without restarting.
April 7, 2015 at 5:42 pm
Brandie Tarvin (4/3/2015)
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
April 7, 2015 at 3:48 pm
pietlinden (4/7/2015)
Yup, I noticed that... The link I posted is to an article by Pinal Dave simulating LAG/LEAD in 2008. Otherwise, I would have posted a query.
I guess he...
April 7, 2015 at 2:41 pm
Luis Cazares (4/7/2015)
Alan.B (4/7/2015)
pietlinden (4/7/2015)
Found an article at SQLAuthority that covers your options:Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function[/url]
This is 2008 forum 😉
That's why it...
April 7, 2015 at 2:33 pm
pietlinden (4/7/2015)
Found an article at SQLAuthority that covers your options:Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function[/url]
This is 2008 forum 😉
April 7, 2015 at 2:08 pm
Viewing 15 posts - 1,621 through 1,635 (of 2,458 total)