Database

SET CONCAT_NULL_YIELDS_NULL ON;
GO

CREATE FUNCTION Function_StripHTML(@Text NVARCHAR(MAX), @BreakLine BIT)
RETURNS VARCHAR(MAX)
AS
BEGIN
	DECLARE @XML AS XML
	
	IF @BreakLine = 1
	BEGIN
		SET @Text= REPLACE(REPLACE(REPLACE(@Text,'<br>', CHAR(13)), '<br/>',CHAR(13)), '<br />',CHAR(13))
	END
	ELSE
	BEGIN
		SET @Text= REPLACE(REPLACE(@Text, '<br/>','<br>'), '<br />','<br>')
	END
	
	SET @XML = CAST(('<x>' + REPLACE(REPLACE(dbo.Function_RemoveInvalidCharacters(@Text), '&', '&'), '<', '</x><x>')+'</x>') AS XML)
	
	SELECT
		@Text=
		(
			SELECT
				CASE WHEN LEFT(N.value('.', 'VARCHAR(MAX)'), 3) = 'br>' THEN
					'<' + N.value('.', 'VARCHAR(MAX)')
				ELSE
					STUFF
					(
						N.value('.', 'VARCHAR(MAX)')
						, 1
						, CHARINDEX('>', N.value('.', 'VARCHAR(MAX)'))
						, ''
					)
				END
			FROM
				@XML.nodes('x') AS T(N)
			  FOR XML PATH('')
			, TYPE
		).value('.', 'VARCHAR(MAX)')
	
	RETURN LTRIM(RTRIM(@Text))
END
GO

Member 2458467 wrote:

in the form of DBO.*

MSDN[^]:

For example, if user Andrew is a member of the sysadmin fixed server role and creates a table T1, T1 belongs to dbo and is qualified as dbo.T1, not as Andrew.T1. Conversely, if Andrew is not a member of the sysadmin fixed server role but is a member only of the db_owner fixed database role and creates a table T1, T1 belongs to Andrew and is qualified as Andrew.T1. The table belongs to Andrew because he did not qualify the table as dbo.T1.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Member 10392875 wrote:

Please provide me the answer as soon as possible.

Select IsNull(C.CompanyName, P.PersonName) Contact
From LinkTable L
Left Join ComapanyTable C on C.CompanyID = L.CompanyID
Left Join PersonTable P on P.RealPersonID = L.RealPersonID

SELECT DISTINCT p.prod_id, p.model, p.showpricing, p.image_file, p.image_width, p.image_height, p.image_border, p.name, m.manufacturer,
  CASE WHEN sp.price IS NULL THEN 0 ELSE sp.price END AS list_price, 
  CASE WHEN sp.price IS NULL OR ssp.discount IS NULL THEN 0 ELSE sp.price - ssp.discount END AS sale_price, 
  CASE WHEN NOW() BETWEEN p.mfgrebatestart AND p.mfgrebateend THEN p.mfgrebate ELSE 0 END AS mfgrebate 
  
  FROM comm_product p
  INNER JOIN comm_manufacturer m ON p.mfg_id = m.mfg_id 
  INNER JOIN comm_dept_prod dp ON p.prod_id = dp.prod_id
  INNER JOIN comm_partners_products pa ON p.prod_id = pa.prod_id 
  LEFT JOIN comm_sku_price sp ON p.default_sku_id = sp.sku_id AND NOW() 
  
  BETWEEN sp.date_start AND sp.date_end 
  LEFT JOIN comm_sku_sale_price ssp ON p.default_sku_id = ssp.sku_id AND NOW() 
  BETWEEN ssp.date_start AND ssp.date_end 
  
  WHERE pa.p_id = :partnerID 
  
  AND p.avail_type < 3 AND p.image_file > '' 
  AND p.model NOT LIKE 'EBAY-%' 
  AND p.dept_ad = 1 
  AND dp.dept_id = :deptID 
  
  ORDER BY rand() LIMIT 4

jkirkerx wrote:

Wow thanks

jkirkerx wrote:

I don't understand the ANSI JOIN versus the implicit, guess I can Google that to
learn exactly what was wrong.

abhi17_6 wrote:

Problem is that this app is not able to connect to oracle 10g database server
though it is able to connect to some other 11g R2 database server.