Forum Replies Created

Viewing 15 posts - 316 through 330 (of 761 total)

  • RE: SQL SERVER 2008 LOGIC

    anthony.green (6/11/2012)

    First, please may I say that you need to switch caps lock off.

    Second please follow the second link in my signature on how to post code and data for...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 11, 2012 at 4:53 am

    #1499235

  • RE: Call SSIS Import Export Wizard From Insert Trigger

    Koen Verbeeck (6/11/2012)

    If you find out the requirement, would you please post it here?

    I'm very very curious why one would want to do such a thing.

    Sure thing Koen. 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 11, 2012 at 12:50 am

    #1499167

  • RE: Call SSIS Import Export Wizard From Insert Trigger

    I haven't been told about the requirement yet. A Senior DBA just called me and asked me if there is a way. Asked me to figure out how to do...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 11, 2012 at 12:46 am

    #1499164

  • RE: Call SSIS Import Export Wizard From Insert Trigger

    Koen Verbeeck (6/11/2012)

    It's a wizard. By defination a graphical user interface designed to guide a user through a certain process.

    Why would you ever want to call that from a trigger?

    Thanks...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 11, 2012 at 12:44 am

    #1499161

  • RE: Finding the right JOIN type

    I can understand that you need a JOIN.

    But the rest of the parts are not very clear.

    You need to give us a little more sample data for all the three...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 10, 2012 at 11:19 pm

    #1499143

  • RE: Query output less number of records?

    ananda.murugesan (6/10/2012)

    Hi,

    Total 3000 Records, executing query 2300 records only display, please tell me what could be reason?

    thanks

    ananda

    Because Sql Server, after compiling your query, doesn't think that the rest of...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 10, 2012 at 11:09 pm

    #1499139

  • RE: How to Get the Output in a row instead of column Grid?

    You can use any of the following variations. The Dynamic Pivot would be my pick.

    --Creating Tables

    Create Table Ex

    (DeptNo int,

    DNAME varchar(20) )

    --Inserting Sample Data

    Insert Into Ex

    Select 10,'ACCOUNTING'

    Union ALL

    Select 20,'RESEARCH'

    Union ALL

    Select...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 10, 2012 at 11:00 pm

    #1499137

  • RE: How to do math job with this two table?

    You could use unpivot in this case as follows:

    --Creating Tables

    Create Table A

    (NAME varchar(3),

    [201202] int,

    [201203] int,

    [201204] int )

    Create Table B

    (NAME varchar(3),

    [201202] int,

    [201203] int,

    ...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 8, 2012 at 11:16 pm

    #1499001

  • RE: Difference between sqlserver 2012 and sqlserver 2008

    You need to do some reading and I think you are smart enough to work the difference out at the end. These links will help you:

    SQLServer2008

    SqlServer2012

    What's New in SQL Server...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 8, 2012 at 6:48 am

    #1498690

  • RE: Need help on Pivot

    manzilkolur23 (6/7/2012)

    Hi,

    Had done the same way but did not use "partition by" so was not able to get the exact output

    Thanks for the reply... It helped me and solved it...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 7, 2012 at 5:16 am

    #1498071

  • RE: Unique Error with convert function in update query

    I got the same error yesterday while I was performing an insert on some table. Then I remembered that I had changed the Date Format From 'ymd' To 'mdy'.

    So, I...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 6, 2012 at 11:16 pm

    #1497991

  • RE: please any one help me, for finding error in that procedure,when i create a ssrs report from that procedure i can not find all the parameters from procedure at parameter pane

    What is the Error Generated When You Compile the Procedure??....Please post the DDL of all the atbles and some sample data from them.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 6, 2012 at 11:02 pm

    #1497989

  • RE: Help please for total Newbie to MS SQL re: Transform

    you're Welcome.:-)

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 6, 2012 at 10:45 pm

    #1497986

  • RE: Sum two tables

    okbangas (6/6/2012)

    vinu512 (6/6/2012)

    You can do it like this:

    Select a.year, a.week, SUM(a.total_savings) From

    (Select * From Ex

    union

    Select * From Ex1) As a

    Group By a.year, a.week

    If so, you have to use union all,...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 6, 2012 at 10:42 pm

    #1497985

  • RE: Using multiple counts to return results

    Please post some sample data for the table.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    June 6, 2012 at 5:21 am

    #1497535

Viewing 15 posts - 316 through 330 (of 761 total)