with below query, i select top 5 top and bottom records from the table
and then select a random record within selected top 10.
---
                    set @selectedId =

how to enter data from a website into a database???

Plamen,
Back in May you helped me by posting the code below to create records into a
groups table.
Now I want to create a new indexed table field called GroupNameUpOneLevel. I

There is something wrong with this function.
I am struggling with syntax with the case construct.
CREATE FUNCTION GetPlannedDate
(

Is it possible to run a query to find all the ways a user has been granted a
login to SQL server.
for example a user may have a login because their windows login has been
given login righs to sql server,

-snip-
if
(@TotalInTodayFromSameIp<10)
and (@PublisherLastEranedDifferance > 10)

What is the best way in order to send an SQL query via e-mail?
What can I do in sql server side? or programatically? (VB or C#)
Thanks in advanced.
dj

If I have table, can I estimate approximately, how large x rows is going to be?
CREATE TABLE #tmp( id INT IDENTITY PRIMARY KEY, test_col1 VARCHAR(20),
test_col2 DATETIME, test_col3 FLOAT, test_col4 VARCHAR(MAX) )
GO

I have a query that needs to return only if there are records that
match the criteria. My current query is something like this:
SELECT MAX(RECORD_DATE),RECORD_NAME
FROM TABLE_NAME

create table t1(parentid int not null,childid int not null,number int null)
go
Insert t1(parentid,childid) values(10,10)
Insert t1(parentid,childid) values(10,11)

I have a .sql file that has a query that I would like to schedule to run on a
frequent basis.  Can I import this into SQL Server Agent\Jobs?  Or do I just
need to rewrite this as a Scheduled Job?

I couldn't find a good answer on google....but here goes..
What is the difference between a join and a subquery?
Which one is faster and why?
Audrey

Here's what I'm trying to do.  I know how to do it with a temp table and/or
cursor, but was wondering if anyone else knows a more elegant way...
This is about taking a list of parts for an electronic assembly and
reformatting it for output on a report.

I have a query that needs to return only if there are records that
match the criteria. My current query is something like this:
SELECT MAX(RECORD_DATE),RECORD_NAME
FROM TABLE_NAME

I have a problem.  I just inherited a program that is full of holes and bugs
and I need to do some patching.  Just to note everyone, I did not set up
this database and I did not code this program, I am stuck with it as is.
That being said,  I have to do some checks on a database ...