Showing posts with label entry. Show all posts
Showing posts with label entry. Show all posts

Monday, March 26, 2012

I would like to simplify my query

What I'm trying to do is get the last entry (by date) for a given entity (which should be a single row). The following returned more than one row:

select termId, entityId, max(enddate)
from Terms
where entityId = 1234
group by termId, entityId

This does return me one row:

select *
from Terms
where enddate in (select max(enddate)
from Terms
where entityId = 1234)

What I would like to do this in one select statement. Does anyone have any suggestions?

Quote:

Originally Posted by NamelessNumberheadMan

What I'm trying to do is get the last entry (by date) for a given entity (which should be a single row). The following returned more than one row:

select termId, entityId, max(enddate)
from Terms
where entityId = 1234
group by termId, entityId

This does return me one row:

select *
from Terms
where enddate in (select max(enddate)
from Terms
where entityId = 1234)

What I would like to do this in one select statement. Does anyone have any suggestions?


I think your query is correct. I cant get what you mean for simplify my query?

If you want you have to explain your requirement

Friday, March 23, 2012

i want to work on both (internet & sql server) simoultaniously.

hi friends

DNS entry is a must in my PC to connect to internet but i canot connect to an MS SQL database server
installed on another machine on same lan. but if i remove DNS entry in my PC i could connect to MSSQLServer but i canot connect internet. i want to work on both simoultaniously.
some one please suggest what to do ..?

stephen

HI,

I had the same thing @. my home. IM having two servers primary and secondary

Primary server --> internet connection available & shared my internet connection and installed sql2005

Secondary server --> I can connect to internet and i can connect to sql using primary server name from this sys

Both the sys are in one-2-one LAN connection and having two ehternet adapaters on primary sys, one for connecting to internet and another one for connecting secondary sys.

i had enabled "share internet option" on the ethernet card that is used to connect to internet in primary sys.
|||hi vidhya sagar

thank you for your reply..

let me go through it..

stephen

Wednesday, March 21, 2012

I want to jump to an entry specified by parameter, doable as bookmark?

I know I can do to just show 1 entry

select * from table where no = @.parameter_no

but is it possible to actually select ALL entries (I have 250 for now) in the list report, but jump to a particular # based on parameter?

Say I have ID 1 ~ 250 (select * from table) in DataSet, but when I enter 220 in parameter, the report still selects all 250 entries but jump to the 220 entry?

I have bookmark set up on each entry

Thanks for any help. I noticed in my search that jump to a report + bookmark isn't supported, does my situation fall under that?

Hello

Did you ever figure out how to do this? If so, would you care to share?

Thanks

sql

I want to jump to an entry specified by parameter, doable as bookmark?

I know I can do to just show 1 entry

select * from table where no = @.parameter_no

but is it possible to actually select ALL entries (I have 250 for now) in the list report, but jump to a particular # based on parameter?

Say I have ID 1 ~ 250 (select * from table) in DataSet, but when I enter 220 in parameter, the report still selects all 250 entries but jump to the 220 entry?

I have bookmark set up on each entry

Thanks for any help. I noticed in my search that jump to a report + bookmark isn't supported, does my situation fall under that?

Hello

Did you ever figure out how to do this? If so, would you care to share?

Thanks