Viewing 15 posts - 121 through 135 (of 236 total)
Simple and nice article,
some time back i was working on validating a column in the database and i came across this issue and we had this function to validate.
CREATE...
November 30, 2010 at 9:51 pm
will your columns in the log file change or it will be same for all the log files?
November 30, 2010 at 1:01 am
i am asuming that you need to insert the records from mainorders table to order details table based on the poderif in the order table.
you can achive the same using...
November 29, 2010 at 1:38 am
sampathsoft (11/28/2010)
OOOPs I Found the solution....http://mangalpardeshi.blogspot.com/2009/06/multiplying-column-values.html
Thanks
Yep you can also look at this url
http://www.eggheadcafe.com/software/aspnet/30291469/function-like-sum-but-multiply.aspx
November 28, 2010 at 11:34 pm
you can find something like this
Create Table #table
(
ITEM varchar(10),QTY int
)
Insert into #table
select 'B0-001', 100 union all
select 'B0-002', 50 union all
select 'B0-003', 25 union all
select 'B0-001', 40 union all
select 'B0-001',...
November 28, 2010 at 11:29 pm
what error you are getting, without that it is really difficult to help you
November 28, 2010 at 11:17 pm
New topic to me, learned something new. my guess was correct :w00t:
November 28, 2010 at 11:14 pm
bajanpoet (11/26/2010)
da-zero (11/26/2010)
How is your package constructed? What sort of connections do you use? Are there passwords needed?
edit: oh yeah,...
November 26, 2010 at 5:24 am
i am sorry, stewartc-708166 gave a correct solution than what i wrote
November 26, 2010 at 3:11 am
you can have something like this
Create trigger trg_update_Role_RoleConsumer
On [Role]
For update
As
declare @IsDeleted bit
declare @RoleName varchar(50)
select @IsDeleted = inserted.[IsDeleted] from inserted
select @RoleName = inserted.[RoleName] from inserted
if @IsDeleted = 1
begin
update [RoleConsumer]...
November 26, 2010 at 3:10 am
Good Question, in our development we have only one Proc with encryption and i was doing some R&D on it, it helped me to answer this Question.
November 26, 2010 at 2:15 am
Congrats da-zero,
i am also planning to take sql server exams.
November 26, 2010 at 2:12 am
HAPPY THANKSGIVING to all our guys here. Enjoy the looooo:-)ooong week end
November 25, 2010 at 7:55 am
Viewing 15 posts - 121 through 135 (of 236 total)