• Data selection in two tables

    There are 2 tables: Cust_table and order_table, column in table 1: cust_id, name, location , age, marital status(single, married, widowed) Column in table 2: Order id, Cust_id, order amount, month of purchase Questions: In a month how many times does a person place orders? Find the monthly expenses...

    Ashawalisingh5 pointsBadges:
  • Auto Replace Text in a table

    Is there a statement I can add that will automatically replace a text string with another string? EX> NORTH CHANGE TO BILLY BOB THROUGH OUT A FIELD

    Dapostman5 pointsBadges:
  • Table Names

    What are these table names: 0 0 1 23 136 Rentpath 1 1 158 14.0 And: select c.customer_id, o.organization_key, o.extn_dc from yfs_customer c, yfs_organization o where c.customer_id = o.organization_key and o.extn_dc = '005'

    Shellken6940 pointsBadges:
  • Problem inserting data using OPENROWSET in SQL Server 2000

    When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • MySQL syntax

    Hi, Have a table budget When I try this: MySQL: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a course no from table course 2 also represents: a course no from table course. It doesn't work. Any suggestions?

    Ak1bo78150 pointsBadges:
  • Table Entries

    Why doesn't all my table entries show on my report. Example: I have 100 cases (investigations) entered in my table, but when I run a report it only shows 89. Why does the other entries not show? I designed my query and I enter a "Begin Date" and "End Date" If I run it for the year, it only shows...

    dabonner10 pointsBadges:
  • Make a table

    How do you make a table?

    smurfkelley5 pointsBadges:
  • Hiding table tabs

    With basic hide when statement I am able to view one or more tabs based on selection. My problem is when I have all but one tab hidden and print there is extra space that represents the other tabs. for example I have a tab table with 6 rows and only row 1 is in use base on a selection from another...

    Njeterreese15 pointsBadges:
  • Adding from two tables in VBA

    Does anyone know how I can use VBA to take one value from one table and add to it a value from another table and then put that total into one field of the original table. I've been fighting with this for a couple of days so now i am looking for some help.

    Silverhawk10 pointsBadges:
  • Error when trying to drop a table that doesn’t exist in RUNSQLSTM

    If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?

    Gingertosser10 pointsBadges:
  • Constraints (MySql,tables,null,PK,FK etc)

    Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...

    Ak1bo78150 pointsBadges:
  • Random values selection

    how i can select random values from a coloumn from a given table

    Kamboj5 pointsBadges:
  • Problems from reindexing tables every day on a SQL Server

    We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Problems with the SQL query function

    I am designing a website, and I’m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command “select * from table where ref_id='1001',” it returns 1002, 1003...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Designing Table Layout

    Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?

    CMS5 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.