Viewing 15 posts - 91 through 105 (of 111 total)
As it is my first time in design I wanted get good suggestion from experts. Thank you every one for the help
Ta
April 29, 2009 at 12:47 pm
thank you roy
April 29, 2009 at 10:36 am
We are in early stage of analysis and design but I can reflect on rough figures. We are considering development in C# and .NET framework 3.5. Our E-com website generates...
April 29, 2009 at 3:30 am
Thank you. I will have look at the link you marked in your reply.
Ta
April 21, 2009 at 1:03 pm
Thank you for your response. It did certainly help.
Vids
April 18, 2009 at 2:08 pm
hello,
I agree that we dont need supplier id in Brand Table. Thanks for your time
April 16, 2009 at 11:07 am
HI Jeff,
As you say I agree that CTE with Row_Number is not helpful. I will try with your option UnPivot and let you know the result.
Cheers
October 6, 2008 at 7:02 am
HI Barry,
Do you mean that I need to write 25 different update statement inside Stored procedure to update corresponding 25 fields of the table?
Cheers
October 5, 2008 at 11:56 am
Hi There,
It did really answered my question. I have this requirement for updating several fields in the database not just one field(values in the array is for different fields in...
October 5, 2008 at 8:38 am
HI Jeff/Luke,
During my research I discovered that combination of CTE and Row_Number function could answer my problem. Im in the process of working out that. Any suggestions is valuable.
Cheers
October 5, 2008 at 6:03 am
HI Jeff,
Temp table will be the structure I mentioned. Two base tables doesn't share any relation. This is due to the fact that database is migrated to sql 2005 with...
October 5, 2008 at 3:44 am
HI Luke/Jeff,
Hope you both have seen the two table structure, my result temporary table should hold the values like following
Create table #temptable
(
name varchar(25),
description varchar(25),
category varchar(25),
active bit not null
)
values of the...
October 4, 2008 at 2:35 am
HI Luke ,
Sorry my laptop is acting weird today.
Previous reply will successfully add 4 rows in tab1 and tab2. Now I just need to know whether I can write...
October 3, 2008 at 1:29 pm
HI Luke,
Sorry for all the inconvenience caused.
Tab1 structure
Create Table Tab1
(
name varchar(25),
description varchar(25),
Category varchar(25)
)
Sample data for Tab1
insert into tab1 (name,description,category) values ( 'caneditacc','editing','Acc')
insert into tab1 (name,description,category) values ('candeleteacc','deleting','Acc')
insert into...
October 3, 2008 at 1:23 pm
Viewing 15 posts - 91 through 105 (of 111 total)