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...

Hi kramaswamy,

Thank you so much!!!

Regards,

Naveen

Hi,

The representation of value in Table1 in sequence is as follow

ResID S1 S2 S3 S4 S5 S6

1 0...

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...

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...

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]...

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

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...

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!!!

Hi All,

My Nested code is similar to the below code template

CREATE PROCEDURE usp_Proc1

AS

BEGIN TRY

BEGIN TRAN TRAN1

...

Thanks a lot!!!

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

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...

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...

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...