I need to select the count of the first 3 rows per each group (xID) up to a
count of 3 rows (top 3 rows - order by column x1) where the stat column is
not null.  if a group contains more than 3 rows where stat is not null -
ignore the extra rows - only count the first 3 rows in ...

Hi I would like some advice, i have started as a DBA and have 20 sql servers
under me. Each Sql Service account and Sql Agent account runs under different
accounts so thats 40 accounts to keep track off.
Some of the paswords are not known so instead of just resetting the

I ran into a problem with my query where I was trying to get the type and
length of fields in my table.
But I ran into a problem with varchars and chars passing back multiple
values from the types table.

I have a question, more of why MS SQL is doing this than anything I
guess.  I'm writing a Case statement within my Where clause to create
a conditional where, and though in theory it would work, MS SQL is
complaining when I don't think it should.

I'm trying to do this in SQL 2005.  I have a table with no unique identifier
and I need to add this now.  Say I have Table1 and I created a column called
ColA.  There are already 7000+ records in this table and I want to inject a
number value in ColA from 1-what ever.  I'm ...

 I have a simple case function that I would like to use inside a select
statement:
Select price, case price
                  when 5 then 'Five Dollars'

If I use:
HAVING (GroupName LIKE @EnterMasterGroupName + N'%')
I get:
GroupName:

Using SQL 2000 sp4
I have a table that has over 100 million rows
Just looking at the best performance approch where condition in a huge
table.

For those that aren't familiar with SNL it's 'Saturday Nite Live'. It's a tv
show that parodies celebrities, politicans, social behavior etc. It's humor
with a stinger, it's supposed to make you laugh at that which is just too
silly to be taken seriously:)

I'm using SQL Server 2000 sp4. Huge database (100+ tables), huge
application.
Is there a way to use SQL Profiler to filter out all table/index
scans?

I'm not sure if I've really titled this post properly. Let me explain.
I have two VERY large csv files that were imported into SQL Server
Express 2005. After the import I now have two large tables with millions
of rows of data in them, but now I'm trying to normalize the data. As

I would like to convert the following VBA to T-SQL, the problem I have is
finding the correct syntax for specifying a range to be tested:
Regards
VBA------

I have the following three SELECT statements:
----------------------------------------------------------------------------------------------------------------------------------------
SELECT
distinct

I have a below query.
Select * from Employees(NOLOCK) Where HomeCountry = 'USA' AND
HostCountry = 'JAPAN'
In some places i want to use 'OR' in place of 'AND' in the WHERE

I need within a query to compare a couple of calculations, with their
results rounded. I have been trying to use the ROUND() function:
SELECT ROUND(-1.92, 0);
but find that I get the following error if the calculate value <1 and >0.