RESOLVED IT MYSELF

SELECT Name,

MAX(CASE WHEN Subject= 'English' THEN Subject END) AS Subject1,

SUM(CASE WHEN Subject= 'English' THEN Marks ELSE 0 END) AS Marks1,

MAX(CASE WHEN Subject= 'Maths' THEN Subject END)...

Thanks all for helping. Got it after making some validations.

I tried it and its getting saved with null values.:(

To my knowledge, improper coding of the web applications that allows hacker to develop and inject their SQL commands and which allows access to our web app held in the...

Got it!

Hi Ed,

It's like I have a grid where I use a checkbox for bulk update by selecting multiple rows. Now I placed a footer template with the textbox below the...

Hi Jony,

I use this query and I get to see duplicate rows showing up for each row.

CREATE PROC Rep

AS

DECLARE @ReportingViews varchar

DECLARE @User varchar

SET @ReportingViews= CASE WHEN EXISTS(SELECT 1

FROM...

Got it sean! Thanks

Hi,

Thanks to all who helped me through this.

Thanks a lot, it worked!

Hi Lynn,

Is it possible to sort the User_Group column in this query.

For Instance:User_Group column has values like this

Hi

Hey

Hey

Hi

Expected Output should be like this

Hi

Hi

Hey

Hey

DECLARE @CCSG varchar

DECLARE @user1 varchar

SET...

Thanks a lot Lynn, it worked great.

Hi,

I am new to SQL and where should I declare that. I have no idea. If possible can you correct my query.

Yeah Nevyn,

Should have to consider you told. Its like we hardcore the group values and when changes are needed, its going to be really tedious.

Hi Sean,

I added information in the attachment. Hope this helps to sort out. Thanking you in anticipation.

Query for Scenario1:

SELECT *

FROM USER_PRFL up

INNER JOIN BSP_LOB_Grp_Lookup bl

ON bl.BSP_LOB_GRP = up.User_Group

INNER JOIN...