Forum Replies Created

Viewing 15 posts - 16 through 30 (of 56 total)

  • RE: Combine multiple rows into single output

    Ran into the same issue here. This function causes my query to literally be 15 times slower. Going from under 1 second to over 15.

    Haven't found a work around yet.

  • RE: ipad or kindle

    There are a couple pretty good applications out there that can convert most formats to the kindle. I even use mine to read comics (no color does suck but better...

  • RE: Reference a view in a foreign key

    opc.three rocks it again!

  • RE: ipad or kindle

    I have a kindle and I love it. As was said - battery life is literally weeks per charge. Very easy on the eyes as well. I use it just...

  • RE: SQL 2008r2 Upgrade from 2005 Fails

    I've been battling the same thing. It happens to me on a fresh install on a Win 7 32 bit machine.

    I can't find anything that works. You'd think it be...

  • RE: Day Zero with PowerShell

    Good stuff! Wish I had found this article a year ago. I struggled getting started before. I hope this helps people just getting their feet wet.

  • RE: way to check if windows auth user is real?

    What do you think is the best way to handle that error then? I'm just writing this for my own personal growth so I don't have a security team to...

  • RE: way to check if windows auth user is real?

    Nope. Have you ever used sp_validatelogins? It tells you what logins you have on your server aren't in your AD. I'm looking for the opposite.

    I am not sure there...

  • RE: Excel ignoring text during import

    Alright. Talk about monstrous journey into unknown territory.

    I finally figured out the what was the matter. It had nothing to do with the spreadsheet. It had everything to do...

  • RE: Excel ignoring text during import

    Dreaded Msg 7303!!!

    OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".

    Msg 7303, Level 16, State 1, Line 1

    Cannot initialize the data source object of OLE DB provider...

  • RE: Excel ignoring text during import

    Sorry about that.

    Here is what solved my problem:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DevWork\ExcelTest\Example_SS.xls;Extended Properties="EXCEL 8.0;HDR=NO; IMEX=1"

    ""IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this...

  • RE: Excel ignoring text during import

    FINALLY!!!

    I got it.

    Check this out

    This worked perfectly.

    I guess I need to read more about excel's extended properties.

  • RE: Excel ignoring text during import

    Thanks for the reply. I was able to use the openrowset with Microsoft.Jet.OLEDB.4.0

    SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

    'Data Source=C:\DevWork\example_ss.xls;Extended Properties=Excel 8.0')...[Sheet1$]

    When I added your updates I got this:

    OLE DB...

  • RE: Excel ignoring text during import

    Here you go. It's not the same one I am using but I am getting the same results when importing this spreadsheet.

  • RE: 1 quad core processor enough for enterprise 2008?

    Thanks for the replies. I knew I was opening up a can of worms even mentioning IIS and SQL on the same machine.

    I've stated my concerns to those in...

Viewing 15 posts - 16 through 30 (of 56 total)