Forum Replies Created

Viewing 15 posts - 16 through 30 (of 760 total)

  • RE: The US Holiday

    Easy One. Happy Independence Day Americans!!

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

    July 4, 2013 at 4:14 am

    #1629794

  • RE: Query Help

    Cadavre (6/29/2013)

    kapil_kk (6/29/2013)

    Srry that was typo misktake in my question n i Have corrected that...

    that was trns1 only not trns2...

    I tried it but not it is not possible with min...

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

    July 1, 2013 at 3:21 am

    #1628643

  • RE: Function inside a View

    The function in the view is a table valued function. This code is actually very old. It runs on one of our SQL Server 2000 servers and yes the Distinct...

    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 28, 2013 at 12:18 am

    #1628204

  • RE: Temp Tables revisited

    Good question on how parsing works.....very important to know the internals well.

    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 23, 2013 at 10:15 pm

    #1626639

  • RE: Lock Escalation Limit

    A very good question and well explained as well. 🙂

    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 19, 2013 at 11:49 pm

    #1625712

  • RE: Need Help with the Error 'Subquery returned more than 1 value'.

    nitha jen (6/12/2013)

    can anyone help me? i am new to db....

    CREATE proc [dbo].[student_marks]

    @roll_no varchar(20)

    AS

    BEGIN

    CREATE TABLE #temp

    (

    semester INT,

    marks INT

    )

    INSERT INTO #temp

    (

    semester,

    marks

    )

    SELECT

    semester,

    (...

    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 12, 2013 at 10:58 pm

    #1623563

  • RE: How to export more than 3,00,000 records into a single Excel Work Sheet?

    Nevermind, I was thinking too much. It was simple, you just have to export the data to a .csv file using DTS and then edit the data for dates and...

    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, 2013 at 12:20 am

    #1621598

  • RE: GROUPING SETS - 1

    I don't agree....I thought the options weren't precise enough....I couldn't work it out in my head....so I executed it to find out that my answers don't match the condition 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] 😉

    May 31, 2013 at 6:09 am

    #1620030

  • RE: How to get date as my column not as row

    Hi,

    Hope this works for you:

    ---Creating Table

    Create table Ex

    (

    Sales_2012Float,

    Plann Float,

    fiscal_week_2013 Date,

    Sales_2013 Float,

    LY Float,

    PN Float

    )

    --Inserting Data

    Insert Into Ex

    Select 232.2935700,286.8642,'2013-01-05',263.1448400,0.132811553931518638,-0.0826852665251378...

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

    May 30, 2013 at 7:20 am

    #1619698

  • RE: Temp Tables

    Very Good One.

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

    May 25, 2013 at 2:43 am

    #1618514

  • RE: sqlCursor

    dwain.c (5/19/2013)

    The anti-RBAR alliance will forever bless you if you do.

    Amen!!!! :-D:-D

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

    May 20, 2013 at 12:40 am

    #1616516

  • RE: INTO Identities

    Slawomir Swietoniowski (5/12/2013)

    This question is stated wrong, cont(...) does not have any alias for the name, so, while you will try to execute this code, you will get:

    Msg 1038, Level...

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

    May 13, 2013 at 3:20 am

    #1614524

  • RE: Identity Insert

    kapil_kk (5/2/2013)

    Easy one to the end of week 😛

    +1. But good for testing basics...even if its not a real scenario.

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

    May 2, 2013 at 11:24 pm

    #1612084

  • RE: Table Alias

    A very easy one Danny....but nothing better than going back to basics 🙂

    Edit: Sorry for the double post....the browser hung up on me. :hehe:

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

    May 1, 2013 at 10:31 pm

    #1611781

  • RE: Table Alias

    A very easy on Danny....but nothing better than going back to basics 🙂

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

    May 1, 2013 at 10:31 pm

    #1611780

Viewing 15 posts - 16 through 30 (of 760 total)