• Types of JOINs in SQL

    What are the types of JOINs in SQL?

    vijaykumar110 pointsBadges:
  • How to use Crystal Reports with LINQ to SQL

    I know this is a broad question but this is the only way I can ask the question. I use Crystal Reports all the time. Is there a way I can use that with LINQ to SQL? At least someone can point me in the right direction, right? Thanks.

    ITKE1,050,660 pointsBadges:
  • Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • How do SQL related to this program?

    Can anyone tell me how SQL is related to my program?

    nlhabal5 pointsBadges:
  • SQL: Storing data in a column

    Sir, I want to know that in a table there are three columns like A, B, C. And I want to store the data on only A, B. When I insert the data, it automatically puts the result in C.

    Raju12345 pointsBadges:
  • Access SQL: Records from the Vendors table

    For Access SQL, how do I save records from a vendor's table

    NikiaBainton5 pointsBadges:
  • SQL query for descending order

    How do I input only each product’s name and sort them alphabetically (in descending order from Z-A)?

    ProfRockhill5 pointsBadges:
  • Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

    I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

    lindadawes5 pointsBadges:
  • SQL: In responsiblity wise last 5 transactions details request as on 31.03.2016

    AS per audit review request: All responsibility wise AP, AR, GL, CM , FA , PO, Inv last 5 transactions taken from the SQL as given date for 31.03.2016.  Please help on our request.

    Thillainathan5 pointsBadges:
  • SELECT hex in SQL shows error

    I am a python student. this instruction: SELECT hex(User.name || Course.title || Member.role ) AS X FROM User JOIN Member JOIN Course ON User.id = Member.user_id AND Member.course_id = Course.id ORDER BY X When I run it shows invalid syntax. I am taking a python course but I know very little about...

    cmorenme5 pointsBadges:
  • Can I load data using SQLLDR into an in-memory table?

    Can I load data using SQLLDR into an in-memory table and is this the best way? Thanks so much.

    rG1234565 pointsBadges:
  • SQL query for top 5 sales

    I want a query through which I can get a record of last one year sales. And it should show top 5 records for every day.

    atifmushtaq5 pointsBadges:
  • TMS configuration during migration to HEC

    Hi all, We are migrating to HANA Enabled cloud from On-Premise landscape. Current landscape is D->Q->R->P After phase two, R and D will be on HEC and rest on-premise. Trans directory is set as D. OS/DB will be changed to Linux/Sybase from Windows/SQL. Please let me know if TMS...

    BASIS125 pointsBadges:
  • How to left or right justifying a text file

    Hello programmers. I am using SQL to create a table from stored procedures and then streamwriter in VB.NET to create a text file based on the SQL table. Where and how do I control the right or left justification of the records in the text file? Thx.

    Ilfoprog50 pointsBadges:
  • How can I start my IT career?

    I am certified as ISTQB FL but I have zero experience and no knowledge about programming language but I am beginning in SQL. What other skills and IT knowledge to start my career?

    Ahmed12345675 pointsBadges:
  • Oracle: Count on only one table within select

    I have the following SQL and want to add to the query a count of records for each of the tables selected out of the user_tables, basically count(*). I've tried several things, but am getting only a count of 1. Any help would be appreciated. select substr(a.table_name,1,15) , substr(b.t$desc,1,40) 2...

    nemsmith30 pointsBadges:
  • Stored procedure to transfer data in Oracle SQL Developer

    How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer? stagging table (stagcoindesk) to (coindesk) target table. Was thinking about this code: CREATE PROCEDURE YourProcedure AS TRUNCATE TABLE YourTable INSERT INTO YourTable SELECT * FROM...

    dreamersai5 pointsBadges:
  • Needed help with SQL query involving password column in a table

    Hi, I have a requirement like I need to create a table with password column which should have any of the numbers between 0-9, any special symbols, alphabets. It should contain all the three combination. If the user try to insert missing any one should throw inserting error.

    vinu54615 pointsBadges:
  • SQL query on tourism forecasting

    I have 11 years monthly data of tourist in India. Now I want a SQL query to find the next year forecast for tourist.

    vijaydev19665 pointsBadges:
  • How to create monthly attendance report?

    TABLE I HAVE: Code Name AttendanceDate Status ---- ---- -------------- ------ A001 Abc Jan-01-2013 Present B001 Xyz Jan-01-2013 Present A001 Abc Jan-02-2013 Absent B001 Xyz Jan-02-2013 Late A001 Abc Jan-03-2013 Late Expecting below output with AVG attendance of month. Jan, 2013 Code Name 1 2 3 .....

    Sri100815 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following