Database

netJP12L wrote:

First name is John and there is no last name then upon concatanting both names i get null.

netJP12L wrote:

I have set the database "Concatenate Null yeilds Null" to True

poornas wrote:

hope you understood my requirement.

SELECT DR.id,
	SUM(case PC.id when 4 then amount else 0 end) AS PCID4,
	SUM(case PC.id when 5 then amount else 0 end) AS PCID5,
	SUM(case PC.id when 3 then amount else 0 end) AS PCID3,
	SUM(case PC.id when 6 then amount else 0 end) AS PCID6,
	SUM(case when pc.id = 2 and DP.id = 211 then amount else 0 end) AS DPID211,
	SUM(case when pc.id = 2 and DP.id = 210 then amount else 0 end) AS DPID210,
	SUM(case when pc.id = 2 and DP.id = 212 then amount else 0 end) AS DPID212,
	SUM(case when pc.id = 2 and DP.id = 213 then amount else 0 end) AS DPID213,
	SUM(case when pc.id = 2 and DP.id = 214 then amount else 0 end) AS DPID214,
	SUM(case when pc.id = 2 and DP.id = 197 then amount else 0 end) AS DPID197,
	SUM(case when PC.id = 1 and DP.id3 = 45 then amount else 0 end) AS DPID45
FROM
	table1 DR
	LEFT JOIN table2 DP 
		ON DP.id1 = DR.id1
	LEFT JOIN table3 PL 
		ON DP.id2 = PL.id
	LEFT JOIN table4 PC 
		ON PL.id1 = PC.id
WHERE
	DR.date = GETDATE()
group by
	DR.id

if a = 1 then
 "abc"
else if a = 2 then
 "222"
else
 "222"

John Gathogo wrote:

Is there any benefit in setting a primary key in a table variable?

TABLE Users (Name NVARCHAR(36))
"John"
"Peter"

TABLE Tasks (Name NVARCHAR(36), ThingToDo NVARCHAR(50))
"John", "Water the plants"
"John", "Cook dinner"
"Peter", "Write an article for CodeProject"

I are Troll