Forum Replies Created

Viewing 15 posts - 23,296 through 23,310 (of 26,486 total)

  • RE: How to display data from a SQL Server DB within a SharePoint - SharePortal Site

    I don't know if this helps, but you can integrate Reporting Services with SharePoint. You would then use Reporting Services Reports to provide the integration you are looking to...

  • RE: Starting a Job

    Check BOL (Books Online). The procedure you are looking for is msdb.dbo.sp_start_job (or in BOL, just sp_start_job).

  • RE: subtracting 2 time data types error

    Good thing I didn't tell people to post here instead in the other thread. At this point, I just want to know what version of SQL is being used.

  • RE: t-sql puzzler

    You could use a derived table in your FROM clause, but a CTE is cleaner.

  • RE: null values

    Do you want a better answer? If yes, then read the following article http://www.sqlservercentral.com/articles/Best+Practices/61537/

    and following the guidelines within it to provide us with everything we need to help...

  • RE: subtracting 2 time data types error

    Are you sure it shouldn't be posted here instead of there? One post is in SQL Server 2005 and the other is SQL Server 2008. In the other...

  • RE: error subtracting 2 time datatypes

    Just noticed, this is also double posted. It is also posted in a SQL Server Experss 2005 forum. What version of SQL Server are you using? And...

  • RE: subtracting 2 time data types error

    Michael Artz (12/15/2008)


    I need a simple sql statement with a case to determine whether 2 times need to be added or subtracted

    the case statement i have works... but sql wont...

  • RE: null values

    May I suggest that you read the article I have referenced below in my signature block regarding asking for help. Based on your posts, I really don't know what...

  • RE: Decimal vs Numeric datatype

    karthikeyan (12/15/2008)


    Hi All,

    I need quick help.

    create table #temp

    (

    val decimal(16,10)

    )

    insert into #temp

    select 4536426.225

    is throwing the below error message.

    Arithmetic overflow during implicit conversion of NUMERIC value '4536426.225' to a DECIMAL field .

    i...

  • RE: How to use a SP within Select Statement of another SP

    The only RDBMS system that I know of that allows using stored procedures like tables is InterBase.

    It happened to be one of the RDBMS we were evaluating at my previous...

  • RE: null values

    Are you saying that if, for instance, column c is null for a particular row, don't return that row.

    select

    *

    from

    dbo.MyTable

    where

    ...

  • RE: Stored Procedure

    I'm sorry, but I don't see any errors in your post. What errors are you receiving?

  • RE: Basic T-SQL

    darryl (12/12/2008)


    Thanks for the pointer. I will try to do it better.

    First of all, the only code I tried was to select the records. If figured the first...

  • RE: Basic T-SQL

    Read the article that both Seth and I have in our signature block. It will walk you through the steps you need to do to get the best help...

Viewing 15 posts - 23,296 through 23,310 (of 26,486 total)