Viewing 15 posts - 57,211 through 57,225 (of 59,059 total)
I'm not seeing the pattern here... can you explain how you came to the actions you took and why you need to do the INSERT to begin with? What do...
November 24, 2006 at 4:17 pm
Yes, there are some concerns...
SQL Injection Attacks
Poor performing code due to recompiles because is really 100% dynamic SQL
Poor performing code because it's written by GUI experts who might not be...
November 24, 2006 at 4:11 pm
Thanks for taking the time to provide the belated feedback
Lot's of times, you wonder if someone died or what?
November 24, 2006 at 4:02 pm
This would work...
SELECT *
FROM dbo.PostalCodes P WITH (NOLOCK)
WHERE SQRT(
POWER((69.1 * (P.Latitude - @Lat1)),2.000)
+ POWER((53 * (P.Longitude - @Long1)),2.000)
) <= @Distance
...but I believe this only works...
November 20, 2006 at 9:42 pm
Cool... thanks for the feedback, Mick.
November 17, 2006 at 8:12 am
"SysDate"
"Months_Between"
Are you trying to do this in Oracle or SQL Server?
November 16, 2006 at 8:53 pm
DTS the production tables to a development database.
November 16, 2006 at 8:48 pm
David,
Tomakeiteasiertotroubleshootyourcodeyoushouldadoptandfollowaformattingstandardthatincludesthepropercasingpunctuationandindention
Intheprocessofformattingyourwillfindthatmanyproblemswiththecodewillsimplyvanishbecauseyouwillbelookingatthecodemorethanonceaswellasit
beingeasiertounderstandforevenyou.
November 16, 2006 at 8:46 pm
I think the reason you've had no luck with the other post is because most of the folks on this forum will likely tell you that storing images in the...
November 14, 2006 at 6:21 pm
I expected the 3 tier purists to come out of the woodwork... for some reason, they seem to prefer doing the "business logic" without using stored procedures. I'm just the...
November 14, 2006 at 8:19 am
No, sorry... in order to guarantee that the pages don't overlap or repeat, you need something to absolutely guarantee the uniqueness of each row... and it doesn't necessarily need to...
November 14, 2006 at 8:11 am
Better than that, post the raw data as it appears in the file for the first 3 systems...
November 13, 2006 at 7:03 pm
Heh... let's hear it for progress... pay more, get less. Gotta love that ![]()
November 13, 2006 at 7:00 pm
Heh... I know what you mean... my Co hired me because they were an Oracle shop suddenly thrust into the world of SQL Server
November 13, 2006 at 6:31 pm
| ...and corresponded with two of the individual members of that ISO board. They informed me that their ISO was intended for Metadata only... |
November 13, 2006 at 6:01 pm
Viewing 15 posts - 57,211 through 57,225 (of 59,059 total)