I am just giving it a wild guess, I had not seen that in SQL Server atleast. Lets if someone knows about it. Otherwise what you can do is create...

You are welcome. 🙂

You should give data like this to get an answer. See if this solution works in your case.

CREATE TABLE Group_Test(Group_ID int, Status varchar(5))

INSERT INTO Group_Test VALUES(1, 'NPL')

INSERT INTO Group_Test...

Hi Sharon,

I was closely watching this post if anyone would reply with an answer. I wanted to ask if you could check any other small 'MSI installation' on the machine...

I know! In Toad you will be prompted with an input box to enter the values.I am not sure if it is there in SSMS. Lets see if anyone else...

Not sure if this is what you were looking for,

Create...

Sample quey is:

select bg.[Group ID],

bg.[Number],

[Status]

from

...

You're welcome:-)

Thanks Garadin and thanks Mark. We would have to work our way out using these two operators!!!!.

Mark (8/31/2009)

---

naveenreddy.84 (8/31/2009)

---

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

I cant give the entire query, try creating row_id partition by date and your id. Create a temporary table of this may be. Cross join tables. Look for the existence...

Yes you can have multiple instance...

Assuming its the tli1.updatetime in the select clause, I am guessing yes. Try giving tli2.updatetime in the select query as well? That is what you need isnt it?

Thanks all for all your help. Temporarily managed to push the data into the database using your suggestions. Its nice to know that you all explain 'whats really happening' rather...

Thanks Florian, it works that way.

I was just curious to know what was happening.

Point is...