Recent content by smatthews

Hello, Is anyone using GP 10 SP5 on SQL 2008 R2 SP3 or has anyone had any issues? Thanks Smatthews

Never mind. I figured it out. Dynamics is using the .exe which has the .msp file now instead of just the .msp

This is the 1st time I have applied a patch to GP so please forgive me. I have applied SP5 to the server from my workstation and everything is fine. But when I try to apply the service pack to another workstation I am not getting a drop down for the update name. Also, the instructions say the...

Thanks again gmmastros. You are so right. The macro runs 8 different queries, some make tables, some update tables. I think your third solution is probably appropriate for this instance; it doesn't need to be but should be re-written. However, your suggestion to link and then update the sql...

Thanks gk53 That is a great suggestion. I am looking for a quick fix so linking the sql table in Access and then updating it through the Access macro seems to be the best answer for now. Eventually I want to move it over entirely to sql. Is there some way to easily move a macro into a stored...

Thanks gmmastros! I never thought of this approach... it seems like a good way to go. Smatthews

Hello all I am looking for a little guidance as to the best way to handle this job. I have an Access 2010 db. I run a macro that creates a table in Access. I need to import the table into a SQL 2005 db. So my steps are: Run Access Macro Import the table that is created into a SQL database...

There was a flaw in my logic. I needed the current and next year if the month was between 7 and 12 so I changed the query to >= datepart(yyyy,getdate()) for that line. Thanks RyanEK Smatthews

Bumping this to the top again hoping that someone can help me or maybe someone has a better way to handle this issue. Thanks, Smatthews

Sorry for the confusion, I think I need to explain rather than using the hard dates. I was giving you our fiscal year which is 10/1 to 9/30 but our chapter year runs from 7/1 to 6/30 and that is what I should have told you originally. I understand now why the dates weren't making sense. If...

I think I am way off base here but I can't seem to wrap my head around this one; here is the code, paid thru date is currently always 09/30/2013 or 09/30/2014 select id, paid_thru, getdate()as today from name where datepart(mm,getdate())between 1 and 6 and datepart (yyyy,paid_thru)+1 =...

Sorry I'm not sure how I would apply this. Can you explain further?

Hello, I am trying to create a query with a case statement with a where clause to take into account a fiscal year from 10/1/yyyy to 09/30/yyyy. For example, If the getdate month is between 1 and 6 then I need to pull people with the paid thru of 9/30/ + the current year. If the getdate month is...

Both are configured for This Account with the NetworkName\Administrator as the user.

I added the ODBC connections that I was missing on the server from my workstation but I still get the same error. They run on my workstation and the server when I run them from the Legacy folder but they won't run from either place when I run them through SQL Server Agent as a job. Any other...