View difference between Paste ID: 4nRVvMBp and 8T2Fi7Pr

 
 /*
-0=Int
+
-1=String
+<option value="0">Int</option>
-2=DateTime
+				<option value="1">String</option>
-3=Lookup
+				<option value="2">DateTime</option>
-4=YesNo
+				<option selected="selected" value="3">Lookup</option>
-5=Decimal
+				<option value="4">YesNo</option>
-6=Currency
+				<option value="5">Decimal</option>
-7=Url
+				<option value="6">Currency</option>
-8=Guid
+				<option value="7">Url</option>
-9=Document
+				<option value="8">Guid</option>
-*/
+				<option value="9">Document</option>
 				*/
 
 CREATE VIEW [dbo].[cust_CCIW_v_person_attribute]
-SELECT CASE a.attribute_type
+
-		WHEN 1
+     SELECT CASE a.attribute_type
-			THEN varchar_value
+                WHEN 0
-		WHEN 2
+				THEN CONVERT(VARCHAR(50),int_value)
-			THEN CONVERT(VARCHAR(10), datetime_value, 101)
+				WHEN 1
-		WHEN 3
+                THEN varchar_value
-			THEN (
+                WHEN 2
-					SELECT l.lookup_value
+                THEN CONVERT(VARCHAR(10), datetime_value, 101)
-					FROM core_lookup l
+                WHEN 3
-					WHERE l.lookup_id = pa.int_value
+                THEN
-					)
+     (
-		WHEN 4
+         SELECT l.lookup_value
-			THEN CASE int_value
+         FROM core_lookup l
-					WHEN 1
+         WHERE l.lookup_id = pa.int_value
-						THEN 'Yes'
+     )
-					ELSE 'No'
+                WHEN 4
-					END
+                THEN CASE int_value
-		WHEN 5
+                         WHEN 1
-			THEN CAST(decimal_value AS VARCHAR)
+                         THEN 'Yes'
-		WHEN 6
+                         ELSE 'No'
-			THEN CAST(decimal_value AS VARCHAR)
+                     END
-		WHEN 7
+                WHEN 5
-			THEN varchar_value
+                THEN CAST(decimal_value AS VARCHAR)
-		WHEN 8
+                WHEN 6
-			THEN varchar_value
+                THEN CAST(decimal_value AS VARCHAR)
-		END AS attribute_value
+                WHEN 7
-	,a.attribute_id
+                THEN varchar_value
-	,a.attribute_group_id
+                WHEN 8
-	,a.attribute_name
+                THEN varchar_value
-	,a.attribute_type
+            END AS attribute_value,
-	,pa.person_id
+            a.attribute_id,
-	,pa.int_value
+            a.attribute_group_id,
-	,pa.varchar_value
+            a.attribute_name,
-	,pa.datetime_value
+            a.attribute_type,
-	,pa.decimal_value
+            pa.person_id,
-	,pa.date_created
+            pa.int_value,
-	,pa.date_modified
+            pa.varchar_value,
-	,pa.created_by
+            pa.datetime_value,
-	,pa.modified_by
+            pa.decimal_value,
-	,pa.organization_id
+            pa.date_created,
-FROM dbo.core_attribute AS a
+            pa.date_modified,
-INNER JOIN dbo.core_person_attribute AS pa ON a.attribute_id = pa.attribute_id
+            pa.created_by,
-	AND a.organization_id = pa.organization_id
+            pa.modified_by,
             pa.organization_id
      FROM dbo.core_attribute AS a
           INNER JOIN dbo.core_person_attribute AS pa ON a.attribute_id = pa.attribute_id
                                                         AND a.organization_id = pa.organization_id;