Viewing 15 posts - 53,086 through 53,100 (of 59,068 total)
Phil,
Nothing attached and no code visible... dunno if that was your intent, or not...
January 5, 2008 at 9:07 am
The only problem I see in such a naming convention is if you have a usefull function, proc, table, or view that is used in one schema that you'd like...
January 5, 2008 at 9:04 am
p.s. IF, by chance, you are using the V&H coordinates (as Telcordia calls them) from the "Donald Projection" that is used so often for calculating distance for telephony, airlines,...
January 5, 2008 at 8:54 am
SQRT and SQUARE are standard mathematical functions in pretty much every make and flavor of SQL including SQL Server.
Your values of the coordinates of x1, x2, y1, and y2 can...
January 5, 2008 at 8:43 am
You might also be able to use something like OPENDATASOURCE...
January 4, 2008 at 10:18 pm
I'm thinking that if inheritance did exist in SQL Server, it would create a "work" table in TempDB, anyway... what's so terrible about using INSERT/EXEC to populate a temp table...
January 4, 2008 at 10:16 pm
I'd start a new thread with a new subject... will probably get more attention that way...
January 4, 2008 at 10:06 pm
Probably easiest to write a pass-through query (maybe to a view) in Excel and print from Excel.
January 4, 2008 at 10:05 pm
Ok, thanks for the feedback... does that mean that you're all set?
January 4, 2008 at 9:58 pm
Assuming that "TimeElapsed" is of the DateTime datatype...
SELECT currDt = GETDATE()-TimeElapsed
January 4, 2008 at 9:46 pm
3 pages starting at...
http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx
January 4, 2008 at 9:37 pm
Incomplete sentence... "Which scripting language does..."
What's the rest of that?
January 4, 2008 at 9:29 pm
Heh... "google it" !
January 4, 2008 at 9:28 pm
And then there's the subject of primary keys... especially if they're based on IDENTITY.
January 4, 2008 at 9:27 pm
Viewing 15 posts - 53,086 through 53,100 (of 59,068 total)