I am from China.I have a weblog,and who can help me to transform into Data warehousing with MS DTS? And can you give me the DTS file and correlative code? Because i am writing the graduation thesis,i need these code to write. Thank you. By the way,who have some ETL code about transforming the weblog into data warehousing?Thank you! My e-mail is chentao0405@yahoo.com.cn
View 1 Replieshi
i want to create my own blog in c# and i m starting to design sql tables and
i want to show my archive posts in that way,
e.g
Juli 2006(2) here 2 is the total post of blog articles in July.
Agust 2006(10)
September 2006(34)
Oktober 2006(23)
and so on...
Here is my blog table...
create table tblBlogg (
LId int IDENTITY(1,1) primary key,
LUserId int not null,
LCategoryId int null,
LCaption nvarchar(50) null,
LBody ntext null,
LTime datetime not null default(getdate()),
LMonth as datename(m,Ltime),
LYear as datename(yy,Ltime),
LIsActive bit null
)
--Question 1)In Lmonth it comes with month name in english,how can i change to german in sqlserver 2000, or do i have to do in c# function?
--Question 2)do i need LMonth and LYear columns ? What is the common way? is Ltime column enough for that? for example, c# datetime functions may accomplish this task.
Any help greatly appreaciated.
Daniel..