Viewing 4 posts - 16 through 19 (of 19 total)
Replace:
T_OrderHeader.CONVERT(varchar(11), OrderDate, 106),
With:
CONVERT(varchar(11), T_OrderHeader.OrderDate, 106),
July 7, 2008 at 10:25 pm
#839259
See also another link http://www.dak-tek.dakotta.com/Country_City_State_List.htm to buy from.
Not all countries use the concept of 'State'. If you are trying to capture an address then you may also need...
June 11, 2008 at 12:41 am
#827077
How many records would you expect to be returned?
GUI design suggests that a Listbox would not have a very large number of records so should be very fast to populate.
Try...
June 10, 2008 at 5:49 pm
#827012
I am not aware of any tool that could convert the stored procs.
Looking through Google there are some that can convert tables, etc.
Stored procs only appeared fairly recently in MySQL...
April 18, 2008 at 12:09 am
#804104