• Nested XML question

    I am working on a big project that needs to output multi-level nested XML. I'm running into an issue when trying to go past 2 levels.deep. The SELECT uses 4 different tables; one for each level. My question is: Is it best to use FOR XML PATH or FOR XML EXPLICIT when trying to create XML that is...

    CeeGee5 pointsBadges:
  • SQL query for employee salaries

    How to display the third and seventh employee salary details?

    Rekha0 pointsBadges:
  • Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

    We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set this database into Bulk-Logged Recovery Model? We are taking full backups on daily basis. So is there...

    bugarl5 pointsBadges:
  • using group by by joining 2 tables SQL

    there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title  group by job_id

    Lak5 pointsBadges:
  • SQL question

    One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name    salary   department iioo      10000    Technical aaaa    15000     HR pppp    17000    ...

    Hema19865 pointsBadges:
  • Converting date time in C#

    hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save to...

    Zubairm765 pointsBadges:
  • convert SQL datetime to date only

    Using SQL, how can I convert a data in a datetime field to a date only data? When I run a job to collect data, I use the getdate() function that returns the date and time. I want to then convert this to the same date but with a time of 00:00:00. Please advise. Thanks! ~Gina

    Gina35 pointsBadges:
  • Crosstab query in SQL

    How to make crosstab in my sql?

    Tafz085 pointsBadges:
  • SQL MS Access – Displaying output in a certain order

    Hi Team, SELECT mergeddatabase.Roomno, Count(*) AS Boxesscanned, Sum(mergeddatabase.Currentweight) AS RoomsTotalweight, mergeddatabase.Currentdate AS RequestedDate FROM mergeddatabase WHERE (((mergeddatabase.Currentdate) Between [Forms]![FrmDateRange]![TxtStartDate] And...

    Witsend10 pointsBadges:
  • Oracle RR Date Format

    Can anyone tell me about RR Date format in Oracle 9i (SQL)?

    JOGENDER20095 pointsBadges:
  • Oracle opportunities

    I completed my B.E in 2009, so I want interested to go to Oracle side, so I know the concept of SQL and PL/SQL. Relating to this I dont have a project of this. So please give me some titles of project at least I can go through this. Regards.

    Ingalagi5 pointsBadges:
  • Export data from Forms to Excel

    How to export the selected data from Forms to Excel?

    Brithivi5 pointsBadges:
  • Selecting multiple members at a time in SQL

    I have customer file (CUSFILE),this file having 3 members (JAN, FEB, MAR). Using ALIAS,I can select only one member. CREATE ALIAS CUSMBR1 FOR CUSFILE(JAN). SELECT *FROM CUSMBR1. How to select multiple members at a time in SQL. Please help me.

    chowas400585 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • Displaying SQL data in ASP.NET

    I've put data in a description field in SQL; how can I display it in ASP.NET?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Free SQL software with interface to enter data

    Hi, I need to enter about 5000 lines of data with about 10 columns. and then I would query the data (by lets say SQL, but I'm open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view only that data...

    Maqib1005 pointsBadges:
  • Sql Server 2005 ensure columns sum within a table

    How can I ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?

    Timmytong5 pointsBadges:
  • AS/400 compare files

    I want to compare two files without using SQL and logical file. I have written a code but I didn't get exact out put. Please look into the below code and help me guys. File:test1 Keyfield=accid ACCID   ACCNAME 1   siva 2   hari 3   vinayaka File:test2 no key field here ACCID   ACCNAME...

    chowas400585 pointsBadges:
  • Project on class diagram plotter using Java and SQL

    Hello Sir / Madam, I got project on class diagram plotter. I need proper guidance on this topic because I need to submit synopsi .

    Shal235 pointsBadges:
  • Convert time to GMT time

    In T-SQL, I want to store the date from the getDate() function in GMT time instead of local time.

    Apinto5 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