Hi Paul ,

IMO SSIS is a bit of a beast and has quite a steep learning curve.

You can email direct from sqlserver though , i would suggest taking that route...

How about creating a view ?

Create View MasterView

as

Select Col1,Col2,Col3...

As a general rule of thumb , to quote Michael Rys (MS XML SqlServer

program manager)

http://www.itwriting.com/sqlxml.php

"If your data fits the relational model, you’re probably better off probably still taking the XML...

Please see convert in BOL for other 'styles' of conversion

Jeff Moden (8/20/2009)

Now... that's an interesting, different, and simple way to isolate the delimiters... and I'm not talking about the use of a numbers/Tally table. Thanks, Dave... I've got...

What makes you think that substring returns words ? It returns characters ?

Try This

declare @MyString varchar(255)

select @MyString ='one two three four five'

;with Num1 (n) AS (SELECT 1 UNION ALL SELECT...

But WHICH exit row for WHICH entry row ?

Presumably 'Bob' will enter and...

Try this link

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Sorry , but you are going to have to provide more detail ? I really dont understand what you want.

Please provide test data and an example of the data you...

Which is correct because you have not specified a scale in the decimal. Check Bol

select CAST(0.5 as decimal)

select CAST(0.5 as decimal(10,5))

Then what is the...

between does greater than or equal to and less than or equal to , so from what you've said ,"returned records whose start time is 20/08/2009 10:00:00", SQL seems to...

Yup , no magic mystical powers involved 🙂

http://en.wikipedia.org/wiki/Unix_time

its because youve used float as your column definition , which by definition will contain an approximate value.

from bol

Approximate numeric data types do not store the exact...

try

select @COUNT = count(*) from tablename where last_name = 'Brown'