Write the most efficient query (SQL+ )

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

General SQL Server Forums

New to SQL Server Programming

Write the most efficient query (SQL+ )

Author

Topic

dasmonk
Starting Member

2 Posts

Posted - 2013-11-12 : 03:57:39

I have a table where I´m trying to get some information.
Have been succeeding to get the information but it´s slow.
Trying to get some other way to do it.
Wondering if you have some idea.

I want one startdate and one enddate. But I only want them if another tag name has a maximum value of 10 between those date.

what I have done now is to write.
This code works but not so effecient because it loops
through allt the possibility.

PLZ help

[CODE]

for (select ts as st from history
where name='tagg1' and value = '1' and ts between t0 and t1 and request='4')
do

endDate=(select ts as en from history where name='tagg2' and ts between st+25:00 and st+40:00 and request ='4' and
value='0');

totalsum = (select max from history1 where name='tagg3' and ts between st and endDate )

if totalsum = 10 then
write st || endDate
end;

[/CODE]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-11-12 : 05:06:28

this is not Microsoft SQL Server right ?

KH
[spoiler]Time is always against us[/spoiler]