Comments by GJSS - CodeProject

GJSS 20-Jul-18 15:41pm View

Here i want to fetch the column value of A.SCAN_ID AS PRIOR_SCAN for all the projects returning from subquery 'a'.
Rowcount of subquery -15999
rowcount of whole query -16824

GJSS 20-Jul-18 15:38pm View

Insert into EXPORT_TABLE (PROJECT,SOLUTION,FIRST_SCAN,LAST_SCAN,PRIOR_SCAN) values ('park.Cash.Trading.csproj','TWSTicketing.sln',2491149,2514275,2514274);
Insert into EXPORT_TABLE (PROJECT,SOLUTION,FIRST_SCAN,LAST_SCAN,PRIOR_SCAN) values ('RBCheck.Services.ArchiveAndPurgeService.csproj','RB.Citi.GlobalCheck.sln',1989546,5385142,5384987);
Insert into EXPORT_TABLE (PROJECT,SOLUTION,FIRST_SCAN,LAST_SCAN,PRIOR_SCAN) values ('Cmb.UI.Framework.Core.csproj','BE2UI.sln',51839,61995,61994);

GJSS 13-Jul-18 17:31pm View

It's a typo while copying .but am able to run the query not getting the desired output

GJSS 13-Jul-18 10:55am View

Actual result
SECT REG USRN PRO_CT CATG TLT SN_YR_MN SN_YR SN_MN UQ_ISS_CT FILES_SN_ISS_CT
GC ASPAC cl84433 1 Log Handling Use of System.out.println 2018-05 2018 05 6 2
GC ASPAC cl84433 1 Log Handling Use of System.out.println 2018-05 2018 05 17 2
GC ASPAC cl84433 1 Log Handling Unsanitized data written to logs 2018-05 2018 05 1 1
GC ASPAC cl84433 1 Pin Management Hardcoded Pin 2018-05 2018 05 2 2
GC ASPAC cl84433 1 Race Condition Use of SimpleDateFormat class 2018-05 2018 05 23 2
GC ASPAC cl84433 1 Race Condition Use of SimpleDateFormat class 2018-05 2018 05 72 6
GC ASPAC cl84433 1 Code Correctness Secure Randomization - java.lang.Math 2018-05 2018 05 4 1
GC ASPAC cl84433 1 Code Correctness Secure Randomization - java.util.Random 2018-05 2018 05 20 2
GC ASPAC cl84433 1 Information Leakage HTML Comments in JSP 2018-05 2018 05 3 2
GC ASPAC cl84433 1 Information Leakage Use of printStackTrace 2018-05 2018 05 2 2
GC ASPAC cl84433 1 Information Leakage Use of printStackTrace 2018-05 2018 05 21 4
GC ASPAC cl84433 1 Password Management Hardcoded password 2018-05 2018 05 1 1
GC ASPAC cl84433 1 Cross-Site Scripting Unsanitized data written to an output web page 2018-05 2018 05 9 1
GC ASPAC cl84433 1 Validation and sanitization of untrusted data Validate data contained in hidden field 2018-05 2018 05 1 1
GC ASPAC cl84433 1 Validation and sanitization of untrusted data Untrusted data being used without validation 2018-05 2018 05 16 1
GC ASPAC cl84433 1 Validation and sanitization of untrusted data Untrusted data being used without validation 2018-05 2018 05 48 2

GJSS 13-Jul-18 10:51am View

Sorry ..am not able to format it.

GJSS 13-Jul-18 10:50am View

Here is my expected result

