1
  • 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:
1

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following