Forum Replies Created

Viewing 15 posts - 1 through 15 (of 109 total)

  • RE: calling stored proc from a linked server...

    You can use the Fully Qualified Name

    SERVER.Database.Owner.Procedure name

    annd execute the procedure on another server once you have added it as linked server.

    Also remote stored procedures are not within the...

  • RE: Insert errors on SQL 2000

    Where have the insert statements being written?

    In the stored procedures or on the client side?

    He who knows others is learned but the wise one is one who knows himself.

  • RE: Attach dtabase

    Restart the SQl server Service.

    Issue the sp_detach_db command for the database you want to copy on some other place.

    Copy the .mdf and .ldf to the location of your choice and...

  • RE: Attach dtabase

    Have you detached the database.

    BOL States that:

    sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation

    He who knows others is...

  • RE: Table Name as SP Parameter

    quote:


    Update @Tablename Set @FieldName = Replace(@FieldName,@FindString,@RepalceString)

    GO

    Make it

    'Update ' + @Tablename + 'Set ' + @FieldName + ' =...

  • RE: Table Name as SP Parameter

    You can create Dynamic SQL statments

    and execute them using EXEC.

    But I am not sure if this is the right way to go about.

    What I feel is that you are trying...

  • RE: Trying a new way to use fn_get_sql()

    I am completely unaware of these function,

    I mean how to use them and why?

    Please give me some leads.

    He who knows others is learned but the wise one is one who...

  • RE: re: Creating a pivot query through SQL

    Try this Out

    ==============

    declare @sqlstring varchar(1000)

    declare @currentchar varchar(10)

    declare @mysqlstring varchar(8000)

    set @sqlstring ='sum( case customersales.cutomerid when ''XXX'' then customersales.totalsales else 0 end )'

    set @mysqlstring =''

    set @currentchar =''

    declare @m varchar(8000)

    declare @start...

  • RE: re: Creating a pivot query through SQL

    One way I can suggest is getting all the unique values needed for buliding the columns

    in a temporary table.

    Then using dynamic SQl you could build your Case statements.

    I believe ...

  • RE: Attach dtabase

    Any errors that you are getting?

    He who knows others is learned but the wise one is one who knows himself.

  • RE: COALESCE and updating with NULL

    Try this

    e.g.

    update customers set

    outstanding=case when coalesce(outstanding,0)=0 then null else coalesce(outstanding,0) end

    He who knows others is learned but the wise one is one who knows himself.

  • RE: Regional settings

    Where do you intend to display the data.

    As far as I remember regional settings are used to display the data according to particular format.

    He who knows others is learned but...

  • RE: Using File Groups

    One way I found is using the database diagrams.

    There one can change the file groups.

    He who knows others is learned but the wise one is one who...

  • RE: Using File Groups

    I am not sure if it can be done using EM

    I think I am missing something obvious.

    Can u guide me frank?

    He who knows others is learned...

  • RE: Using File Groups

    If I need to move existing tables to other filegroups, How do I do them?

    I mean do I have to do it explicitly?

    Like Create a table on other file group...

Viewing 15 posts - 1 through 15 (of 109 total)