• Difficult Select Statement in SQL

    I have a table with columns, to wit: FieldA FieldB A U B V C A C A C B D A D A D A E B E B E B I can get the records that are multiple in FieldA but whose values in FieldB are repeating with: Select FieldA, FieldB from table  group by FieldA, FieldB  having count(*) > 1 And the result will be:...

    bogeybetsy560 pointsBadges:
  • two dimentional output

    I have a table. The structure looks like this: id(pk) year col1 col2 date 1 2008 50 60 feb09 2 2008 40 70 feb10 3 2009 60 80 feb23 4 2009 50 70 feb24 5 2008 40 80 feb26 I have no idea how to write a sql query to output a table which includes the latest of record of 2008, and the latest record of...

    Zhao5 pointsBadges:
  • sql server 2000 in server

    Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg - aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer as the same...

    Radhaisgoodenough5 pointsBadges:
  • SAP UPGRADATION PROJECT PHASES ?

    Hi, Pl give some idea regarding the phases in sap upgradation project . For sap implementation there are 5 phases involved in it ,on similar basis is there any such phases involved during the upgradation of project .what are the pain areas & what are basic requirements from functional side to go...

    Sappsmm55 pointsBadges:
  • The most-watched IT questions this week: Feb. 2, 2010

    Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

    Michael Morisy8,323 pointsBadges:
  • controlling page breaks in a spooled SQL report

    I have written a SQL report that validates many of our tables.  Only when there is an error on a table will a report of that table print.  The script contains 32 different select statements each one associated with a different table.  I need to have a page break between the reports because the...

    Sherryborden85 pointsBadges:
  • problem in my pb11 application and sql2008

    this message apper to me on the client machine "ADO,net is not supported in your current installation"

    Nonosmm5 pointsBadges:
  • differences between SQL server 2000 & SQL server 2005

    Hai  Can any one tell me What are the Main differences between SQL server 2000 & SQL server 2005. Thanks and Regards

    Sukumardba5 pointsBadges:
  • Query Calculation Part of Select Criteria

    This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled - no dividing by two. How do I add this to my query? Thank you, SELECT "T16.CPRP".CP_DISTRICT_CODE,...

    lorit365 pointsBadges:
  • Need help executing MULTIPLE SQL extracts from a JCL

    GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

    Jonty Walker105 pointsBadges:
  • sql data conversion error 91Object variable or with block variable not setExecuting sql

    Error 91 Description: Object variable or with block variable not setExecuting sql statementRetrieving division information from the sql data store. Checking for the core database. Source: AFWSvDataServices3Converter.ConvertergetSQLDivisions, converter.convertergetdivisions,...

    Dmb07125 pointsBadges:
  • SQL Script with hyphen in the value set

    We have a particular piece of malware that will put some binary code in the HKLM/System/ControlSet001/Services/{5083B7D5-47AF-8FF9-657C651C2B10}/ I am using an sql script along with Microsofts logparser to parse some data out of the registry on a windows box and I am having trouble with the last...

    Markmorgan475 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:
  • Email Notification

    Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job... can anyone help me out with how i would go...

    Keirameister5 pointsBadges:
  • SQL Server 2005 Legacy DTS fails when run as a job

    When the DTS is run from SQL Server Management Studio within the Legacy Data Transformation Services the log shows Executed By: sqlagent

    Ftornoe40 pointsBadges:
  • Msg 102, level 15, State 1, Line 102

    I get this with an 'Incorrect syntax' messasge when I run a stored procedure. if I run the 'offending' code in isolation it works fine. If I tidy the code (e.g. remove line feeds etc), the error 'moves' to a different location. HELP!

    TonyDyer5 pointsBadges:
  • Exchange/POP 3 service fails to start

    I have server 2003 and exchange 2003 running. I have a user that requires pop3 for mail. When I reboot the server, I get a warning that ? An error occurred while starting the Microsoft Exchange POP3 Service: server instance number 1 failed to start with error 0x80040a01 When checking the services,...

    KillerX0 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • what is different from MSSQL, MYSQL and Oracle 11g?

    what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

    Juna060615 pointsBadges:
  • Grant users rights to run reports on reporting services

    How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source.  When setting up the source, we used windows authentication.  I've given clearance on...

    Cindyfiller45 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