Viewing 15 posts - 1,081 through 1,095 (of 2,452 total)
what do you want to return when a meeting spans over an hour segment...say for example 9.30am to 10.30am
September 17, 2015 at 10:29 am
MDB files are not split really. The data is segregated logically between MDB files so that the DB application user-interface knows exactly which MDB file to go for sequential or...
September 17, 2015 at 9:33 am
erichansen1836 (9/10/2015)
If you implement a Network database file system of 500 MDB files, each acting as a partial table within the 5 billion row database, each MDB file containing 10...
September 15, 2015 at 2:44 pm
a starter for you to consider
CREATE TABLE #NONAMETABLE(
ID INT
,column1 INT
);
INSERT INTO #NONAMETABLE(ID,column1) VALUES
(1,100.00)
,(2,60.00);
SELECT column1, column1 -...
September 14, 2015 at 3:09 pm
see how this works to start with
SELECT Personelnumber, Name, LastName,
max(case when Description = 'BaseSalary' then 'basesalary' end ) ,
max(case when Description = 'BaseSalary' then amount end) ,
max(case...
September 13, 2015 at 6:18 am
We struggle with things which I feel are fairly basic such as returning a list of 5,000 students with their highest Maths, English and Science results (the organisation in question...
September 13, 2015 at 5:26 am
Grant Fritchey (9/10/2015)
Pretty sure this is just a troll. A JET powered troll. Making up your own terms... <sigh>
is this the guy?
September 10, 2015 at 3:46 pm
for other readers....seems a similar discussion is also here
September 10, 2015 at 1:33 pm
Sean Lange (9/10/2015)
robert.chipperfield (9/10/2015)
September 10, 2015 at 10:30 am
try this....using Luis code.....all I have done is put in sample data based on what you told us.
if this isnt right....please save yourself (and us trying to help you) ...
September 9, 2015 at 1:07 pm
why dont you post some example data....would make it easier I am sure
http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
September 9, 2015 at 10:26 am
TomThomson (9/4/2015)
Eirikur Eiriksson (9/3/2015)
TomThomson (9/3/2015)
Ed Wagner (9/3/2015)
Those who have never heard of...
September 5, 2015 at 6:30 am
a test for comparisons on 1M rows
see http://blog.waynesheffield.com/wayne/archive/2011/08/running-totals-in-denali-ctp3/
SELECT TOP 1000000
ID = IDENTITY(INT, 1, 1),
Amount = CAST(Rand(Checksum(Newid())) * 99 + 1 AS BIGINT),
Type ...
September 4, 2015 at 7:09 am
another idea
SELECT
t.ID
, SUM(t.AMOUNT) OVER(ORDER BY t.ID
ROWS BETWEEN UNBOUNDED PRECEDING
AND CURRENT ROW) - T.AMOUNT AS rsum
FROM #temp AS t
WHERE(t.TYPE =...
September 4, 2015 at 4:28 am
Viewing 15 posts - 1,081 through 1,095 (of 2,452 total)