SQL Server Tag Directory

Featured SQL Server Questions

  • Dynamic SQL field name

    SELECT ryear rtcur racct rbukrs SUM( tsl06 ) AS tbal SUM( hsl06 )  AS rbal FROM faglflext INTO TABLE lt_bal WHERE ryear =<input>  AND rbukrs IN <input>  GROUP BY ryear rtcur racct rbukrs.     In the above query , how can I dynamically change the field name...

    saselvakumar18105 pointsBadges:
  • Add’l CPU per index?

    I'd love to use the LASTUSED column on SYSIBM.SYSINDEXSTATS introduced in DB2 9 to eliminate indexes. I can show my client a number of indexes that have not been used since DB2 9 was installed in July 2009. But I know they will ask 'what is the ROI on deleting these indexes?'. Is there any 'general...

    kjolson5 pointsBadges:
  • Sorting hierachy data alphabetically in SQL Server 2005

    I have a follow-up question to the article Navigate hierarchies using recursive common table expressions. I have an employee hierarchy that follows a similar pattern to the article, but I need to be able to sort my data alphabetically within each level. Do you have any advice on how to accomplish...

    SQL Server Ask the Experts2,585 pointsBadges:
  • full text search in sql server 2000

    can anyone tell me how I can get full text search to work in SQL Server 2000 ? Ive installed it, created a catalogue, selected a table (with a primary key) stepped through the wizard, in fact followed all instructions to the letter. When I run this query SELECT * FROM guidance WHERE CONTAINS(Title,...

    Mark...w10 pointsBadges:
  • What is the key for this relation?

    Please look at the ERD http://www.mepopo.com/image/1/38504 If I mapping the ERD into relational database schema R(k1, k2, k3, a, b) (which is before normalization). What will be the key for R? Thanks a lot! Jean

    farfrom15 pointsBadges:
  • Security Awareness training for FTI

    I am responsible for the Security Awareness program and I’m trying to put together my IRS Security Awareness training. I work for a government agency and we have to have annual training for security FTI (federal tax information) data, which is required by the IRS. I am looking for a video that we...

    mizblue10 pointsBadges:
  • Getting SQLCODE -518, while running EXECUTE Statement after PREPARE Statement in COBOL

    I am executing a dynamic SELECT query (No CURSOR- Normal SELECT) WS-STRING - SELECT MEMBNO FROM ENBMAS WHERE MEMBNO = "3535"  EXEC SQL                                     PREPARE SQLSELX FROM :WS-STRING...

    COBOL400Praveen30 pointsBadges:
  • AS400 – SQLRPGLE

    Hi, We are moving Values to Database Fields using Embedded SQL Concept. In Embedded SQL, We can decide the Variable Names dynamically. Is it possible with Display File? why?

    rajeshece1,215 pointsBadges:
  • Microsoft ISA Server 2000 – Firewall service deliberately stopped – Want to allow ping.

    Hi. This may seem really stupid, and well it is. I have a customer who is running ISA 2000 primarily as a web cache. It is not used for security in any way, in fact, users can just turn off their proxy settings and access the internet, so security is not really an issue here. The box is 4 years...

    Macleodp5 pointsBadges:
  • Dynamic SQL query

    Hi! I'm making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let's say is...in a form the user can search for records thru...

    Ayisha5 pointsBadges:
  • Create QA database with only some production tables

    I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've...

    Rwaltz5 pointsBadges:
  • How does oracle avoid dead lock when I create an index on the foreign key column?

    How does oracle avoid dead lock when we create an idex on the foreign Key column ? Found many experts say this, but i never really found what is the logic behind this. So any replies provided are appreciated . thanks in advance gangadhar

    Gangadhar2610 pointsBadges:
  • SP Dynamic SQL with LIKE Operator

    Hi. I want to create a stored procedure whereby the variable comes after the LIKE operator. For example, the code would look something like this: CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR SELECT * FROM TABLE1 WHERE FIELD1 LIKE '%@VARIABLE1%' Then to execute the procedure, EXEC SPFIND...

    Eabouzeid175 pointsBadges:
  • rpg sql

    I am using dynamic sql in an rpgle pgm. This pgm is called from 2 different menu options. When I take the 2nd option, everything works fine. I exit out of that option and take the first option. Everything is still work fine. I exit the first option and go back to the 2nd option and the pgm hangs up...

    mcg15 pointsBadges:
  • Microsoft SQL Server certification – Exams 70-433

    Anyone can help me to get microsoft dumps for 70-433 exam? I am looking for this for a long time. If you guys found out, please mail to the below email : raj_pandianin@yahoo.com Thanks in ADVANCE

    RajPandian5 pointsBadges:
  • ISA Server 2000 error 12202

    When I disable proxy in browser and have isa client installed and configured, I receive: ’ The ISA Server denies the specified Uniform Resource Locator (URL). (12202)’ What am i doing wrong

    123456300 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:
  • Rename Sheet when report exported to excel

    hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.

    Rachi5 pointsBadges:
  • SQL Server: Index and Key

    What is the difference between a key and an index? Whe I issue a SELECT statement, and the table has an index, do I still have to use my key?

    bogeybetsy560 pointsBadges:
  • dynamic temporary table variable usage

    We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can't resolve the problem. It occurs after the INNER JOIN on the...

    PaminBuckeyeLand15 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