Forum Replies Created

Viewing 15 posts - 46 through 60 (of 761 total)

  • RE: SQL /Procedure - for Transpose and Calculation

    ChrisM@Work (4/9/2013)

    sudhirnune (4/9/2013)

    Yes they has SAL.

    Thanks.

    DROP TABLE #Sampledata

    CREATE TABLE #Sampledata (NAME VARCHAR(25), PAYMENT_TYPE VARCHAR(10), PAYMENT DECIMAL(5,2))

    INSERT INTO #Sampledata (NAME, PAYMENT_TYPE, PAYMENT)

    SELECT 'SUDHIR', 'SAL', 30.3 UNION ALL

    SELECT 'SUDHIR', 'ADV', 10.3 UNION...

    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] 😉

    April 9, 2013 at 4:31 am

    #1604748

  • RE: Query help

    Mvs2k11 (4/6/2013)

    Thanks a lot it works...

    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] 😉

    April 7, 2013 at 10:58 pm

    #1604279

  • RE: CTE - Temp table - CROSS APPLY

    Arjun Sivadasan (4/4/2013)

    Hey, I'm not querying any user tables to post DDL. You can run the queries I posted on any database.

    Edit: I guess you didn't know that information_schema.routines...

    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] 😉

    April 4, 2013 at 11:17 pm

    #1603804

  • RE: CTE - Temp table - CROSS APPLY

    Hi Arjun,

    It is good that you are posting such stuff....people can learn from this.

    But a lot of people who are here won't be able to understand things just...

    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] 😉

    April 4, 2013 at 3:12 am

    #1603471

  • RE: Assing point to race times

    ps_vbdev (4/3/2013)

    Expected reply.

    Not a smart arse, just tired off people with misplaced self-worth.

    below is an answer from a forum member for the same post

    "you can apply an UPDATE based on...

    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] 😉

    April 3, 2013 at 6:31 am

    #1603122

  • RE: Assing point to race times

    I always find forum contributors that reply too posts picking up on spelling mistakes and asking irrelevant questions can never/don't have the ability to answer the problem posted.

    You've always...

    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] 😉

    April 3, 2013 at 6:15 am

    #1603118

  • RE: Assing point to race times

    ps_vbdev (4/3/2013)

    stated in my post "When i bulk insert the csv i was using a case statement to apply a points based on the position field".

    the logic behind how the...

    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] 😉

    April 3, 2013 at 6:12 am

    #1603114

  • RE: Query to retrieve a column depending on variable value?

    You can do it using Dynamic sql as follows:

    --Setting up Sample Data

    Create Table Ex

    (

    ProductId Int,

    name Varchar(20),

    familyName Varchar(20),

    listPrice Int,

    price1 Int,

    price2 Int,

    price3 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] 😉

    April 3, 2013 at 5:53 am

    #1603110

  • RE: Assing point to race times

    How do you decide the points??....What's the logic behind 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] 😉

    April 3, 2013 at 5:09 am

    #1603092

  • RE: difference betwwn inner join and intersect in sql

    Here is a good article with examples about the differences between Intersect and Inner Join.

    difference-between-intersect-and-inner-join[/url]

    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] 😉

    April 3, 2013 at 4:17 am

    #1603081

  • RE: Query help

    Have posted a reply here :

    http://www.sqlservercentral.com/Forums/Topic1435217-392-1.aspx

    You might find it useful.

    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] 😉

    April 3, 2013 at 3:53 am

    #1603077

  • RE: Query help

    Mvs2k11 (3/27/2013)

    for id there would be stuname like 100 row value which should be display as columns..

    If you have 100 rows to pivot and are not sure about addition...

    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] 😉

    April 3, 2013 at 3:42 am

    #1603073

  • RE: Calculate number of days missed per term

    Is there a relationship between the "Attend" table with the "Terms" table??.....

    By what you have shown in the Expected Output it sure seems there is but its not visible in...

    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] 😉

    April 2, 2013 at 11:58 pm

    #1603033

  • RE: Generate all possible number combinations for a provided list of numbers

    Prashh (4/2/2013)

    Thanks for the help, Mark & Vinu!

    This solved my problem. Thanks for your responses.

    You'r welcome Prassh......You are always welcome to post on SSC and learn from here...like we 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] 😉

    April 2, 2013 at 10:04 pm

    #1603019

  • RE: Generate all possible number combinations for a provided list of numbers

    Mark-101232 (4/2/2013)

    Another one to try

    WITH Numbers(N) AS (

    SELECT N

    FROM ( VALUES(1),(2),(3),(4) ) Numbers(N)),

    Recur(N,Combination) AS (

    SELECT N, CAST(N AS VARCHAR(1000))

    FROM Numbers

    UNION ALL

    SELECT n.N,CAST(r.Combination + ',' + CAST(n.N AS VARCHAR(10)) AS...

    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] 😉

    April 2, 2013 at 5:48 am

    #1602754

Viewing 15 posts - 46 through 60 (of 761 total)