Search results for query: *

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

Thanks Doug. Working on it now. Will keep you posted. Smatthews

Hello, We recently upgraded from SQL2k to SQL2005 and our DTS packages, we have two, run fine when I run them right from the Legacy folder created when we converted them after the upgrade but fail when they run as a job. This is the error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does...

Thank you.

It appears that we lost the user name who was logged in at the time too. This must have also been a constraint. Is it possible to pull the sql user who make the change as a constraint? Thanks.

So sorry...was looking at an old query...looks great! Thanks for hanging in with me.