Pls help urgent
-
Pls help me to correct this query? SELECT Day.Name,iff(Morning,'Yes','No')+','+iff(Afternoon,'Yes','No')+','+ iff(Evening,'Yes','No') as Session3 FROM Session INNER JOIN Day ON Session.SessionID= Day.SessionID
sajin85 wrote:
Pls help me to correct this query?
What is wrong with it? What is it supposed to do? What database system is it for? Why is this not in the SQL forum? What does this have to do with C#?
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
sajin85 wrote:
Pls help me to correct this query?
What is wrong with it? What is it supposed to do? What database system is it for? Why is this not in the SQL forum? What does this have to do with C#?
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
Colin Angus Mackay wrote:
What is wrong with it? What is it supposed to do? What database system is it for? Why is this not in the SQL forum? What does this have to do with C#?
You don't know? You are supposed to be the expert oracle here! ;P
[My Blog]
"Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe -
Colin Angus Mackay wrote:
What is wrong with it? What is it supposed to do? What database system is it for? Why is this not in the SQL forum? What does this have to do with C#?
You don't know? You are supposed to be the expert oracle here! ;P
[My Blog]
"Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfednh wrote:
You don't know? You are supposed to be the expert oracle here!
Don't insult him. He's the Sql Server around here.;P
Deja View - the feeling that you've seen this post before.
-
dnh wrote:
You don't know? You are supposed to be the expert oracle here!
Don't insult him. He's the Sql Server around here.;P
Deja View - the feeling that you've seen this post before.
:laugh: :laugh: :laugh: Very good!
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website