Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 3,221 total)

  • RE: Compare 2 fields in the same table Using LIKE '%[fieldname]%'

    Askquestions - You have been starring at this for far too long, Now note what you entered.

    DBA John Bullock J. Bulllock ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Compare 2 fields in the same table Using LIKE '%[fieldname]%'

    Nothing much to do this evening so I will post your table structure the way you should have done it in order to receive a tested answer.

    CREATE TABLE #T (title...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Coming into a SQL 7 environment!

    Search Amazon .... Karen Delaneys Inside Microsoft SQL Server 7.0 (Mps)

    Hard Cover available as new for 0.01 .. thats right for 1 penny. Plus my search returned 30 additional...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Date Formats

    For what it is worth, here is how to return what you desire using T-SQL

    SELECT DATENAME (mm ,GETDATE()) + ' ' + CAST(DATEPART (dd, GETDATE()) AS

    VARCHAR(2)) + ', '...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: I have never tried this before.

    Without using SSIS read this for an explanation and sample code.

    http://technet.microsoft.com/en-us/library/bb522522.aspx

    If you want to use the MERGE statement in an SSIS package refer to:

    http://technet.microsoft.com/en-us/library/cc280522.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: multiple fields in 1 row

    norbertackerman

    You will be likely to get a tested answer if you post the table definitions and some sample data along with expected results following the method given in...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (10/6/2010)


    Tom.Thomson (10/6/2010)


    In my experience that is the normal frustration you should expect if you have a "project manager" in the loop who is neither a devloper nor a user...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Writing Nearly Codeless Apps: Part 1

    Steve Jones:

    However you're lucky. I've worked in quite a few shops where the DBAs did their own thing, and ignored or did not communicate with developers. I've also seen many...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Are the posted questions getting worse?

    Just have to throw my 2 cents in and help the count along ....

    Now how many members of the thread will be coming to SQL Saturday#60 in Cleveland......

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Census Track Maps for SQL Server 2008 R2 Reporting Services

    jcraddock (10/5/2010)


    Ok, I figured out how to do this...next question

    Well you going to tell the rest of us .. how?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Census Track Maps for SQL Server 2008 R2 Reporting Services

    Is this what you are seeking?

    http://quickfacts.census.gov/qfd/index.html

    or here to download a pipe delimited file via FTP

    http://factfinder.census.gov/servlet/DownloadDatasetServlet?_lang=en

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Import unprocessed rows only

    Might I suggest that you examine the MERGE statement. You can start here:

    http://technet.microsoft.com/en-us/library/cc879317.aspx

    And then if you have difficulties, repost including sample data, desired results, and the T-SQL statement(s)...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Parameter in select statement

    Deleted by poster ....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Ìnsert into temp table from excel file

    Try this site see if it helps.

    http://connect.microsoft.com/SQLServer/feedback/details/581640/trying-to-use-openrowset-to-import-2003-excel-file-into-64-bit-2008-r2-sql-server

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Microsoft reaches unprecedented levels of incompetence

    Your experience is most unusual to say the least.

    Using Goggle I uncovered 5 or 6 retailers (NOT Amazon).

    Selected CDW Direct, excepted a 5 day delivery lead...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 15 posts - 1,696 through 1,710 (of 3,221 total)