Viewing 15 posts - 16 through 30 (of 31 total)
Please find below the table creation and Insert Script
CREATE TABLE Sequence
(ID INT,
Seq VARCHAR(MAX))
INSERT INTO Sequence VALUES(1,'01111')
INSERT INTO Sequence VALUES(1,'10111')
INSERT INTO Sequence VALUES(1,'11011')
INSERT INTO Sequence VALUES(1,'11101')
INSERT INTO Sequence VALUES(1,'11110')
INSERT...
August 31, 2009 at 4:38 am
Hi kramaswamy,
Thank you so much!!!
Regards,
Naveen
August 23, 2009 at 10:04 pm
Hi,
The representation of value in Table1 in sequence is as follow
ResID S1 S2 S3 S4 S5 S6
1 0...
August 23, 2009 at 9:44 pm
Hi,
The Value in table2 (for a given AID value) is a sequence of 1's and 0's, Where each position represents the corresponding Value of ResID in table1 in the asc...
August 23, 2009 at 9:37 pm
Hi Jeff,
Thanks!!! but this works only for the value of seq 111
Will it work for seq like 110, 101, 001,011? when the resid 2 is removed, the final output...
August 21, 2009 at 12:37 am
Hi,
Ya am kind of new to this:-) . Please find the details below
USE [Test]
GO
CREATE TABLE [dbo].[Table1](
[AID] [int] NOT NULL,
[ResID] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Table2](
[AID] [int] NOT NULL,
[Seq]...
August 20, 2009 at 8:51 pm
Hi,
Any suggestions on this? Is it possible to achieve this through TSql or SP or do i need to create a front end to achieve this.
Regards,
Navee
August 20, 2009 at 6:35 pm
Hi,
Can you help me out in updating such Foreign Key relationships. In one of my tables, i have a FK relationship refering to my primary key of the same...
August 20, 2009 at 6:26 pm
Hi,
Can anyone help me out with writing the code(scenario 2) using temp variables for logging errors outside the transaction scope.
Thanks for your help!!!
July 7, 2009 at 2:29 am
Hi All,
My Nested code is similar to the below code template
CREATE PROCEDURE usp_Proc1
AS
BEGIN TRY
BEGIN TRAN TRAN1
...
July 2, 2009 at 10:00 pm
1) What scenario is best suited for implementing CLR triggers?
2) What are things that needs to be taken care of while implementing the CLR tiggers
May 18, 2009 at 2:16 am
My business logic shoud get executed whenever, there is an updation to the table4.My business logic cann't be implemented in the stored procedure.My business logic is such that, it should...
May 17, 2009 at 1:59 am
Can i call a stored procedure from within a tigger. The reason being, if some updated happens to the table4, i need to propogate the some status till table1.As you...
May 13, 2009 at 9:55 pm
Ya Jack, this is the business requirement that the front end must show the real time data.however, we can have a refresh rate of 5min.
Further, its is required the transaction...
May 13, 2009 at 10:06 am
Viewing 15 posts - 16 through 30 (of 31 total)