Perfect! Thank you Jason.

Thanks for replying. I have the SELECT worked out but I don't know how to write multiple rows to a variable and then create the foreachloop to handle each...

Joie, using your example and the example on the web site, I came up with this working PowerShell script. Thanks again.

$ErrorActionPreference = "SilentlyContinue"

$Path = "E:\dba\powershell\online\report.txt"

If (Test-Path $Path) {Remove-Item $Path -recurse}

$date...

That makes so much more sense now that I see it.

Thank you!

I found this article which helped me accomplish what I wanted to do.

http://www.midnightdba.com/DBARant/?p=534

Thanks for the suggestion. I have tried to work it into the script like this but my PowerShell skills are weak. Should the try be looking for any error...

Thanks for responding. Unfortunately, changing the very top Static to RepeatOnNewPage = True does not cause my header row to repeat on new pages. When I advance to...

Oh I see. I was missing the style 1 on the inner convert. Needed it for both. Thanks Paul!

edit: inner was missing, not outer

Why do these give me different results? 0x80 has an even number of characters.

select CONVERT (bigint, convert(VARBINARY(20),'0x80') ,1)

select CONVERT (bigint, 0x80 ,1)

Thanks Craig, the print of the @hexbin was how I figured out to add the 0. I did not realize the issue was odd vs. even numbers but that makes...

Hi Craig, your example using style 1 worked perfectly in the other file. The new one I am working with is slightly different.

Here is my example:

...

Yes, that worked perfectly. Very impressive MM.

Some SQL Server versions have three decimal places like 8.00.2055 and some have four decimal places 10.50.1600.1.

Is padding the beginning or end of the short version numbers the best option?

Thank you MM. This is very useful information.

I appriciate the help.

Howard

opc.three (5/11/2011)

---

Jason, your solution, while it may produce the correct result, will inevitably perform very poorly when run against a large set of data. I would offer one tweak to...