Hi again,

If I'm not wrong you could also use the UNPIVOT funtion.

Check it out on BOL

thanks

Chris

Use the MAX function and then use a group by Close on the other fields.

indeed it was you 🙂

thanks

How about this:

INSERT INTO Pack_J_Price

(PackageID,

PartID,

PartsPricingID,

JobID)

SELECT

[PP].[PackageID],

[PP].[PartID],

[PPr].[PartsPricingID],

[PJ].JobID

FROM PartPackage [PP]

INNER JOIN PackageJob [PJ]

ON [PJ].PackageID = [PP].PackageID

INNER JOIN PartsPricing [PPr]

ON [PP].PartID = [PPR].PartID

AM I right in saying you want to insert into Pack_J_Price?

here is answer

SELECT [Vendor Name],SUBSTRING([Attendee Name]+' ', number,

CHARINDEX(' ', [Attendee Name]+' ', number) - number)

FROM MyTable [My]

INNER JOIN Tally [T]

ON number < = LEN([Attendee Name])

AND SUBSTRING('...

Sorry here is the link:

http://www.sqlservercentral.com/articles/TSQL/62867/

Look at the stepping through strings sextion.

HI,

Have a read in the articles sections for Jeffs create articles on Tally/Number tables 🙂

If you have trouble gives us a should

Thanks

Chris

HI Agree,

Having to put in spaces wasn't idea when you realised you had the wrong answer but had now replacement for it

HI 🙂

Thanks I thought that was the case and it makes 100% sense.

I was just trying my luck. I'm glad that I can't do it to be honest, as this...

Hi All,

Alternatively is it possible to add a nullable field without a default to a table that has data using a WITH NOCHECK?

Thanks

Chris

HI All,

I love this puzzle idea it's great.

I have a suggestion that if you want to blank our something that you have typed in that you have to put in...

he he he thanks Matt 🙂

(thinking about throwing a soft pillow)

It's a very sad I must, I really just learn't and started to get the full affect of bookmarks, but I guess I just wished for too much he he...

HI Steve,

Sorry I didn't explain myself correct.

normally if you have 2 or 3 scripts open and you start creating bookmarks on them, then if you save and close those scripts(keeping...