Is Yoda deciding on the order of these posts? Confused, I am.

Although the second answer produces the correct age for most, if not all, people, the FLOOR function returns the same datatype as is used within the function which is DECIMAL.

This...

The attached files contain the setup of tables of the 100 most common digrams and the most common 98 trigrams from the English. There is also the function fnObfuscate which...

I've located a list of all Unicode references available from

http://www.alanwood.net/unicode/#links

to help to translate the characters outside of the ASCII range.

What a nightmare of a document!!

From what I can gather the #x???? is a Hex reference to a unicode/ascii character; with those illegal characters being non-printable or refering to characters...

If companies are too worried about their code being opened up to the public perhaps, in legal cases, the code can be disclosed to the Expert Witnesses on both the...

You can use the Type command through the xp_cmdshell in conjunction with SET ROWCOUNT

SET ROWCOUNT 1

CREATE TABLE #temp (line VARCHAR(4000))

INSERT INTO #temp

EXEC master.dbo.xp_cmdShell 'Type \\myPC\mydirectory\myFile.csv'

SET ROWCOUNT 0

This will import the...

Can you attach the data in a txt file please?

You're example appears to be blank to me?!

Hi Loner,

If you think about it, when you've been looking things up on the internet you've been learning more and more about SQL Server 2005; probably without realising. You should...

It sounds as though your sp_OACreate execution is failing. Run: EXEC sp_OAGetErrorInfo after each EXEC statement to return the errors. You could also use Print @sh to make sure that...

Before SQL Server 2005 you had to use a number of CASE statements to get anywhere near a Pivot table style result :crazy:. In 2005 they introduced the operator clause,...

Hi,

Have a search about for the ServerXMLHTTP.4.0 object on Google (other search engines are available!! :D). This object allows you to send HTTP GET and HTTP POST request in ActiveX...

E,

Which bit doesn't work? The stripping of spaces?

You could always run UPDATE statements to trim trailing spaces... It's not an elegant solution but would provide A solution.

UPDATE JobTable SET...

The format file should ignore any spaces that are over the specified length; sadly I don't think that it'll strip out spaces such as (using the 0s for spaces again...