BOL 2000: Select statement

INTO Clause

Creates a new table and inserts the resulting rows from the query into it.

After the successfull execution of the first SELECT INTO, the second select should...

Had the "Connection Broken" part when SQL really gets confused in 6.5 and 7.

Did you try a "DBCC CHECKDB" just in case.

Select DATENAME(dw , Cast('2003-07-27 23:55:02.093' as DateTime))

Don't have to do the cast bit!

Also check NT eventlog!

Not answering your question completely, but did a pilot project last year on a under resourced box and a view was handy to throttle the available data to Analysis Server....

Andy, if one can only attend one conference per year(paying myself, obviously SQL). Which one, preferably a bit more 'advanced'?

Still Pass?

May help a bit

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=502&lngWId=5

Have a look at "EBCDIC2ASCII"

Interesting "A2ROMAN" -> Converts an arabic numeral to roman, as a string.

Where did you notice the 'spot_' system procedures

Good question

BOL 2000:

On a clustered index, the DROP INDEX statement must rebuild all nonclustered indexes. SQL Server must also replace the clustered index keys in the nonclustered...

jpipes 10 out of 10 for effort.

For a start you got rid of the cursor and paras_98 can continue with the reworked code.

Some fractions end as a repetitive binary fraction (mantissa/exponent stuff).

If my memory serve my right .1 an example.

-- Should do the job

Backup Database MYDATABASE to disk = '\\TDAMachinename\ShareName\pubs_20030722.bak'

-- Actual sp_addumpdevice

USE master

EXEC sp_addumpdevice 'disk', 'networkdevice','\\TDAMachinename\ShareName\pubs_20030722.bak'

Multi : http://www.tutorialfind.com/tutorials/software/crystalreports/

VB : http://www.vbexplorer.com/VBExplorer/vb_feature/august2000/using_crystal_reports.asp

ASP : http://www.thinkydink.com/crystal.html

Agrees with jpipes, get rid of the cursors. Cursors only as a last resort.

Have a look at http://support.microsoft.com/default.aspx?scid=314530