need dynamic SQL query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

need dynamic SQL query

Author

Topic

ajmaly
Starting Member

11 Posts

Posted - 2010-07-31 : 02:06:29

Table : TransactionInstance

Condition Order Field Condition value
1 TOTALHOURS >= 65
AND 2 POSITION = “Clerk”
AND 3 OVERTIMEHOURS >= 15
OR 4 SITEID = “Site 1”
OR 5 SITEID = “Site 2”
AND 6 TOTALHOURS >= 50
OR 7 SITEID = “Site 2”
AND 8 OVERTIMEHOURS >= 10

Below is the pseudo code,

((TransactionInstance.TOTALHOURS >= 65) && (TransactionInstance.POSITION.Equals(“Clerk”) &&( TransactionInstance.OVERTIMEHOURS >= 15))
OR
(TransactionInstance.SITEID.Equals(“Site 1”)
OR
((TransactionInstance. SITEID.Equals(“Site 2”)) && (TransactionInstance. TOTALHOURS >= 50 ))
OR
((TransactionInstance. SITEID.Equals(“Site 2”)) && (TransactionInstance. OVERTIMEHOURS >= 10 ))

How can we make dynamic SQL query based on above pseudo code…???

ajmal

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-07-31 : 02:23:31

[code]
(
TransactionInstance.TOTALHOURS >= 65 AND TransactionInstance.POSITION = 'Clerk' AND TransactionInstance.OVERTIMEHOURS >= 15
)
OR
(
TransactionInstance.SITEID = 'Site 1'
)
OR
(
TransactionInstance.SITEID = 'Site 2' AND TransactionInstance. TOTALHOURS >= 50
)
OR
(
TransactionInstance.SITEID = 'Site 2' AND TransactionInstance. OVERTIMEHOURS >= 10
)
[/code]

N 56°04'39.26"
E 12°55'05.63"

Kristen
Test

22859 Posts

Posted - 2010-07-31 : 02:52:25

"How can we make dynamic SQL query based on above pseudo code"

Surely you can't? because the TransactionInstance table does not contain any precedence information.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources