Search results for query: *

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

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...

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

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

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...

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...

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

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...

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...

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...

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...

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...

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