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 Code2010-06-282010-07-052010-07-122010-07-192010-08-02TotalPageviews

510140000065396542

530370000097626

601990000026300906

602000000014379058

602010000013992453

602020000028035017

602030000011645770

602040000014109229

60205000008133982

602060000011900110

60207000004638197

60208000006492873

60209000001765906

60210000002471653

60211000001160578

60213000001315068

60214000004232959

6021500000928973

60216000001467733

60217000003086290

6021900000751370

60220000002378639

6022100000162232

60222000002947181

6022300000239815

6022400000586003

602250000044706

700860000012848

7072500000119279334

79999000001763965

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