Forum Replies Created

Viewing 15 posts - 1,231 through 1,245 (of 5,502 total)

  • RE: divided by zero error

    You could use

    /(NULLIF(sil.[Quantity],0))

    This would cause a divide by NULL which will return NULL.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 4:59 pm

    #1353898

  • RE: where syntax

    Because there was no match?

    We can't see what you see nor do we have the data available you're testing against.

    But most probably it is cause by the non-unicode data type...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 2:52 pm

    #1353881

  • RE: Sql data intact, but can't display in application

    If you want to run it permanently on your prod server I recommend to go to the next level: server side trace.

    But what I meant originally was to set up...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 7:49 am

    #1353844

  • RE: Error connecting to database.

    saurav.rukd (7/16/2011)

    i solved it..Thaks

    Great. Care to share what you did to solve it so others may benefit?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 7:27 am

    #1353841

  • RE: T-SQL script

    unfortunately, the data are not ready to use.

    Please have a look at the first link in my signature on how to post sample data.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 7:15 am

    #1353839

  • RE: Sql data intact, but can't display in application

    Here's a link that might help you to get started using SQL Profiler:

    http://sqlserverpedia.com/wiki/Using_SQL_Server_Profiler


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 6:17 am

    #1353835

  • RE: Sql data intact, but can't display in application

    So, if you select the data using Management Studio, the data are there but when you try to query it via the app, the data cannot be displayed? Weird, indeed.

    You...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 5:45 am

    #1353830

  • RE: Service Broker

    http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/

    http://www.sqlservercentral.com/articles/Development/anintroductiontotheservicebroker/1957/

    http://rusanu.com/articles/

    Easier than using google, isn't it? 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 5:03 am

    #1353824

  • RE: Sql data intact, but can't display in application

    Does the table have a IDENTITY column? If so, are the values stored in that column for the period in question consecutive? If so, the data (most probably) were never...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 4:59 am

    #1353823

  • RE: inner join/union across multiple tables

    You could also replace UNION with UNION ALL since due to the different values for s.objecttype in each UNION statement there isn't any need to check for duplicates.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 4:50 am

    #1353822

  • RE: T-SQL script

    There were more than 40 people so far looking at the issue you posted.

    Even though you did a fine job to present table definitions, some of us refuse to open...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 3:00 am

    #1353816

  • RE: How to split a record into two records?

    Would something like the following help you to get started?

    DECLARE @tbl TABLE

    (

    PNO CHAR(3),Injury INT,Theft INT, Selfharm INT

    )

    INSERT INTO @tbl

    SELECT 'ABC', 1, 1, 0 UNION ALL

    SELECT 'XYZ', 1, 0, 0...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 2:56 am

    #1353815

  • RE: Single table row-column comparison issue

    The most important thing is to find the pattern.

    It certainly would help to get a longer list of values where the rows to find are already identified including a short...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 2:48 am

    #1353814

  • RE: How to get count for week range?

    Jeff Moden (7/15/2011)

    Except for in a function or view where you can't actually use a SET statement, I have no problem with the idea of setting DATEFIRST to whatever I...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 16, 2011 at 2:35 am

    #1353813

  • RE: Gerenciador de relacionamentos entre tabelas

    Ich habe keine Ahnung, was die Frage bedeutet. 😉

    Maybe you can ask using English? Please?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 15, 2011 at 2:57 pm

    #1353722

Viewing 15 posts - 1,231 through 1,245 (of 5,502 total)