SECT REG USRN PRO_CT CATG TLT SN_YR_MN SN_YR SN_MN UQ_ISS_CT FILES_SN_ISS_CT
GCA ASPK cl845 2 Log Handling Use of System.out.println 2018-05 2018 05 23 4
GCA ASPK cl846 1 Log Handling Unsanitized data written to logs 2018-05 2018 05 1 1
GCA ASPK cl847 1 Pin Management Hardcoded Pin 2018-05 2018 05 2 2
GCA ASPK cl848 2 Race Condition Use of SimpleDateFormat class 2018-05 2018 05 95 8
GCA ASPK cl849 1 Code Correctness Secure Randomization - java.lang.Math 2018-05 2018 05 4 1
GCA ASPK cl850 1 Code Correctness Secure Randomization - java.util.Random 2018-05 2018 05 20 2
GCA ASPK cl851 1 Information Leakage HTML Comments in JSP 2018-05 2018 05 3 2
GCA ASPK cl852 2 Information Leakage Use of printStackTrace 2018-05 2018 05 23 6
GCA ASPK cl853 1 Password Management Hardcoded password 2018-05 2018 05 1 1
GCA ASPK cl854 1 Cross-Site Scripting Unsanitized data written to an output web page 2018-05 2018 05 9 1
GCA ASPK cl855 1 Validation and sanitization of untrusted data Validate data contained in hidden field 2018-05 2018 05 1 1
GCA ASPK cl856 2 Validation and sanitization of untrusted data Untrusted data being used without validation 2018-05 2018 05 64 3

GJSS 12-Jul-18 23:50pm View

It's tricky part to explain with sample data here.I can get my desired output by removing column 'PROJECT' from subquery 'a' but need to retain the same in select query where i need to refer the same in subquery 'b' in the join condition.

GJSS 31-May-18 16:36pm View

The data type of both source and target tables are DATE datatype only

GJSS 11-May-18 16:00pm View

Thank you, Wendelius.

GJSS 10-May-18 23:54pm View

What kind of index would be able to increase the speed of operation?

GJSS 10-May-18 23:51pm View

Thank you Wendelius. If we create a view to store the query results which has join and distinct.,how come it will get refreshed with updated data everytime? here we are supposed to run this proc on weekly basis to load the incremental data in target table.
In that case, can we go with materialized view?

GJSS 10-May-18 16:36pm View

Hi Wendelius - Am using same DB link which points to same database.Also we are referencing not only remote tables also the tables which are in local database. In that case, how come we create the view which includes the complete results of that select query?

GJSS 8-Apr-18 21:40pm View

Yes, it throws an error "end of statement" is valid with red highlighted color.

GJSS 5-Apr-18 17:03pm View

I tried with this query
DoCmd.RunSQL “Delete * from table1 where id in (select id from table2 where ENVRNMNT_STATUS = 'Prod' and RELEASE_FLAG= 'N')”

It didnt work it out

GJSS 5-Apr-18 11:42am View

Do.Cmd.RunSQL “delete * from table1 where id in (select id from table 2 where ENVRNMNT_STATUS = "Prod" and RELEASE_FLAG= "N")

GJSS 5-Apr-18 11:20am View

I accomplished it by using simple Vlookup command by copying the column values of 2 different excels in same excel with different sheets.

=VLOOKUP(A2,Sheet2!A:B,1,FALSE)

=VLOOKUP(A2,Sheet2!A:B,2,FALSE)

=EXACT(A2,C2)

=EXACT(B2,D2)

GJSS 5-Apr-18 11:17am View

Hi - I have accomplished this task by using the subquery running in SQL view in access DB.
Thanks for your assistance.

GJSS 30-Mar-18 14:08pm View

Here the ID value in excel 1 and system ID value in another excel are not in same order and it gets stored randomly.

GJSS 29-Mar-18 13:26pm View

Deleted

Hi - I tried with the below query in the Access DB SQL view and able to get the results but the same is not working while using in VBA access code. It looks like there is an issue with end of statement.

Do.Cmd.RunSQL “Select * from table1 where id in (select id from table2 where col1 = "X" and col2= "N")”

GJSS 27-Mar-18 14:41pm View

Can you assist me in using Access?

GJSS 26-Mar-18 17:45pm View

Code with "select case" worked out. Thank you Maciej

GJSS 26-Mar-18 16:27pm View

Those are all column values where it has multiple values but here am considering two column values based on these values am trying to update column BY
AY
147839
147839
147697
147697
147697

GJSS 26-Mar-18 16:16pm View

Yes..if the value of AY = "1478" and "1476", then i want to update the value of column BL with "XYZ"

GJSS 26-Mar-18 15:37pm View

Here am trying to update column BL with value "XYZ" based on the column AY with values 1478 and 1476

Comments by GJSS (Top 24 by date)