Thursday, 27 September 2012

Asp.net Web confi database connect:

<system.web>
<connectionStrings>
<
clear /><
add name="connectstring name" connectionString="Data Source=ServerName;Initial Catalog=databasename;User Id=  null Password= null" /> </connectionStrings>
<
system.web>

1 comment:




  1. Sample unpivot

    CREATE TABLE SS
    (
    PRODUCT VARCHAR(10),
    PROD VARCHAR(10),
    PRO VARCHAR(10)
    )

    SELECT *FROM SS

    SELECT VALUES1,VALU FROM
    (SELECT PRODUCT,PROD,PRO FROM SS)X
    UNPIVOT
    (VALU FOR VALUES1 IN (PRODUCT,PROD,PRO))AS PIV

    SAMPLE PIVOT



    create table DailyIncome
    (
    VendorId nvarchar(10),
    IncomeDay nvarchar(10),
    IncomeAmount int
    )

    insert into DailyIncome values ('SPIKE', 'FRI', 100)
    insert into DailyIncome values ('SPIKE', 'MON', 300)
    insert into DailyIncome values ('FREDS', 'SUN', 400)
    insert into DailyIncome values ('SPIKE', 'WED', 500)
    insert into DailyIncome values ('SPIKE', 'TUE', 200)
    insert into DailyIncome values ('JOHNS', 'WED', 900)
    insert into DailyIncome values ('SPIKE', 'FRI', 100)
    insert into DailyIncome values ('JOHNS', 'MON', 300)
    insert into DailyIncome values ('SPIKE', 'SUN', 400)
    insert into DailyIncome values ('JOHNS', 'FRI', 300)
    insert into DailyIncome values ('FREDS', 'TUE', 500)
    insert into DailyIncome values ('FREDS', 'TUE', 200)
    insert into DailyIncome values ('SPIKE', 'MON', 900)
    insert into DailyIncome values ('FREDS', 'FRI', 900)
    insert into DailyIncome values ('FREDS', 'MON', 500)
    insert into DailyIncome values ('JOHNS', 'SUN', 600)
    insert into DailyIncome values ('SPIKE', 'FRI', 300)
    insert into DailyIncome values ('SPIKE', 'WED', 500)
    insert into DailyIncome values ('SPIKE', 'FRI', 300)
    insert into DailyIncome values ('JOHNS', 'THU', 800)
    insert into DailyIncome values ('JOHNS', 'SAT', 800)
    insert into DailyIncome values ('SPIKE', 'TUE', 100)
    insert into DailyIncome values ('SPIKE', 'THU', 300)
    insert into DailyIncome values ('FREDS', 'WED', 500)
    insert into DailyIncome values ('SPIKE', 'SAT', 100)
    insert into DailyIncome values ('FREDS', 'SAT', 500)
    insert into DailyIncome values ('FREDS', 'THU', 800)
    insert into DailyIncome values ('JOHNS', 'TUE', 600)


    SELECT *from Dailyincome
    pivot(AVG(IncomeAmount)FOR IncomeDay in(MON,TUE,WED,THU,FRI,SAT,SUN))AS DAYS
    --WHERE VendorId='JOHNS'

    select * from DailyIncome
    pivot (max (IncomeAmount) for IncomeDay in ([MON],[TUE],[WED],[THU],[FRI],[SAT],[SUN])) as MaxIncomePerDay
    where VendorId in ('SPIKE')

    ReplyDelete