Viewing 15 posts - 6,061 through 6,075 (of 7,168 total)
Fully Baked is a great one for non-techs and techs alike!
I also like "transparent". It worked in one particular shop quite well for non-techs as "don't worry, we know we...
June 16, 2011 at 11:28 am
Jeff Moden (6/16/2011)
You didn't read the entire post! 😉 I told you how to get that. Just remove the "*," from the code. 😉
Nice...and with 2 minutes to...
June 16, 2011 at 11:16 am
Have a look at the Sybase Migration Assistant provided by Microsoft:
One of the pre-reqs:
• The Sybase OLE DB provider and connectivity to the Sybase ASE database server that contains the...
June 16, 2011 at 10:48 am
princa (6/16/2011)
Lowell (6/16/2011)
June 16, 2011 at 10:45 am
ashkan siroos (6/16/2011)
Isn't there any solution without droping?
No. That's an unfortunate property of IDENTITY columns you bump up against when you want to change your schema. They are bound to...
June 16, 2011 at 10:08 am
sateswar_sahu (6/16/2011)
I've an application, which uses SYSBASE as back end. Now I want to use SQL Server 2008 and want to transfer entire database to MS SQL 2008.
I...
June 16, 2011 at 9:45 am
GilaMonster (6/16/2011)
opc.three (6/15/2011)
That's ridiculous :hehe:How does one get the engine to store -0.00 ?
Well there's a reason it's considered a data-purity form of corruption....
OK, well I feel better. At the...
June 16, 2011 at 9:44 am
carsten.jorgensen (6/16/2011)
We have now retried the changes in production enviroment - doing one step at a time and testing the application afterwards.
As soon as we changed ownership of schema...
June 16, 2011 at 9:34 am
I think you had it Thomas, save for some sorting:
-- expected results from original post for 1875 as a tabular resultset
SELECT 1589381 AS ShopID,1875 AS CurrShopID,'BUNNPRIS LAMBERTSETER' AS ShopName,1422021...
June 16, 2011 at 9:23 am
I agree, PowerShell is neat like that. I am happy you found a solution 🙂
June 16, 2011 at 9:12 am
Shawn Melton (6/16/2011)
I got a little help from Twitter, well alot of help actually...
Hmmm...maybe I need to plug in over there...I have never used Twitter for tech questions.
Can you explain...
June 16, 2011 at 8:57 am
Wow...you're still asking for rope 😛
If all your data follows your example data and all you're trying to do is account for a missing 'BLVD' here and there you can...
June 15, 2011 at 10:49 pm
PostgreSQL (PGS) actually offers a far more feature-complete database engine than MySQL. In terms of PGS's query optimizer, locking mechanisms, push for ANSI-SQL compliance and language features/extensions it rivals, and...
June 15, 2011 at 10:38 pm
The question comes up on these forums regularly and and trying to match addresses using T-SQL language features is a losing proposition. Now that you have revealed more about what...
June 15, 2011 at 9:57 pm
Cool (that you got it working, not that syntax ;-)) thanks for posting a solution!
June 15, 2011 at 6:53 pm
Viewing 15 posts - 6,061 through 6,075 (of 7,168 total)