[p]I just felt compelled to answer this as I needed to try out various ways of getting code into the new forum, so I could alter the Simple-Talk Prettifier to...

How do you then save a VarBinary(MAX) image as a valid graphic file?

The whole subject is one I get all excited about since I live in an old 'disused' watermill, and I'm listening to the water thundering through the wheelpit as I...

Er.. The temporary table had an identity column in there that was intended to ensure precisely this. ...

Have a look at the SQL Server cusrsor workbench on

http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-cursor-workbench/ which discusses the 'Running total' problem

If you look at the 'Quirky Update' solution, this should tell you the quickest...

CREATE TABLE #Dates

(

   MyId INT IDENTITY (1,1),

   TheDate Datetime)

INSERT INTO #dates(

Where I've had to deal with this sort of problem in the past, and it is difficult to avoid them if you are dealing with the output of engineering test...

declare @TableName nvarchar(50)

set @TableName = 'stg.dbo.Disposal'

select count(*) from @TableName

go

In the first case you declare a nvarchar called @Tablename and then you treat it as though it were a table variable....

/* to make this work, you will need a number table. If you don't know about them, see http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/ Also I'm assuming you have SQL...

Thanks Jonathan.

As far as I can see, this is an aggregation of data into arbitrary date/time slices (defined by a start and end date) in such a way that each...

I realise I'm drifting off-topic here, but I'm struggling to understand the SQL. In what circumstances would one adopt this particular LEFT JOIN construction, with an ambiguous ON join-criterion, particularly without checking...

Pop Rivett's SQL Server FAQ No.5: Pop on the Audit Trail is a popular introductory article on the technique

Having read this post I nervously looked in the mirror. Yes, phew, there is only one Phil Factor. Yes, I did pop over to Red-Gate to meet Steve, and can assure nervous...

I've always greatly admired the DBA toolkit, and found the criticism of Mr Wooton very amusing. Well, I assume it was tongue-in-cheek. Even if it wasn't useful, it is great...

Without any hesitation I'd recommend ABBYY Finereader. I've used it for years, even on typewritten stuff, and it has never let me down. I've scanned-in entire books. It is uncannily...