I am trying to write a query that limits the query results to only data
collected between the hours of 07:00 and 19:00 using the having clause and a
variable @reportdate which is the date that the user running the report is
able to enter.

Is it possible to stop query execution if query results exeeds more than 100 rows ?
Like, is query:
SELECT * FROM table WHERE id > 100
Now if there in the results will be more than 100 rows i want (for speed reasons) stop the query execution and got some error message that in 'in ...

i have the following situation:
- a database that contains someware 1000 tables
- a string that can appear everyware in a row or table, the column name
difers from one table to other

Is there any reason to run the following as three separate SELECT's? Is
there any performance implication?
Thanks for your help!
- Joe Geretz -

I wrote an aspx page.
I'm using union from table.
It shows datagrid with values:
server   |  parameter

I need to access my data mining model from a .net application. I would like
some kind of object like pivottable wich permits connect to a cube so easy
an present the interface so similar to analysis server browse option.
Any help is welcome.

I have a excel spread sheet that i need data from. This is the Data.
     MyID
      TextField
       DateField

I have a stored procedure that takes the values of 2 fields in the same
record and puts them into 2 variables
(groupId and userId)
My procedure checks each variable to make sure it is not NULL.(RULE: 1

I am interested in learning more about artificial neural networks and
was wondering if anyone could recommend books that would help.
I am looking for a book that will help me design and code the network
along with explaining all the necessary components.

I have a stored procedure written for number of updates, inserts to the
database. This stored procedure takes too long to run. I have created few
indexes around few tables, but the response time is not that defferent.
THere is a Curser "CURSOR FAST_FORWARD FOR"  in the stored ...

There are many db in my machine.
Can I search a certain text among those dbs?

I'm facing the error as the subject stated , "Cannot resolve collation
conflict for concatenation operation".
Base on running "print cast(
databasepropertyex( 'master', 'collation' ) as varchar(128) )",  the

How does data mining impact on Business Intelligence and CRM.
What are the best CRM tools out there with respect to data integration with
legacy systems? Please a list of two or three will be nice. Thank you.

I have a stored procedure with 5 integer parameters passed
in. Those 5 integers need to be stored in one table row
from the smallest one to the largest. But when the
procedure is used, the 5 integers will be randomly passed

I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'