Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ArunPrithviraj

    MQ Exception 2009

    Hi Dian, I've not contacted IBM support. But I believe I'm using a supported version of the Websphere. This is because we have two environments SIT and UAT currently and in SIT things are running fine with the same applications. Thanks, Arun Prithviraj
  2. ArunPrithviraj

    MQ Exception 2009

    Hi, I had been working on the MDB off late and had encountered the following error while trying to send out a message from the my system to an MQ. All the connections are established when the service is brought up in Websphere. My application is hosted on WebSphere 6.1.0.11. On every incoming...
  3. ArunPrithviraj

    HELP WITH SELECT STATEMENT

    Hi Freemo, Use the ROW_NUMBER() OVER (ORDER BY column DESC) in case u r using SQL Server 2005 Thanks, AP
  4. ArunPrithviraj

    Dynamic SQL Insert Error when inserting INT

    yes, usually while constructing a dynamic query try to use nvarchar that is the usual standard and it has other implications too. Thanks, AP
  5. ArunPrithviraj

    Dynamic SQL Insert Error when inserting INT

    Hi Jon, In case you are trying to use dynamic queries I believe u will be using nvarchar as datatype for ur @sql variable and prefixing an 'N' before ur statement. Please look into the below code and try to understand how to solve the above issue. In case u have any queries do post back...
  6. ArunPrithviraj

    How to insert values into a table var from an SP

    Hi tons, Can you use a function instead of procedure? If that is the case, try out the following code and correct accordingly it would work for u... DECLARE @TAB AS TABLE (ID INT, TEXTDATE NVARCHAR(100)) //calling function to get the values to be inserted into tablevariables INSERT INTO @TAB...
  7. ArunPrithviraj

    Backup Data base SQL

    Hi Sat, Easiest way to backup a SQL SERVER is by 1. Right Click on the Database which u want to BackUp. 2. Go To Tasks 3. Select BackUp and rest u will get to know when u see the screens...its self explanatory. Thanks, AP
  8. ArunPrithviraj

    sales between inputs

    Hi Vidoevski, Not sure whether this will help. But in case u have time please try this and do let me know. SELECT OUTERTABLE.PRODUCT_ID, (SELECT MIN(INNERTABLE.DATE_C) FROM TABLE1 INNERTABLE WHERE INNERTABLE.INPUT IS NOT NULL AND INNERTABLE.PRODUCT_ID = OUTERTABLE.PRODUCT_ID ) AS...
  9. ArunPrithviraj

    Returning Table Value in Function for Select Statement

    SELECT count(*) AS numberOfClaims FROM ( select convert(nvarchar(8),U.user_name) as DEALER_NUM, convert(nvarchar(6),d.value_string) as DIST_NUM, ptd.Dealer_Name, ptd.Contact_name, ptd.Address, ptd.City, ptd.state as ST, ptd.ZIP, ptd.Country...
  10. ArunPrithviraj

    Cannot connect to Server

    Hi, Maybe it will be a bit too vague answer..But I would suggest you to check one main thing for this.... Try taking the configuration manager of your SQL Server and then enable the TCP/IP. Start Program files->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager...
  11. ArunPrithviraj

    If Exists

    Hi Dashley, I'm not sure whether by this time you might have found a solution for the above stated issue. But in case you have not or you find the below one is a better solution performance wise please go ahead. Check it out before you proceed only if u have time. IF EXISTS ( SELECT 1...
  12. ArunPrithviraj

    Normalizing the following data

    Hi, Please find below the best normalized form possible for your table. Country Table: country_id, countryname City Table: city_id, cityname Country-City Mapping Table mapping_id, country_id, city_id Province Table: Province_Id, StateProvince, StateProvinceAbbr, PostalCode, Latitude...
  13. ArunPrithviraj

    dB design question

    Hi, Can you be more specific like Is it when u r trying to select a set of photos etc? U will be able to give a where condition to get a particular set. Thanks, AP

Part and Inventory Search

Back
Top