Forum Replies Created

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

  • RE: The US Holiday

    Easy One. Happy Independence Day Americans!!

  • 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...

  • 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...

  • RE: Temp Tables revisited

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

  • RE: Lock Escalation Limit

    A very good question and well explained as well. 🙂

  • 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,

    (...

  • 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...

  • 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...

  • 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...

  • RE: Temp Tables

    Very Good One.

  • RE: sqlCursor

    dwain.c (5/19/2013)


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

    Amen!!!! :-D:-D

  • 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...

  • 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.

  • 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:

  • RE: Table Alias

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

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