Forum Replies Created

Viewing 15 posts - 781 through 795 (of 928 total)

  • RE: Running the stored procedure more than once

    To have a chance of answering this we should see example data and the code. Have a look at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for guidance on providing these.

    BrainDonor.

    April 7, 2010 at 2:07 am

    #1147107

  • RE: How to restore SQL 2005 Master DB into SQL 2008 DB

    No.

    The Master db stores the system-level details of the SQL Server system it is installed on, so you wouldn't want to do such a thing. Have a look at 'Master...

    April 6, 2010 at 1:08 am

    #1146311

  • RE: Granted or revoked privilege EXECUTE is not compatible with object

    pureaqua (3/31/2010)

    SELECT 'GRANT EXECUTE ON [' + CONVERT(VARCHAR(255),NAME) + '] TO FredGRP'

    FROM sysobjects

    WHERE xtype IN ('P', 'X', 'FN', 'IF')

    The "EXECUTE" can NOT be granted on IF (inline table-valued-function).

    I...

    April 1, 2010 at 1:08 am

    #1143710

  • RE: Using IsNull when passed variable value is ''

    Next time, supply the code required to create some test data - it makes it easier for others, so they'll be more willing to help. It also reduces the chances...

    March 30, 2010 at 1:57 am

    #1141998

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/29/2010)

    BrainDonor (3/29/2010)

    Alvin Ramard (3/29/2010)

    Jeff, I just read your comment about the MS 70-433 book. I happy I did not order the MS one.

    Now if that other 70-433...

    March 30, 2010 at 1:30 am

    #1141986

  • RE: Are the posted questions getting worse?

    Paul White NZ (3/29/2010)

    BrainDonor (3/29/2010)

    How many other countries change their clocks forward in the Spring? I've woken up in the dark for the first time in weeks and my brain...

    March 29, 2010 at 9:02 am

    #1141492

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/29/2010)

    Jeff, I just read your comment about the MS 70-433 book. I happy I did not order the MS one.

    Now if that other 70-433 book would just...

    March 29, 2010 at 8:58 am

    #1141487

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/29/2010)

    BrainDonor (3/29/2010)

    How many other countries change their clocks forward in the Spring? I've woken up in the dark for the first time in weeks and my brain is...

    March 29, 2010 at 7:35 am

    #1141408

  • RE: Are the posted questions getting worse?

    How many other countries change their clocks forward in the Spring? I've woken up in the dark for the first time in weeks and my brain is complete mush.

    March 29, 2010 at 2:12 am

    #1141241

  • RE: NULLIF

    BrainDonor (3/29/2010)

    Bhuvnesh (3/29/2010)

    Why it is treating 0 and '' (Blank) same ? in select nullif( 0, '')

    Because you have a number and a character field to compare, SQL...

    March 29, 2010 at 1:59 am

    #1141235

  • RE: NULLIF

    Bhuvnesh (3/29/2010)

    Why it is treating 0 and '' (Blank) same ? in select nullif( 0, '')

    Because you have a number and a character field to compare, SQL will...

    March 29, 2010 at 1:55 am

    #1141233

  • RE: T-SQL CASE Problem

    Bhuvnesh (3/25/2010)

    @BrainDonor

    WHERE

    (@CompanyLetter = 'ALL')

    OR

    ((@CompanyLetter =...

    March 25, 2010 at 8:22 am

    #1139664

  • RE: T-SQL CASE Problem

    Trybbe (3/25/2010)

    hi I have the same problem except my case statement should look something like this:

    Select distinct staffno

    from dtiheadcount dt inner join reportingstructure re

    on dt.costcenter = re.costcenter

    Where period =...

    March 25, 2010 at 5:36 am

    #1139512

  • RE: T-SQL CASE Problem

    Yet another way:

    --CREATE TABLE tblCompany(

    --CompanyIDint,

    --CompanyNamevarchar(max),

    --Activevarchar(5),

    --LastModifieddateTime

    --)

    --INSERT INTO tblCompany(CompanyID, CompanyName, Active, LastModified)

    --SELECT 1, 'A Company', 'Yes', '01 MAR 2010'

    --UNION

    --SELECT 2, 'Another Company', 'Yes', '01 MAR 2010'

    --UNION

    --SELECT 3, 'Yet Another Company', 'No', '01...

    March 25, 2010 at 4:07 am

    #1139483

  • RE: Suspect FileStream database

    Perfect, thank you very much.

    BrainDonor

    March 24, 2010 at 7:35 am

    #1138918

Viewing 15 posts - 781 through 795 (of 928 total)