Viewing 15 posts - 53,086 through 53,100 (of 59,064 total)
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
Heh... deletes make me nervous, anyway... constitutes some form of lost data. I don't use cascade deletes because I want people to have to work at doing deletes. ...
January 4, 2008 at 9:19 pm
If memory serves correctly, I believe that form of index hint is "deprecated". Try this, instead...
select ACCT_NUM, OPERATOR_NUM, BRANCH_NUM
from TRANS_J_DATA_FULL WITH (INDEX(IX_TRAN_FULL))
where TRANS_DATE >= @dStartDate and TRANS_DATE <= @dEndDate...
January 4, 2008 at 9:16 pm
Don't use either... use the functions built for this...
1. Check if temp table exists...
IF OBJECT_ID('TempDB..#temptablename','U') IS NOT NULL
PRINT 'Table Exists'
...
January 4, 2008 at 8:38 pm
Heh... in other words, there's no such thing as a Julian date of "107999"... can only go up to 107365... next day would be 108001.
With that in mind, the following...
January 4, 2008 at 8:13 pm
Viewing 15 posts - 53,086 through 53,100 (of 59,064 total)