• 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,000,710 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,000,710 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,000,710 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,000,710 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,000,710 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,000,710 pointsBadges:
  • How can I enable the MySQL query log?

    Would I be able to enable the MySQL query log function so each SQL query statement that we received from our clients is logged correctly (including time)? Can I use phpMyAdmin to do this? Thank you.

    ITKE1,000,710 pointsBadges:
  • SQL Server: Remove foreign key

    On my SQL Server, I have to remove the foreign key from one of my tables so I can insert different values. What SQL query should I use for this? Thank you very much for your help.

    ITKE1,000,710 pointsBadges:
  • Benchmark a SQL Server query

    Would there be a way I can benchmark a specific SQL Server query? I don't want to 3rd party tool either. Would SQL Profiler work for this?

    ITKE1,000,710 pointsBadges:
  • SQL query for max 5 salary from each month separately

    I need a SQL QUERY to select highest 5 salary of employees in each month separately. Can someone help?

    ASWATHY12345 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