Hi, Welcome To SSC.

It is never supposed to be this simple but won't the following get you the 80% accurate Search you need??

Select Top 1 * From <TableName>

Where FirstName LIKE...

Very nice solution Chris.

Sorry for my last post. I had missed(not understood, actually) the "B--Buy, S--Sell" part. That is why I was asking for a Transactions Table. My bad.

You're very welcome.

I'm glad it worked out for you.

dwain.c (6/18/2012)

---

vinu512 (6/18/2012)

---

You can do it like this as well:

--Creating Temporary Table

CREATE TABLE #Test

(

DateTimeStamp datetime,

Value int

)

--Inserting Sample Data

INSERT INTO #Test SELECT '2012-06-15 16:00:00.000',4

INSERT INTO #Test SELECT '2012-06-15 2:05:00.000',5

INSERT INTO...

dwain.c (6/18/2012)

---

vinu512 (6/18/2012)

---

harri.reddy (6/17/2012)

---

alright,consider this

i have 1 variable

declare @temp1 nvarchar(50)

set @temp1 = 'P=70'

now in 1 column i need p and in another i need 70 ,from @temp1

so i need function...

How is SQL Server supposed to know that you have a FIFO business logic in mind.

Do you have a transactions table where you record the Transactions, quantity sold/bought, Date of...

harri.reddy (6/17/2012)

---

alright,consider this

i have 1 variable

declare @temp1 nvarchar(50)

set @temp1 = 'P=70'

now in 1 column i need p and in another i need 70 ,from @temp1

so i need function who can...

You can do it like this as well:

--Creating Temporary Table

CREATE TABLE #Test

(

DateTimeStamp datetime,

Value int

)

--Inserting Sample Data

INSERT INTO #Test SELECT '2012-06-15 16:00:00.000',4

INSERT INTO #Test SELECT '2012-06-15 2:05:00.000',5

INSERT INTO #Test SELECT...

ann 31613 (6/17/2012)

---

Hi All,

I have written a html query (please see below) and would like the query to hide On hand Qty which are zero. Can someone help me?...

You can do it as follows, but the results would vary according to the Order in the chosen Execution Plan.

The results may not be universal in this case as there...

Lucasprss (6/17/2012)

---

I would like to know what is the syntax to move existing data from one table to another, for example tblAsset which contains Policy No (INT), PolicyStart(DateTime) and PolicyEnd(DateTime)...

Thanks a tonne Anthony.

I'll do some reading and understanding and lets see where I can get with it.

Thanks again,

The Sql Server Gurus are really fast here at SSC. 😀

By the time I read the new thread, it was all done and dusted. 😛

Nice work Lynn and Dwain.

ChrisM@Work (6/15/2012)

---

anthony.green (6/15/2012)

---

Thanks guys, much appreciated. Was racking the brain yesterday on that and for the life of me couldnt get unpivot working.

I like the idea of the values...

You're welcome.

Could you please post the solution so that other visitors to this thread(including me and Lynn) could know what was wrong and how you...