How to solve this ..?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

What have you tried?

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Ananth-431739 Ten Centuries Points: 1185 More actions · Answer 2

Ten Centuries

Points: 1185

March 24, 2008 at 11:23 pm

Could you post your issue properly???

Koji Matsumura SSCrazy Points: 2241 More actions · Answer 3

DECLARE @Table_1 TABLE (Col1 int, Col2 int, Col3 char(4), Col4 char(4))

INSERT INTO @Table_1 SELECT 1, 101, 'Usr1', 'WRK1'

UNION ALL SELECT 2, '101', 'Usr2', 'WRK1'

DECLARE @Table_2 TABLE (Col1 int, Msg char(20))

INSERT INTO @Table_2 SELECT 101, 'User %1 Logged on %2'

SELECT REPLACE(REPLACE(B.Msg, '%1', A.Col3), '%2', A.Col4)

FROM @Table_1 A INNER JOIN @Table_2 B ON B.Col1 = A.Col2

ORDER BY A.Col1