I was able to create the stored proc but had to adapt the quotes and in the end I don't know if any of this is valid

CREATE...

Thanks Grant - YES I did tried straightforwardly to

CREATE VIEW view_name AS...

but it didn't work and lately, after some research, found out that it is not possible...

@phil-parkin perfect

thanks a lot

For personal knowledge, if the string doesn't always start by XX, but also with AA or BB or CC - how can I extract the string?

working beautifully thanks!

Say, there a table with a list of users that logged in a website - columns : year, month, weekday, ID, name , in the tablix I have this grouped...

I'm looking toretrieve 1 row per ID.
Thanks

I'm here, pretty much where you left off (added Value for C)

SELECT ID, [Value for A], [Value for B], [Value for C]
  CASE WHEN DATE...

Almost there.
This returns two rows per ID, I'm not showing the DATE, so can we have the VALUE for A defined by @p_date and the VALUE for B defined...

WORKS!
Thanks Sue_H

Still KO
The data presented earlier is not OK

P.s. It's always important to post in the forum that is relevant for the version of SQL server you're using. You've posted in the SQL Server 2000 forums,...

Thanks.
I'm using SQL Server 2008
Just tried the LAG, but it retrieves the whole history
Don't know how I can only get a row per ID, as I'm only...

ERRATUM.

Correct query :

select b.isin, a.market, a.ccy, a.stock_mkt, max(a.year)

,max(a.month), max(a.day) from market_table a inner join

isin_table b on a.id = b.id...