• T-SQL how to identfiy tables that have dulicate roaws

    I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks

    Techzon1225 pointsBadges:
  • Need help with a slow pl/sql script

    Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ---------------------------------- spool noaddressusagerelfix.LOG set timing on; SET SERVEROUT ON; DECLARE vpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE; vI_OCPOSTAD_USAGES TableB.I_OCPOSTAD_USAGES%TYPE;...

    Darrankavanagh20 pointsBadges:
  • How to delete a duplicate SQL Server entry in a single redundant table?

    How do you delete a duplicate SQL Server entry in a single redundant table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?

    Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement? Have tried the following, which do not work: column descr254_mixed format A30 set wrap off select descr254_mixed from PS REQ_LINE SELECT left(descr254_mixed, 20) from PS_REQ_LINE

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy Attachments to Folder

    Anyone have a lotusscript to copy attachments to a folder? Also need to extract to excel a view but right now i think i can handle that with NotesSQL ODBC. The attachments part is buging me the most. This is not a mail system.... We have a database setup for document approvals. Lotus Domino 6.5

    Maramor140 pointsBadges:
  • Executing a Stored procedure using Excel Macro

    I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVER REPORTING SERVICES

    can anyone explain what is presentation delivery utilizing reporting services?

    Swaroopa5 pointsBadges:
  • msforeachdb

    Could not locate entry in sysdatabases for database, when using msforeachdb

    Llsnowinaz5 pointsBadges:
  • Rookie using DSNTEP2 and IBM JCL – Need Help with JCL

    I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

    Jonty Walker105 pointsBadges:
  • Help needed for date dimension which is not rolled up properly.

    I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...

    Sree11195 pointsBadges:
  • sql scripts

    Hi all, i'm updating a new 'commun management' software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create........... Drop........... Alter........ so our clients would be able to have access to it. but i have been asked to write...

    JARON5 pointsBadges:
  • Problem converting Access SQL query to T-SQL 2005

    I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between the 2,...

    Chunkydrew15 pointsBadges:
  • Creating JCL to execute a large merged file of SQL for DB2

    I need to create a JCL that will execute - individually - SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?

    Jonty Walker105 pointsBadges:
  • Can SQL make noises?

    can you get SQL to 'make a noise' to indicate when a query has been executed? I.e. for long running queries, you wouldn't have to keep checking

    Melanie.king5 pointsBadges:
  • sql instance

    what is a sql server instance for? thanks.

    CarlosH5 pointsBadges:
  • Veritas vs. SQL Server 2005

    Why will SQL Server not accept files restored from Veritas backups?

    Patticake5 pointsBadges:
  • iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd

    Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...

    MarcGreen20 pointsBadges:
  • Journey from SQL/400 to SQL Server Development

    I'm fairly comptent with SQL/400 , scripting, etc. - - how difficult would it be to applying this to learning something like "SQL Server" ?

    Tsmith7155315 pointsBadges:
  • VFP9 DBF to Ms SQL

    is there tools available for converting VFP9 DBF to Ms SQL? or what is the best approach? thanks.

    B385 pointsBadges:
  • SQL Macro

    I need a SQL macro to populate a form? Please help. wkharrell@gmail.com

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

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