• case when issue

    I recently came across behavior of a "case when" conditional expression that really confuses me. In this case: -- CASE when isnumeric('-10.00%') > 0 then convert(numeric, '-10.00%') end ---- the behavior is as I expected - the isnumeric() function returns 0 (cuz it ain't no number) so the "then"...

    Zhoover5 pointsBadges:
  • Using Local Variable as FILENAME in CREATE DATABASE Statement

    I am trying to use this statement in SQL Server 2000 :- CREATE DATABASE [Maintenance] ON (NAME = N'Maintenance', FILENAME = @TableName , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Maintenance_log', FILENAME = @LogFileName , SIZE = 1, FILEGROWTH = 10%) COLLATE Latin1_General_CI_AS GO The...

    TheHutt0 pointsBadges:
  • Sending Table Data From Oracle 9i To Sql Server 2005 using oracle 9i Trigger

    My aim is to send the data from oracle to sql server 2005 whenever there is data insertion, deletion or updation in the oracle table the same change needs to happen in the sql server having the same table structure as oracle.But I am not finding any way to accomplish this task.please help me. Have...

    Dhirendra100 pointsBadges:
  • Problem finding a column name.

    The following SQL is giving me the message: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'ProductCode'. How can I correct this code. The column name does exist in the table. I also want to group by Product Code and not by Container Name. Thank you. SELECT a.ProductCode AS "Product...

    Captnskirk0 pointsBadges:
  • Error tracing using triggers

    I'm running an application, using a SQL Server 2000. At some point we've implemented an error, that seems to cause the wrong data to be deleted from a table. We've tried locating the error both by browsing through the potential code likely to contain then error, and by logging different kinds of...

    LeChuck0 pointsBadges:
  • MS Access to SQL Server Image

    I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some code...

    DonMonroe0 pointsBadges:
  • Library management system

    i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse

    Eduado0 pointsBadges:
  • SQL Server Stored Procedure Editor

    I'm looking for a good editor for T-SQL stored procedures. Preferably one that will color-code keywords like what the default editor does, but will allow search and replace functionality as well as printing capabilities. Considering the budget I have, no to low cost would help as well. Thanks in...

    AaronCutshall0 pointsBadges:
  • DB2 function

    Hi! I am using following expression in report filter. It gives parsing error. Presentation Layer].[Recent Claims].[Specific Service Date YMD] BETWEEN (?Parameter1?) AND ((?Parameter1?) - 200 DAYS). The database is DB2. Please let me know what is wrong? Thanks a lot,

    Meenac0 pointsBadges:
  • exception join

    SELECT GRPID, MEMBER.PLNCD, MBIDT, MBSEX FROM MMEMBER EXCEPTION JOIN GPLANMAS ON MMEMBER.PLNCD = GPLANMAS.PLNCD This is a query used in showcase tool. It is looking for members who are noted in the member file with an invalid plan code. The current query produces 18 members with either invalid plan...

    Meenac0 pointsBadges:
  • ASP.NET performance degradation

    I'm running ASP.NET 1.1 on a Win2k server, application is written in VB.NET, with SQL server 2000 db on another box. ASP.NET application has very large pages with very complex data filled controls, but is only used on an Intranet by a small number of people. When users initially login, it performs...

    Infrastructure328080 pointsBadges:
  • calculation at database level

    Hi! I will really appreciate help. Please take a look at few rows of one table . MBRNO Readmit READMIT DATE READMIT Readmit Seq. NO DISCHARGE date NO. of days 121 1 20030101 20030105 5 2 20030105 20030115 10 3 20030202 20030218 3 4 20030218 20020220 0 The measure is count of cases. I do not want to...

    Meenac0 pointsBadges:
  • Oracle query to count rows in tables

    Does anyone have a PL/SQL script to count the rows in all the tables in a given schema? No use reinventing the wheel... TIA, Mike

    Mikron20 pointsBadges:
  • Integrating Connect:Direct with Sql Server DTS

    Don't know if any body has managed to - but i need to start a C:D process from within a DTS script. all the components are working independantly - however DTS waits indefinitely for the C:D process to finish - it does not seem to receive the return code. (or process it properly) Any Help/ideas much...

    UselessOne0 pointsBadges:
  • Database comparison

    I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...

    UselessOne0 pointsBadges:
  • Convert date format from UTC to PST in SQL

    HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu

    Ashug8bangalore0 pointsBadges:
  • Returning Multiple result sets to Excel

    I need to return a full result set including a number of Sum(s) Max(s) etc to an excel spreadsheet (don't ask why) from a Stored procedure on MS SQL2000. Problem is that Xcel can only handle a single result set per sheet... Any Ideas?

    UselessOne0 pointsBadges:
  • TopIndex property for .NET Web ListBox

    I'm trying to automatically scroll down to the last inserted item in a multi-select ListBox when only a few of the total # of rows are visible. Windows.Forms ListBox control has a TopIndex property that allows you to do that, but there is no similar property for the Web control. Note: In a single...

    Nohemi0 pointsBadges:
  • How to purge records from the database?

    I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure...

    Jinisha0 pointsBadges:
  • Calling a Function which uses ado command object in ASP

    Hi... I am calling a function or sub if u may call it from within the same page. it works fine until i execute a ado command object. as soon as i put the execute statement in the page, all activites stop and the page doesnt execute any further from the line calling that function. can u help me plz?...

    RKPatel0 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