Viewing 15 posts - 1,456 through 1,470 (of 2,452 total)
any reason why Access shpuld have to start Agent Job?....cant the job be scheduled to run every n mins?
how long does the job take anyway?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 1:59 pm
are the users in access using hardcoded connection strings (in Access) to connect to SQL...if so can you please provide example?
what authentication method are you using for SQL?
does the Access...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 1:03 pm
something to play around with
SELECT TOP 1000000
TranID = IDENTITY(INT, 1, 1),
TypeID = 1 + CAST(Abs(Checksum(Newid()) % 999 ) AS INT),
variant ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 12:18 pm
could you perhaps provide some sample table and data scripts to better understand?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 10:53 am
logitestus (5/8/2014)
Secondly, I do apologize if I performed an epic-fail on trying...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 9:34 am
ChrisM@Work (5/8/2014)
SELECT *, Trend = ([Week]/5.0) * MAX(Forecast) OVER(PARTITION BY [TYPE])
FROM #REport
Which exactly meets your requirements (apart from the trivial matter of rounding) but...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 9:04 am
just to be sure.....can you please provide the actual results you require based on your sample data......and not the calcs.
ta.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 8:41 am
Hi Jeff
I had forgotten about this...thought I had posted some results, but seems not....so
/* do some updates*/
/*create temptable to store start and end times*/
CREATE TABLE #Results (
Comment VARCHAR(20)
, StartTime...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2014 at 5:35 am
select CONVERT(varchar(6), getdate(), 112) +'01'
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2014 at 1:50 pm
though this doesn't directly answer your method.....I think that the following
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
may provide some alternative ideas......
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2014 at 11:46 am
vigneshkumart50 (5/7/2014)
like this'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Total_Amount,2)/12 as MONEY),1), '.00', '') as Monthly_Amount,
why CAST as MONEY and then REPLACE....couldn't you just cast as INT?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2014 at 4:26 am
maybe something like this will help ?
SELECT Customer,
MAX(case when YEAR(ReceivedDate) = 2014 then 1 else 0 end ) as thisyear,
MAX(case when YEAR(ReceivedDate) = 2013 then 1 else 0 end )...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2014 at 6:29 am
does the following get anywhere close
SELECT '$ ' + CAST(CAST(Round(SUM(Current_Year),0) as INT) -
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2014 at 1:20 am
Lynn Pettis (5/3/2014)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 3, 2014 at 11:54 am
here is a simple set up script....please use this as a method to provide suitable data for us to help you.
USE [tempdb]
GO
CREATE TABLE [dbo].[boxes](
[boxid] [int] NOT NULL
)
CREATE TABLE [dbo].[widgets](
[boxid]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 2, 2014 at 11:56 am
Viewing 15 posts - 1,456 through 1,470 (of 2,452 total)