Viewing 14 posts - 1 through 14 (of 14 total)
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...
July 23, 2020 at 3:01 pm
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...
July 23, 2020 at 12:45 pm
@phil-parkin perfect
thanks a lot
March 2, 2020 at 2:46 pm
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?
March 2, 2020 at 2:04 pm
working beautifully thanks!
March 2, 2020 at 1:38 pm
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...
November 22, 2017 at 6:02 am
I'm looking toretrieve 1 row per ID.
Thanks
October 25, 2017 at 4:26 am
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...
October 25, 2017 at 4:11 am
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...
October 25, 2017 at 1:58 am
Still KO
The data presented earlier is not OK
September 20, 2017 at 4:57 am
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,...
September 20, 2017 at 3:54 am
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...
September 20, 2017 at 3:18 am
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...
August 5, 2015 at 12:52 am
Viewing 14 posts - 1 through 14 (of 14 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy