Viewing 15 posts - 1,291 through 1,305 (of 1,825 total)
As Jeff Says a tally table will be the best way,
Simply Add (TallyNum *15) minutes to your starting time.
Give it a try and let us know how you get on.
November 2, 2009 at 2:40 am
Should you need the sample tables, I will provide as soon as requested.
Lets have it then, im still not 100% clear on what you would be expecting as your...
November 2, 2009 at 2:02 am
(SELECT OrderTypeId FROM LookUp Where OrderType = 'X')
Will return a constant value , so why not use the constant ?
November 2, 2009 at 1:50 am
martin.edward (11/2/2009)
/** This results in a BOM Tree, Which is not accurate as it does not digress into
the grandchild items i.e. the child of the child items and so on...
November 2, 2009 at 1:42 am
Might i also suggest you dont want the output as
8:15 ,8:30,8:45,9:00,9:15,9:30,9:45,10:00,10:15,10:30,10:45,11:00
More like
8:15
8:30
8:45
9:00
........
10:45
11:00
As at some point you will need to join this table back to an 'existing appointments' table.
November 2, 2009 at 1:35 am
Why is scratching my car not a capital offence ?
October 31, 2009 at 9:33 am
Basically it will be indeterminate. If could arrive in any order. If you need a specific order then you HAVE to specify order by.
October 31, 2009 at 9:31 am
Sounds similar to the stock issue on Phil Factor's latest challenge.
Have a look here and see if you might be able to adapt it to your needs.
Edit : Although it...
October 31, 2009 at 9:28 am
Lynn Pettis (10/30/2009)
something like this:
Would be spot on i would imagine 🙂
October 30, 2009 at 9:50 am
Performance will be better when inserting using included columns as no sort operation etc will take place on them. If they are only in the index to...
October 30, 2009 at 9:43 am
When you INCLUDE columns they are not ordered.
October 30, 2009 at 9:26 am
Personally, i would calculate the number of seconds from 01jan1970 you are interested in and
select * from tblTest where time between X and Y
October 30, 2009 at 9:24 am
Something like this ?
create table #Service
(
StartDate smalldatetime,
ServiceInterval integer,
EndDate smalldatetime
)
go
insert into #Service values('2009-10-26 00:00:00.000',1,'2010-10-26 00:00:00.000')
insert into #Service values('2009-10-20 00:00:00.000',2,'2010-10-20 00:00:00.000')
go
with cteInterval
as(
select number from
master..spt_values
...
October 30, 2009 at 7:14 am
Hi Can you supply the DDL and sample data , with the expected output to?
October 30, 2009 at 5:14 am
Try this
Select * from inventory B1Inventory
left join inventory OtherBranchInventory
...
October 30, 2009 at 3:15 am
Viewing 15 posts - 1,291 through 1,305 (of 1,825 total)