Forum Replies Created

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

  • RE: 100GB of Cube size!!

    Thank you all for your respose. It relieved me.:cool:

    Currently we are using hosting dot com service which has Windows Server 2008 R2. 24GB Ram.

    What should be the server configuration in...

  • RE: sp_xp_cmdshell_proxy_account gives a error, need help....

    Can we have more than one windows user configured as proxy? How?

    Actually, I have two Application servers using same database server. Both of them have two seperate users, which i...

  • RE: need MasterId from comma seperated column values

    Thanks a lot for the awesome logic... 🙂

    Some problem with the logic, when the data is like this:

    drop table #test1

    drop table #Master

    select * into #test1 from (

    select 1 ID, 'Dog'...

  • RE: SSIS DT_NTEXT to DT_STR conversion failure unicode and non-unicode Excel

    Two steps involved in this:

    1. Convert DT_NTEXT to DT_WSTR

    2. Convert DT_WSTR to DT_STR

    Thats it.

  • RE: Help on Table/Query tuning

    GilaMonster (8/11/2010)


    Post the view definition?

    CREATE VIEW [View1]

    AS

    SELECT ROW_NUMBER() OVER (ORDER BY VERSIONID) AS ROW_NUMBER,* FROM

    (SELECT Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, [value]

    from Table1

    WHERE PARAMETERNAME in (SELECT convert(varchar(max),decryptbypassphrase('SKey',PARAMETERNAME))...

  • RE: Help on Table/Query tuning

    Guys thanks for your concern.

    Grant Fritchey (8/10/2010)


    What business need is being satisfied by pulling all the data? .why are you querying everything?

    We have created a view using this Table (lets...

  • RE: Return Column as List of Comma Seperated Values

    A simple script to get comma seperated result. 😎

    declare @empids varchar(max);

    set @empids = '';

    select @empids = convert(varchar, empid) + ', ' + @empids

    FROM employee

    select @empids

    --output

    --,...

  • RE: IF condition in CURSOR

    Paul White (9/5/2009)


    A more usual solution would be to update the state populations individually. The country population would then be auto-magically updated from the total for the states added...

  • RE: solution for error 512 , subquery return more than 1 value

    m_goulay (9/7/2009)


    Subquery returned more than 1 value.

    and BranchID=(Select BranchID from Damagedcategory where DamagedID in

    This is where your query might be returning more than one value.

    try changing it something...

  • RE: Exec SP and ignore the output (occasionally)

    Have a look at this url

    check the code below:

    ----------------------------------------

    create proc sp_test123

    as

    begin

    SET NOCOUNT ON;

    create table #temp ( testName varchar(50))

    insert into #temp values ( 'abc'); insert into #temp values ( 'abc1');

    insert into...

  • RE: Exec SP and ignore the output (occasionally)

    claudiosil100 (9/7/2009)

    I can't because the output of SP1 it's an XML

    In the 1st SP. Make the return type as varchar or something..

    refer below example

    --creating some temp table for reference

    create table...

  • RE: Exec SP and ignore the output (occasionally)

    claudiosil100 (9/7/2009)


    I need the result of 1st SP to work into 2nd.

    In the 1st SP. Make the return type as varchar or something..

    refer below example

    --creating some temp table for...

  • RE: Stored procedure Usage

    Jeff Moden (9/5/2009)[/b

    Yes... you shouldn't use a stored procedure to format data for a GUI or reporting system. That also includes many cross-tabs and pivots (not to be confused...

  • RE: Stored procedure Usage

    Hi,

    It is a good practice to use stored procedure, even always.

    Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be:...

  • RE: Inserting a word

    Jeff Moden (9/5/2009)

    BWAA-HAAA!!! Considering that you're the one asking the question, you're not the one to make such a judgment. Welcome ALL answers because even the wrong ones...

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