Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Using SQLCMD as an alternative to xp_cmdshell

    Hi,

    As you said we can use the SQLCMD to execute operating system commands by indicating the " !! " before the command.

    I have created a POC on using OPerating...

    Thanks and Regards,
    Ramakant
    ---------------------------------------------------------------
    Ramakant Shankar
    InfoCepts | www.infocepts.com
    Off: +91 712 224 5867 Ext 8388, +1 301 560 2591 Ext 8388
    ---------------------------------------------------------------

    September 13, 2011 at 1:29 am

    #1380435

  • RE: trouble importing excel file to sql server ,please I need help

    Hi,

    I am not clear on what issue are you facing. But I have tried to create a test scenario. I have taken 1 test table and Test excel file. Test...

    Thanks and Regards,
    Ramakant
    ---------------------------------------------------------------
    Ramakant Shankar
    InfoCepts | www.infocepts.com
    Off: +91 712 224 5867 Ext 8388, +1 301 560 2591 Ext 8388
    ---------------------------------------------------------------

    September 12, 2011 at 1:48 am

    #1379811

  • RE: SQL Query

    ramakantshankar (6/14/2011)

    Hi Rajesh,

    I have created same scenario using the data discussed in your question as below:

    CREATE TABLE PIVOTING(NAME VARCHAR(4),DATE DATE, SIZE INTEGER);

    INSERT INTO PIVOTING

    SELECT * FROM (

    SELECT 'AAAA' NAME,...

    Thanks and Regards,
    Ramakant
    ---------------------------------------------------------------
    Ramakant Shankar
    InfoCepts | www.infocepts.com
    Off: +91 712 224 5867 Ext 8388, +1 301 560 2591 Ext 8388
    ---------------------------------------------------------------

    June 14, 2011 at 11:53 pm

    #1338765

  • RE: SQL Query

    Hi Rajesh,

    I have created same scenario using the data discussed in your question as below:

    CREATE TABLE PIVOTING(NAME VARCHAR(4),DATE DATE, SIZE INTEGER);

    INSERT INTO PIVOTING

    SELECT * FROM (

    SELECT 'AAAA' NAME, CAST('04/15/2011'...

    Thanks and Regards,
    Ramakant
    ---------------------------------------------------------------
    Ramakant Shankar
    InfoCepts | www.infocepts.com
    Off: +91 712 224 5867 Ext 8388, +1 301 560 2591 Ext 8388
    ---------------------------------------------------------------

    June 14, 2011 at 9:31 am

    #1338471

  • RE: Join Query in sql

    Hi,

    You can apply join on the result set of two stored procedure. Following is an example showing the use of OPENQUERY for achieving this:

    Syntax of OPENQUERY used in...

    Thanks and Regards,
    Ramakant
    ---------------------------------------------------------------
    Ramakant Shankar
    InfoCepts | www.infocepts.com
    Off: +91 712 224 5867 Ext 8388, +1 301 560 2591 Ext 8388
    ---------------------------------------------------------------

    April 28, 2011 at 7:26 am

    #1317239

Viewing 5 posts - 1 through 5 (of 5 total)