Depending on what the procedure eware_get_identity_id does, I think this is what you're looking for.

INSERT Phone

SELECT

dbo.eware_get_identity_id('Phone')

...

Matt Miller (12/17/2007)

---

No yelling here....but let's see if we can do away with that cursor....It's got nasty overhead, and performance is usually why we get rid of them....

Could you post...

What does eware_get_identity_id do?

Can this be turned into a function?

If it's not too long, can you post it's definition?

I ask because I'm thinking that this can be done in...

Well, you could leverage the ROW_NUMBER() OVER() command in your proc and only return the rows needed that way.

But for some reason, I think it's more efficient to return the...

VB or VB.Net ?

If .NET, look into paging. That's not one of my strong areas, but I think that's what you need. and I'm not sure if it exists in...

Oh, and to turn it off ...

SET ROWCOUNT 0

SET ROWCOUNT n

Where n is the number of rows.

jamie.denman (12/13/2007)

---

This is great, have learnt loads. Thanks Even though am using MySQL and Oracle still very useful.

Quick one: most academic years are displayed as "06/07" any clue...

Use four apostrophes.

UPDATE yourTableNameHere

SET yourFieldNameHere = REPLACE(yourFieldNameHere, '''','')

Then ....

UPDATE yourTableNameHere

SET yourFieldNameHere = REPLACE(yourFieldNameHere, '-','')

Use replace ...

SELECT REPLACE('smith-jones-lewis', '-','')

Nothing magical here, I'm just looking over your shoulder Andras. 😉

Remove the SET= from the case as below ...

DECLARE @TableName nvarchar(Max),@Abbreviation nvarchar(100)

SET @Abbreviation='HH'

SELECT

@TableName =

CASE @Abbreviation

...

Try searching this site for split functions. They'll take your single text value and return a set of the individual values.

i.e...

http://www.sqlservercentral.com/scripts/Miscellaneous/31913/

And then there's the non-SQL question "Where would you LIKE to work/visit?"

I'd be willing to bet that the UK, US and other countries would have similar opportunities so the real...