• Looking for a database name query in SQL

    Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a quick way of running a query to select records based on” current sysdate – 1″ i.e yesterday.

    Is there a quick way of running a query to select records based on current sysdate - 1 ie yesterday. Using Martin Gilbert's suggestion I get the current date & it works perfectly CD CHAR(CURRENT(DATE)) CURDAT SUBSTR(CD, 1, 2) || SUBSTR(CD, 4, 2) || SUBSTR(CD, 7, 2) Then use CURDAT in your selection...

    Gerrib150 pointsBadges:
  • Copying a SQL Server stored procedure with a query

    I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using co-related queries in SQL

    How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?

    SQL Server Ask the Experts2,585 pointsBadges:
  • how to access the p2p networks in a simple client

    can p2p network (emule bit torrent or kad network) can be queried with a native client as telnet ? if so, where can this query syntax are documented ? (white paper or an ISO ref. documents)

    Elad Karako255 pointsBadges:
  • mdb talk to jdbc

    is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not a jdbc...

    Elad Karako255 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:
  • Oracle Query: Return a date eg 29 February 2008

    Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance

    Csshahie5 pointsBadges:
  • Combined Address

    I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...

    Thuzinec10 pointsBadges:
  • oracle multi-field row query with more than one row

    I have a table that specifies the year, and a quantity for each month, in the same row. I need to get a 12 month rolling average, which involves particular fields from one row, and addition fields from another, based on the sysdate. There are several tables that need to be joined to ensure I have...

    Seashellm150 pointsBadges:
  • Query Criteria

    Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date...

    Bec10 pointsBadges:
  • How to make a single row in SQL

    Dear all, Please help me I am not good in sql queries. I have a view like this. SNo Employee title Cdate IN TIME OUT TIME 258 john accountant 27/01/2008 7:28:12 258 john accountant 27/01/2008 7:28:30 258 john accountant 27/01/2008 16:03:42 258 john accountant 27/01/2008 16:03:48 258 john accountant...

    Binu.emiliya10 pointsBadges:
  • a query

    I have query of Placement. as fallow: client OpenedDate ClosedDate 1 1/2/05 1/20/06 1 2/05/06 3/2/06 1 4/2/07 2 1/2/06 I want to add another field to this query to tell me each time how long a take this client to open again. and another field to tell me this is his 1st or 2nd time been open. Thanks...

    Kconnolly5 pointsBadges:
  • MS Access Query

    I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can't figure out how to run this. If I use the "Top 25" tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?

    Hollouise5 pointsBadges:
  • SQL Query that only Returns the Newest Invoice date for an ITem

    I am try to write a query that will give me a list of ITems that have a a quanity of greater than 0 on hand and only latest date and Item was invoiced. Here is what i have come up with so far SELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, IV00101.CURRCOST, IV00102.QTYONHND,SOP30200.SOPNUMBE,...

    Ken Foster20 pointsBadges:
  • Scheduling queries in AS/400

    What is the easiest way to schedule several queries to run several times throughout the day??? Will the Advanced Job Scheduler accomplish this or would writing a simple CL program be easier? Or is there any other methods?

    Johnny520 pointsBadges:
  • Oracle table column names starting with a number

    Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to keep the...

    Jaime0 pointsBadges:
  • How to write the query

    How to write the query from one table.(i don't want first row and second row)

    SQL Server0 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