I am using SQL SERVER 2005 FT-enable database,
repleat same query it returns the results are expect,but try five times later,
it returns record is no data,
Has anyone seen this issue ?
THANKS!!
It is difficult to understand your question.
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"akira-888" <akira888@.discussions.microsoft.com> wrote in message
news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>I am using SQL SERVER 2005 FT-enable database,
> repleat same query it returns the results are expect,but try five times
> later,
> it returns record is no data,
> Has anyone seen this issue ?
> THANKS!!
>
|||Sorry my poor english
my qruestion is
some query like :
select * from test where contains(description ,'二次金改')
return 343 records--ok
try again same query
return 343 records--ok
but try 4 times later the same query,
return 0 record --stranger
and continue try is alway return 0 recode
Next day try the same query ,
return return 343 records--ok
but same situation appear again-try 4 times later the same query
return 0 record
"Arnie Rowland" wrote:
> It is difficult to understand your question.
> It would help us better assist you if you could include table DDL, query
> strategy used so far, sample data in the form of INSERT statements, and an
> illustration of the desired results. (For help with that refer to:
> http://www.aspfaq.com/5006 and to
> http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
>
> The less 'set up' work we have to do, the more likely you are going to have
> folks tackle your problem and help you. Without this effort from you, we are
> just playing guessing games.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "akira-888" <akira888@.discussions.microsoft.com> wrote in message
> news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>
>
Showing posts with label expect. Show all posts
Showing posts with label expect. Show all posts
Wednesday, March 28, 2012
Query Problem
I am using the query shown below but I am not getting the result I expect. I
want to get "Elected" only when the count of LastName field is 75% or more
of the count of when the "CG" field is equal to "Y". What did I mess up
here?
============================ =iif(Count(Fields!LastName.Value) < Count(( Fields!CG.Value)="Y")*0.75, "Not
Elected", "Elected")
============================================Hi Wayne
Count(( Fields!CG.Value)="Y"), i think you can't do this,the
architecture of the RS is such a way that it calculates all the
aggregations and operations first and then will come to the
conditional Expressions next,
here it is messed up with Expressions first .where you are unable to
get the result
As an alternate you can do this
1) Create an extra column Extra1 by going to dataset-->Fields
it must be a calculated field (not dataset field), give like this
IIF( Fields!CG.Value="Y",1,0)
2)Add another column extra2 with sum(Extra1) .
2)Go to the layout ,add extra column to the right of the column
wherever you want,give the expression like this
=iif(Count(Fields!LastName.Value) <First(Extra2), "Not
> Elected", "Elected")
i am not that much confident that it will work, but readjusting all
this expressions should work
Regards,
Raj Deep.A
Wayne Wengert wrote:
> I am using the query shown below but I am not getting the result I expect. I
> want to get "Elected" only when the count of LastName field is 75% or more
> of the count of when the "CG" field is equal to "Y". What did I mess up
> here?
> ============================> =iif(Count(Fields!LastName.Value) < Count(( Fields!CG.Value)="Y")*0.75, "Not
> Elected", "Elected")
> ============================================|||Thanks for the suggestions. I'll give that a try.
Wayne
"RajDeep" <rajalapati@.gmail.com> wrote in message
news:1160558814.067206.178500@.h48g2000cwc.googlegroups.com...
> Hi Wayne
> Count(( Fields!CG.Value)="Y"), i think you can't do this,the
> architecture of the RS is such a way that it calculates all the
> aggregations and operations first and then will come to the
> conditional Expressions next,
> here it is messed up with Expressions first .where you are unable to
> get the result
> As an alternate you can do this
> 1) Create an extra column Extra1 by going to dataset-->Fields
> it must be a calculated field (not dataset field), give like this
> IIF( Fields!CG.Value="Y",1,0)
> 2)Add another column extra2 with sum(Extra1) .
> 2)Go to the layout ,add extra column to the right of the column
> wherever you want,give the expression like this
> =iif(Count(Fields!LastName.Value) <First(Extra2), "Not
>> Elected", "Elected")
> i am not that much confident that it will work, but readjusting all
> this expressions should work
> Regards,
> Raj Deep.A
>
>
> Wayne Wengert wrote:
>> I am using the query shown below but I am not getting the result I
>> expect. I
>> want to get "Elected" only when the count of LastName field is 75% or
>> more
>> of the count of when the "CG" field is equal to "Y". What did I mess up
>> here?
>> ============================>> =iif(Count(Fields!LastName.Value) < Count(( Fields!CG.Value)="Y")*0.75,
>> "Not
>> Elected", "Elected")
>> ============================================>sql
want to get "Elected" only when the count of LastName field is 75% or more
of the count of when the "CG" field is equal to "Y". What did I mess up
here?
============================ =iif(Count(Fields!LastName.Value) < Count(( Fields!CG.Value)="Y")*0.75, "Not
Elected", "Elected")
============================================Hi Wayne
Count(( Fields!CG.Value)="Y"), i think you can't do this,the
architecture of the RS is such a way that it calculates all the
aggregations and operations first and then will come to the
conditional Expressions next,
here it is messed up with Expressions first .where you are unable to
get the result
As an alternate you can do this
1) Create an extra column Extra1 by going to dataset-->Fields
it must be a calculated field (not dataset field), give like this
IIF( Fields!CG.Value="Y",1,0)
2)Add another column extra2 with sum(Extra1) .
2)Go to the layout ,add extra column to the right of the column
wherever you want,give the expression like this
=iif(Count(Fields!LastName.Value) <First(Extra2), "Not
> Elected", "Elected")
i am not that much confident that it will work, but readjusting all
this expressions should work
Regards,
Raj Deep.A
Wayne Wengert wrote:
> I am using the query shown below but I am not getting the result I expect. I
> want to get "Elected" only when the count of LastName field is 75% or more
> of the count of when the "CG" field is equal to "Y". What did I mess up
> here?
> ============================> =iif(Count(Fields!LastName.Value) < Count(( Fields!CG.Value)="Y")*0.75, "Not
> Elected", "Elected")
> ============================================|||Thanks for the suggestions. I'll give that a try.
Wayne
"RajDeep" <rajalapati@.gmail.com> wrote in message
news:1160558814.067206.178500@.h48g2000cwc.googlegroups.com...
> Hi Wayne
> Count(( Fields!CG.Value)="Y"), i think you can't do this,the
> architecture of the RS is such a way that it calculates all the
> aggregations and operations first and then will come to the
> conditional Expressions next,
> here it is messed up with Expressions first .where you are unable to
> get the result
> As an alternate you can do this
> 1) Create an extra column Extra1 by going to dataset-->Fields
> it must be a calculated field (not dataset field), give like this
> IIF( Fields!CG.Value="Y",1,0)
> 2)Add another column extra2 with sum(Extra1) .
> 2)Go to the layout ,add extra column to the right of the column
> wherever you want,give the expression like this
> =iif(Count(Fields!LastName.Value) <First(Extra2), "Not
>> Elected", "Elected")
> i am not that much confident that it will work, but readjusting all
> this expressions should work
> Regards,
> Raj Deep.A
>
>
> Wayne Wengert wrote:
>> I am using the query shown below but I am not getting the result I
>> expect. I
>> want to get "Elected" only when the count of LastName field is 75% or
>> more
>> of the count of when the "CG" field is equal to "Y". What did I mess up
>> here?
>> ============================>> =iif(Count(Fields!LastName.Value) < Count(( Fields!CG.Value)="Y")*0.75,
>> "Not
>> Elected", "Elected")
>> ============================================>sql
Monday, March 26, 2012
Query problem
I am using SQL SERVER 2005 FT-enable database,
repleat same query it returns the results are expect,but try five times later,
it returns record is no data,
Has anyone seen this issue ?
THANKS!!It is difficult to understand your question.
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"akira-888" <akira888@.discussions.microsoft.com> wrote in message
news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>I am using SQL SERVER 2005 FT-enable database,
> repleat same query it returns the results are expect,but try five times
> later,
> it returns record is no data,
> Has anyone seen this issue ?
> THANKS!!
>|||Sorry my poor english
my qruestion is
some query like :
select * from test where contains(description ,'äº?次é'æ?¹')
return 343 records--ok
try again same query
return 343 records--ok
but try 4 times later the same query,
return 0 record --stranger
and continue try is alway return 0 recode
Next day try the same query ,
return return 343 records--ok
but same situation appear again-try 4 times later the same query
return 0 record
"Arnie Rowland" wrote:
> It is difficult to understand your question.
> It would help us better assist you if you could include table DDL, query
> strategy used so far, sample data in the form of INSERT statements, and an
> illustration of the desired results. (For help with that refer to:
> http://www.aspfaq.com/5006 and to
> http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
>
> The less 'set up' work we have to do, the more likely you are going to have
> folks tackle your problem and help you. Without this effort from you, we are
> just playing guessing games.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "akira-888" <akira888@.discussions.microsoft.com> wrote in message
> news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
> >I am using SQL SERVER 2005 FT-enable database,
> >
> > repleat same query it returns the results are expect,but try five times
> > later,
> >
> > it returns record is no data,
> >
> > Has anyone seen this issue ?
> >
> > THANKS!!
> >
>
>
repleat same query it returns the results are expect,but try five times later,
it returns record is no data,
Has anyone seen this issue ?
THANKS!!It is difficult to understand your question.
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"akira-888" <akira888@.discussions.microsoft.com> wrote in message
news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>I am using SQL SERVER 2005 FT-enable database,
> repleat same query it returns the results are expect,but try five times
> later,
> it returns record is no data,
> Has anyone seen this issue ?
> THANKS!!
>|||Sorry my poor english
my qruestion is
some query like :
select * from test where contains(description ,'äº?次é'æ?¹')
return 343 records--ok
try again same query
return 343 records--ok
but try 4 times later the same query,
return 0 record --stranger
and continue try is alway return 0 recode
Next day try the same query ,
return return 343 records--ok
but same situation appear again-try 4 times later the same query
return 0 record
"Arnie Rowland" wrote:
> It is difficult to understand your question.
> It would help us better assist you if you could include table DDL, query
> strategy used so far, sample data in the form of INSERT statements, and an
> illustration of the desired results. (For help with that refer to:
> http://www.aspfaq.com/5006 and to
> http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )
>
> The less 'set up' work we have to do, the more likely you are going to have
> folks tackle your problem and help you. Without this effort from you, we are
> just playing guessing games.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "akira-888" <akira888@.discussions.microsoft.com> wrote in message
> news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
> >I am using SQL SERVER 2005 FT-enable database,
> >
> > repleat same query it returns the results are expect,but try five times
> > later,
> >
> > it returns record is no data,
> >
> > Has anyone seen this issue ?
> >
> > THANKS!!
> >
>
>
Query problem
I am using SQL SERVER 2005 FT-enable database,
repleat same query it returns the results are expect,but try five times late
r,
it returns record is no data,
Has anyone seen this issue ?
THANKS!!It is difficult to understand your question.
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/genera...br />
red.html )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"akira-888" <akira888@.discussions.microsoft.com> wrote in message
news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>I am using SQL SERVER 2005 FT-enable database,
> repleat same query it returns the results are expect,but try five times
> later,
> it returns record is no data,
> Has anyone seen this issue ?
> THANKS!!
>|||Sorry my poor english
my qruestion is
some query like :
select * from test where contains(description ,'二次金改')
return 343 records--ok
try again same query
return 343 records--ok
but try 4 times later the same query,
return 0 record --stranger
and continue try is alway return 0 recode
Next day try the same query ,
return return 343 records--ok
but same situation appear again-try 4 times later the same query
return 0 record
"Arnie Rowland" wrote:
> It is difficult to understand your question.
> It would help us better assist you if you could include table DDL, query
> strategy used so far, sample data in the form of INSERT statements, and an
> illustration of the desired results. (For help with that refer to:
> http://www.aspfaq.com/5006 and to
> http://classicasp.aspfaq.com/genera... />
wered.html )
>
> The less 'set up' work we have to do, the more likely you are going to hav
e
> folks tackle your problem and help you. Without this effort from you, we a
re
> just playing guessing games.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "akira-888" <akira888@.discussions.microsoft.com> wrote in message
> news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>
>
repleat same query it returns the results are expect,but try five times late
r,
it returns record is no data,
Has anyone seen this issue ?
THANKS!!It is difficult to understand your question.
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/genera...br />
red.html )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"akira-888" <akira888@.discussions.microsoft.com> wrote in message
news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>I am using SQL SERVER 2005 FT-enable database,
> repleat same query it returns the results are expect,but try five times
> later,
> it returns record is no data,
> Has anyone seen this issue ?
> THANKS!!
>|||Sorry my poor english
my qruestion is
some query like :
select * from test where contains(description ,'二次金改')
return 343 records--ok
try again same query
return 343 records--ok
but try 4 times later the same query,
return 0 record --stranger
and continue try is alway return 0 recode
Next day try the same query ,
return return 343 records--ok
but same situation appear again-try 4 times later the same query
return 0 record
"Arnie Rowland" wrote:
> It is difficult to understand your question.
> It would help us better assist you if you could include table DDL, query
> strategy used so far, sample data in the form of INSERT statements, and an
> illustration of the desired results. (For help with that refer to:
> http://www.aspfaq.com/5006 and to
> http://classicasp.aspfaq.com/genera... />
wered.html )
>
> The less 'set up' work we have to do, the more likely you are going to hav
e
> folks tackle your problem and help you. Without this effort from you, we a
re
> just playing guessing games.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "akira-888" <akira888@.discussions.microsoft.com> wrote in message
> news:E8DEDB72-A958-455A-8458-85FF94B0B7AD@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)