Hi,

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

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

Hi,

I want to sync the Dev to Prod.

Thanks

Hi,

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

Hi,

Thank you very much ...It Worked.

Hi,

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

Thanks

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

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

LoL....

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

Thankyou very much ....

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

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

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

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

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

Hi

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

Thanks