• SQL Server 2008 tables

    I  have 2 tables, tanle1 and table2 Can someone help for  SQL query  for table3 with 2 colums colum 1  is select number from table1 for colum2 in table3  I need to get the total number of times  each number in colum1 of table1 apears in in colums n1,n2,n3,n4 of all events in table2 as shown...

    Ajibola110 pointsBadges:
  • SQL and Dates

    Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||'/'||SUBSTR(BMDTOR,7,2)||'/'||SUBSTR(BMDTOR,3,2)))/30 AGE,...

    jschultz385 pointsBadges:
  • Oracle Reports Builder

    Hi, i have one query plz help me on the same.... I am creating the report in oracle report builder 6i,  i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. of same customer name in a month which...

    Ss66015 pointsBadges:
  • SQL Server 2005 query

    Hello sir I am new to sqlserver when retriving data like name gender sal deptno df F 100.00 10 mf M 1100.00 10 if M 1010.00 10 uf M 1000.00 20 yf F 1200.00 20 gf F 1030.00 20 hf M 1005.00 30 ff F 1040.00 30 from this i want retrive deptno maletotal sal female total sa 10 2110 100 20 1000 2230 30...

    Udaya5 pointsBadges:
  • T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)

    Hell Kent, I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries...

    Cavallino30 pointsBadges:
  • trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.

    We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What's the "condition" selected and how's the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any...

    CHENS265 pointsBadges:
  • How to write text into word doc using SQL 2000 query analyzer

    how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

    Pkaur65 pointsBadges:
  • Filename from SQL 2005 Query

    I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column in the query. All...

    Apbarker5 pointsBadges:
  • Importing a “flat” field into a Lookup Table format in SQL database

        * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...).     * I have created a table...

    Roguetexan5 pointsBadges:
  • PL/SQL Query

    Create table other_sess( s_name varchar2(10)); insert into other_sess values('s2007'); insert into other_sess values('s2009'); insert into other_sess values('s2009'); commit; now i want to write a PL to retrive data from these sessions (s2007, s2008, s2009). from my current session. declare...

    FaheemNawaz15 pointsBadges:
  • openquery no records returned SQL Express 2008

    I run theis procedure against a link server (Quickbooks) It runs with no errors but will not return records. SELECT   *   FROM QODBC ...Customer

    Dendic5 pointsBadges:
  • Infinite recursion in SQL Server 2000

    consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?

    Gomsbk35 pointsBadges:
  • Translate Ruby Script to SQL Query?

    I need help translating a ruby script to SQL query. I'm a SQL noob. Help please. [em]here is the script.[/em] require "rubygems" require "ruport" SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle,...

    Transom3245 pointsBadges:
  • Will the SQL performance improvements in V6R1 affect QUERY?

    Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

    Fw15 pointsBadges:
  • Embedded SQL in RPGILE

    For a SELECT Query in RPG program if we get -811 SQL error, it means we have got multiple selections in our query. Is it possible to know how many records are selected from the SELECT statement from any field of SQLCA or in some other way?

    TNKR130 pointsBadges:
  • Query Manager Error

    Type SQL Statement ************************** Beginning of Data ************************* 0001.00 SET MISC :MISC6 0002.00 SELECT bcbgcd COLHDG("MISC" "CODE"), 0008.00 &MISC LEN(4,0) COLHDG("SHARED CONTAINER" "CODE") NAME(MISC) 0009.00 FROM lmbcrela 0012.00 WHERE bcbgcd=&MISC In checking the SQL...

    a1maida150 pointsBadges:
  • Basic Access Database query question

    I have an "Early voter list" table that I queried for matches against a "Dem Voters" table with the results generating a new "Identified Early Dems" table.   I would now like to query the "Identified Early Dems" table against the original "Early voter" table and be left with a table of "Early...

    Sharx2th5 pointsBadges:
  • xp_fileexist workd in Query window but doesnt in stored procedure

    Hello, I am running on SQL server on my local PC . I am singed onto the PC using a network user. This probelm happens if the SQL server service runs as either Local system or network service. In the server management studio if I go to a query window and enter Declare @result int exec xp_fileexist...

    Kendo5 pointsBadges:
  • What is a linear recursive query in SQL?

    What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

    Gomsbk35 pointsBadges:
  • iSeries Navigator SQL Script Output

    I'm not familiar with CL but is there an easy way to direct the output of an adhoc SQL query in iSeries Navigator into a CSV file in my local Windows drive? Thanks in advance.

    Jaggerdude60 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