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?

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...

something to play around with

SELECT TOP 1000000

TranID = IDENTITY(INT, 1, 1),

TypeID = 1 + CAST(Abs(Checksum(Newid()) % 999 ) AS INT),

variant ...

could you perhaps provide some sample table and data scripts to better understand?

logitestus (5/8/2014)

---

First off, I want to say how much I do appreciate those of you who are helping me.

Secondly, I do apologize if I performed an epic-fail on trying...

ChrisM@Work (5/8/2014)

---

Otherwise you will get answers like this:

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...

just to be sure.....can you please provide the actual results you require based on your sample data......and not the calcs.

ta.

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...

select CONVERT(varchar(6), getdate(), 112) +'01'

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......

why CAST as MONEY and then REPLACE....couldn't you just cast as INT?

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 )...

does the following get anywhere close

SELECT '$ ' + CAST(CAST(Round(SUM(Current_Year),0) as INT) -

...

Lynn Pettis (5/3/2014)

---

If, while closing a tab, you do not save the sql code contained in the tab it is lost. There is no reopening a previous tab to...

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]...