Viewing 15 posts - 31 through 45 (of 49 total)
If you could explain how to convert to Strings within SSRS that would be helpful 😀 as I am not entirely sure how to go about that.
Thanks,
George
March 17, 2010 at 10:51 am
Never mind I figured out where the error was. The person who created the package that I inherited failed to use the text qualifier so the fields always had...
March 15, 2010 at 10:31 am
Phil Parkin (3/3/2010)
Can you clarify what you mean by 'correct order'?If possible, some sample data would probably help ... just enough to illuminate your ordering problem.
The correct order is each...
March 3, 2010 at 12:54 pm
ALZDBA (3/1/2010)
push your access project to a test sqlinstance using Microsofts Migration assistant for Access to SQL2008 and see how it handles it !This migration assistant is free !
I...
March 1, 2010 at 2:06 pm
Michael Valentine Jones (3/1/2010)
george.greiner (3/1/2010)
Michael Valentine Jones (3/1/2010)
That is not Access SQL, that is Access Visual Basic.
As with most Access it is a hybrid of Access SQL and VB... You...
March 1, 2010 at 2:03 pm
Michael Valentine Jones (3/1/2010)
That is not Access SQL, that is Access Visual Basic.
As with most Access it is a hybrid of Access SQL and VB... You write the queries in...
March 1, 2010 at 1:51 pm
Thanks again! I modified it and made it work and it actually fixed my other problem regarding the Avenues such as 73rd Avenue etc etc.
January 27, 2010 at 12:42 pm
I have run this against various addresses and everything works great! I cannot seem to convert it to an update query though and get it to function correctly. ...
January 27, 2010 at 10:42 am
Jack Corbett (11/10/2009)
November 10, 2009 at 10:37 am
Jack Corbett (11/10/2009)
How do you want the data returned?
It looks like you could do a "simple" split to get it in rows...
November 10, 2009 at 9:42 am
Jack Corbett (11/10/2009)
Can you post some sample data? See the top link in my signature for suggestions on how.
Please note that the first two lines have a HARD RETURN...
November 10, 2009 at 8:00 am
Okay so they are really there and my code must be failing =). I actually went ahead and did it a different way and am getting the results needed...
November 9, 2009 at 10:48 am
I have run the code provided by GSquared but it is not working as intended.
My resultes look as follows:
ID| 10330188
PlaceName| RIGDON MILLER & CO REAL ESTATE 1936 ...
November 6, 2009 at 7:45 am
The compatibility level is set to 80 which is apparently SQL 2000. I am finding out from the guy who set it up if there is code in there...
November 4, 2009 at 12:41 pm
Thanks again for the response! I am going to try and use the code you provided but I am getting an error when trying to run it. "Incorrect...
November 4, 2009 at 6:44 am
Viewing 15 posts - 31 through 45 (of 49 total)