• AS/400 CLLE: Get second member from physical file

    How to get second member from a physical file through SQL query or work query?

    vivekntt21450 pointsBadges:
  • SQL query: Get result from row3 and row6 only sometime row1 and 10 only

    PRIMARY KEY (A/C. NO.) ALSO EXISTS IN TABLE2 AND TABLE 3 TABLE1 TABLE2 TABLE3 TABLE3 a/c. no. Consum demand dues 65138546 2500 193 193 65138546 3100 696 696 65138546 3500 700 700 65138546 4000 763 763 65138546 6000 867 867 65138546 7000 1125 1888 65138546 8000 1281 1281 65138546 9000 1594 1594...

    235235235305 pointsBadges:
  • Process that causes full server memory in SQL Server 2014 database

    How can I find the process that causes my server memory is full used?

    ankurbhalani235 pointsBadges:
  • I/O error 23(Data error (cyclic redundancy check)

    I have encountered the below error message when I try to do SQL query. Server: Msg 823, Level 24, State 2, Line 1 I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x000001ac1c4000 in file 'C:\sql\PDB_Data.mdf'. Did a DBCC CHECKDB (PDB) WITH NO_INFOMSGS,...

    ronanggl5 pointsBadges:
  • Split Microsoft Excel data using SQL query

    Hello everyone, Most of the time, I've been using a SQL query in Microsoft Excel to display all of my data. But now, there's too much data (over 200 rows) and I need to split it up. So 100 side-by-side. How should I do this? I tried cut and paste but that didn't work. Thank you.

    ITKE1,102,115 pointsBadges:
  • How to update tables in SQL

    In SQL, I'm trying to update my tables using the update query. Here's my code so far: update tb1 set class='X' and SUB_CLASSIFICATION='XX' where id=12345 and loc='0250' and TYPE='I' and CLASSIFICATION='B10' Would this work? Thank you.

    ITKE1,102,115 pointsBadges:
  • Error message when executing SQL query through PowerPivot

    For the past several hours, I've been trying to execute my SQL query through PowerPivot but I keep getting this error message: "Unable to convert a value to the data type requested for table (massive hex string) column (name)". Then I tried SSMS and it worked fine. What's causing the issue? Thanks.

    ITKE1,102,115 pointsBadges:
  • How to schedule SQL query to run in Microsoft SQL Server

    I have a query that I want to automatically schedule to run daily. How do I do this?

    House5 pointsBadges:
  • What is the right way to write this SQL Query?

    I keep getting SYNTAX errors when I try to write this query, what is the proper way to write this query? Query question and table information is below. Return the last name and GPA of the top ten students by Cumulative GPA for students that were enrolled in at least one class during January 1,...

    dhay335 pointsBadges:
  • SQL: Which part should I execute first in which manner?

    What should I execute first? proc sql; select distinct e.firstname, e.lastname from sasuser.flightschedule as sasuser.staffmaster as b, sasuser.payrollmaster as sasuser.supervisors as d, sasuser.staffmaster as e where a.date=’04mar2000’d and a.destination=’CPH’ and a.empid=b.empid and...

    kapil956365 pointsBadges:
  • Edit SQL query in Crystal Reports

    I have an existed SQL query that I need to edit. But here's my issue: I have to edit it in Crystal Reports.

    ITKE1,102,115 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:
  • 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:
  • 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:
  • How I can do a row ID in SQL Server

    Hi, excuse me, I want to do some ask for you. How I can do a row ID in SQL Server because I need a row ID CE517DED-7A39-48B0-85BD-73B95018FACB. Because in Oracle I know than this is possible, but in SQL Server, I don't know. I hope you can help me please.

    LuisFer5 pointsBadges:
  • SQL query for customer’s data

    The owner of the shop would like to see each customer's id (name the column cus_id), name (name the column cus_name) id of their latest purchase (name the column latest_purchase_id) the total quantity of all flowers purchased by the customer, in all purchases, not just the last purchase (name the...

    Shruti16095 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 clone an Oracle user

    I have to clone an Oracle user but I'm not sure of the process. Is there a SQL query to do this? Basically - this user will have the same privileges but just with a different username. Thank you.

    ITKE1,102,115 pointsBadges:
  • Halt running MySQL query

    Each day, I usually connect to MySQL from a Linux shell. Every once in a while, by accident, I run a query that's way to big and I have to stop it. When I tried Ctrl+C - it stopped all of MySQL and I have to reconnect. Can I just kill this one specific query? Thank you so much.

    ITKE1,102,115 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