Forum Replies Created

Viewing 15 posts - 1 through 15 (of 61 total)

  • RE: Sync Develepment and Production Databases

    Hi,

    I'm just trying to be carefull ..... but thank you all.

  • RE: Sync Develepment and Production Databases

    Hi,

    I have to add new data to database every day .... so was thinking not to add the data directly to production coz I might...

  • RE: Sync Develepment and Production Databases

    Hi,

    I want to sync the Dev to Prod.

    Thanks

  • RE: Bulk Insert with Format File

    Hi,

    Thank you very much ...I got it right ...

  • RE: Data Manipulation

    Hi,

    Thank you very much ...It Worked.

  • RE: Error converting data type varchar to float.

    Hi,

    I got it right .... Ill post data if I have any other questions.

    Thanks

  • RE: Error converting data type varchar to float.

    Hi,

    Actually I want to use Agrregate function on this column like SUM(Performance) and this column also has '0' values in some rows. But instead of '0' it has '-' ....

  • RE: Error converting data type varchar to float.

    Hi,

    I had similar problem in the past, so without looking into the data i used float which obviously didn't work. Then I figured out that I...

  • RE: Creating a View with Declare

    LoL....

    I'm just new to all this ....

    Thankyou very much ....

  • RE: Weekly Data Pivot

    Hi

    I tried with the format file but was not working. Maybe i was doing something wrong. But right now I only wanted to get this thing working. I'm just trying...

  • RE: Weekly Data Pivot

    Hi

    Thanks, your first query is working. I just had to modify some section of my query.

    Also the reason I use VARCHAR in my table and use views is that I...

  • RE: Weekly Data Pivot

    Hi

    When I run the first query it gives me:

    CP Code 2010-06-28 2010-07-05 2010-07-12 2010-07-19 2010-08-02 TotalPageviews

    51014 0 0 0 0 0 65396542

    53037 0 0 0 0 0 97626

    60199 0 0 0 0 0 26300906

    60200 0 0 0 0 0 14379058

    60201 0 0 0 0 0 13992453

    60202 0 0 0 0 0 28035017

    60203 0 0 0 0 0 11645770

    60204 0 0 0 0 0 14109229

    60205 0 0 0 0 0 8133982

    60206 0 0 0 0 0 11900110

    60207 0 0 0 0 0 4638197

    60208 0 0 0 0 0 6492873

    60209 0 0 0 0 0 1765906

    60210 0 0 0 0 0 2471653

    60211 0 0 0 0 0 1160578

    60213 0 0 0 0 0 1315068

    60214 0 0 0 0 0 4232959

    60215 0 0 0 0 0 928973

    60216 0 0 0 0 0 1467733

    60217 0 0 0 0 0 3086290

    60219 0 0 0 0 0 751370

    60220 0 0 0 0 0 2378639

    60221 0 0 0 0 0 162232

    60222 0 0 0 0 0 2947181

    60223 0 0 0 0 0 239815

    60224 0 0 0 0 0 586003

    60225 0 0 0 0 0 44706

    70086 0 0 0 0 0 12848

    70725 0 0 0 0 0 119279334

    79999 0 0 0 0 0 1763965

    There is not data in Week Columns.

    For the other two queries, I can get same output if I change the Start...

  • RE: Weekly Data Pivot

    Hi

    Actually there is no missing data for any week, but the reason I want such a query is as the # of weeks increase, so does the # of columns...

  • RE: Weekly Data Pivot

    Hi

    My Table is:

    CREATE TABLE DSA (

    [# CP Code] varchar(50),

    [Time] varchar(50),

    [Total Pageviews] varchar(50)

    )

    INSERT INTO DSA

    ([# CP Code], Time, [Total Pageviews])

    SELECT '51014','8/1/2010','2827962', UNION ALL

    SELECT '51014','8/2/2010','2405999', UNION ALL

    SELECT '51014','8/3/2010','2485448', UNION ALL

    SELECT '51014','8/4/2010','2610767', UNION...

  • RE: Weekly Data Pivot

    Hi

    Can you give me the query to do that .. I'm already preaggregating the data in this query.

    Thanks

Viewing 15 posts - 1 through 15 (of 61 total)