Why use a simple solution when a complicated one works just as well? 😛

SET NOCOUNT ON

DROP TABLE #Temp

CREATE TABLE #Temp ([ID] Int identity(1,1),Skilltype varchar(1000))

INSERT INTO #Temp (Skilltype) select 'c, ...

Vaseem, try it with a little extra data...

INSERT INTO #Temp (Skilltype) select 'c, c++ (6),web development (6), java (3), unknown (21)'

INSERT INTO #Temp (Skilltype) select 'c# (15), design (12),windows...

This looks interesting Vaseem, would you mind elaborating with some sample data?

Cheers

ChrisM

Atif Sheikh (8/1/2008)

---

As far as I underrstood ur problem, you are already doing the job.

I dont know why are you going for TOP 1/

Just run the two queries...

Not really, you've lost the derived table d.

If you're comparing values from different rows of a table, then you have to join the table in more than once. You're...

Hi John

It's going to look something like this:

SELECT m.ProductID, m.ProductName, m.Price, t.Price

FROM MyPricingTable m

LEFT JOIN TheirPricingTable t ON t.ProductID = m.ProductID

WHERE t.Price - m.Price > 20

There's very little information...

You need to match the pattern at the beginning and end of the string, and in the middle, in different ways:

SET NOCOUNT ON

DROP table #Temp

CREATE TABLE #Temp (ID Int identity(1,1),Skilltype...

Untested, of course...

SELECT h.OrderID, h.OrderDate, h.address, c.address, p.cardno, c.cardno

FROM T_OrderHeader h

INNER JOIN T_Customers c ON c.CustomerID = h.CustomerID

LEFT OUTER JOIN T_Payments p ON p.OrderID = h.OrderID

INNER JOIN (SELECT h.OrderID, h.OrderDate,...

As a separate query to the one above, or built into it? Also, card number is in the customer table, are you sure you want to use card number from...

You're welcome, and thanks for the feedback.

Yes of course! Can you name the date column (and table) which you would like to use for this?

Hi Meeraj, apologies for the delay in replying to you.

Here's a script for creating a Numbers or Tally table, which you will see often on this forum.

IF EXISTS (select...

There's an answer in this, Meeraj:

SELECT * FROM [dbo].[uftSplitString] ('232,33,546,2,4,5,7,8,1091,223,3434', ',')

CREATE FUNCTION [dbo].[uftSplitString]

(

@String VARCHAR(8000),

@Delimiter VARCHAR(255)

)

RETURNS

@Results TABLE

(

SeqNo INT IDENTITY(1, 1),

Item VARCHAR(8000)

)...

Something like this?

SELECT h.OrderID, h.address, c.address, p.cardno, c.cardno

FROM T_OrderHeader h

INNER JOIN T_Customers c ON c.CustomerID = h.CustomerID

LEFT OUTER JOIN T_Payments p ON p.OrderID = h.OrderID

WHERE h.address <> c.address

and...