• Separator Line in ASP.NET Gridview

    Hello, I’m relatively new to ASP.NET and SQL, so what I’m asking maybe a simple question for some, but not for me. What I have is a Grid View that I’m trying to populate softball hitting statistics with. In it I’ve stacked statistics yearly statistics on top of career totals at the very...

    Rtodd5 pointsBadges:
  • top values and ranking

    What function do i use to give a field a ranking based on it's current sorted position in a query. I do not want to use a running sum on a report - it needs to be in the underlying query as I am going to have to join several together.

    PenguinWaddle5 pointsBadges:
  • SQL script to disable views after a demo period.

    Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...

    Katiekat5 pointsBadges:
  • Crystal Reports Duplicating Records

    Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...

    Simonlevey5 pointsBadges:
  • SQL/400 Call Level Interface

    The option set thru the SQLSetConnectionAttr call persists until the next SQLSetConnectAttr call. If I need to set another option, how do I know that the effect of the previously set option is no longer required? Can I set connection attributes after I have connected to the database? Thank you for...

    LBurkett99830 pointsBadges:
  • Access paths no longer valid

    Ok, the plot thickens. I'm trying to identify and rebuild LFs that after an abnormal shutdown and normal ipl, are no longer being selected for SQL and QRY. These files are not damaged, but program response has taken a major hit due to these views not being selected. After researdhing one known file...

    Modiyooch540 pointsBadges:
  • jsp–param and sql:update

    Hello, Could anyone tell me if I need to do something special to use a param value as an sql insert statement in <sql:update>? The param value displays fine if I use <c:out>, but the value doesn't get inserted in a table by an insert statement.

    Eoeo5 pointsBadges:
  • understanding and detecting sql performance situation with abnormal 400 shutdown

    Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...

    Modiyooch540 pointsBadges:
  • Delete variable file in SQLRPG

    How can I use any variable file in an instruction SQL of DELETE in SQLRPG?

    Samuele5 pointsBadges:
  • How to pass month to MonthToDate?

    I am trying to figure out a way to pass in the month to the monthtodate function or a date.

    Ricm25 pointsBadges:
  • login failed

    when i start debugging project,sql connection will be closed,before that it will be open .Iam using sql which comes along with vb.net 2005.Iam using sqlconnetion in login form also there its not giving error when i used sql connetion code in another form its giving error login failed .iam tried up...

    Shaz255 pointsBadges:
  • Alter SQL table

    hi i have a set of data number | code 1 | abc 2 |ff 3 |aa 3 |bb 4 |cc 5 |dd 5 |ee and i'm wondering if there is a way to convert this data so it looks like number | code1 |code2 1 | abc |null 2 |ff |null 3 |aa |bb 4 |cc |null 5 |dd |ee thx

    Lazy16755 pointsBadges:
  • hourly backup schedule

    have a question about client schedule settings. My problem is that I am using TDP for MS SQL and i want to backup database logs every hour but only during productive hours, e.g. from 6am til 5pm. The only way I solved is to create each schedule for each hour, because if i set parametres "period"...

    Khn06645 pointsBadges:
  • SQL error

    DECLARE BEGIN FOR C1 IN (SELECT A.BANK,A.BRANCH,A.MODULE,A.SCHEME,A.ACCOUNTNO,A.ACCOUNTISN,NVL(T.NEXTDUEDATE,:TDATE) NEXTDUEDATE,A.REVIEWDATE FROM ACCOUNTMASTER A,TERMLOANSDATA T WHERE A.BANK=:INPBANK AND A.BRANCH=DECODE(:INPBRANCH,'ALL',A.BRANCH,:INPBRANCH) AND A.MODULE=:INPMODULE AND...

    Shindetanaji10 pointsBadges:
  • DBCC CHECKDB

    before runing DBCC CHECKDB WITH repair_allow_data_loss, How can i know what table and data that will be deleted

    Sreenu125 pointsBadges:
  • Finding nth most recent action with SQL

    I am trying to determine the date on which a certain number of things have happened cumulatively, eg I have a varying number of buyers each month. I want to find out on what date of that month, those buyers make their 3rd purchase. My SQL doesn't seem to support TOP or ROWCOUNT so I would...

    Munona995 pointsBadges:
  • SQL Log files

    Can I delete a SQL log file

    RSCC5 pointsBadges:
  • Execute command in SQL

    can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N'insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,'+ '''Cash'''+' as PayMode,CashAmount...

    Ash1235 pointsBadges:
  • SQL Studio Express scheduled backup

    I need a scheduled backup for a standalone SQL database on an XP Pro PC. I have Studio Express installed and this does not have a scheduling utility. Can anyone suggest a way of achieving this without the expense of an SQL Express license

    James015 pointsBadges:
  • Error when using SQL*Plus @@ command in SQL Navigator

    When I try to use the @@ SQL*Plus command in a script I get the message "ORA-00936: missing exppression!" when it reaches the line containing this command. I read the help and they say that the @@ command is admitted. I've tried the same script in Oracle Enterprise Manager...

    Imre5 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