Here is what I'm looking for... I'm looking to get the MAX(OP) , DEPT and
DESCRIPTION for this data table (pretty easy). But.. I have an exception
table that allows me to override the OP calculated from this query. IE  Part
Number 17377's MAX(OP) is 060 MILL MFG LUG, but I have ...

I have this table with columns A & B
A    B
1     100
2    300

I have a table that is storing records every minute and I want to
select the last n rows and then do a group by on just those records.
Below is what I'm using to select the last n rows. When ever I add the
group by, it is selecting all the rows in the table. How do I apply

dear sir/madam
1. select
ParticipantName,Email,City,BoutiqueOffice,OthersOffice,Mobile,Sex,AboutParticipant,Friendtalent,category,OthersCategory,MyName,Number1,DateSubmit
from TanishqBAM_Nominate where dateSubmit = '3/31/2008'

I need a function to help me clean data from char type to int/numeric
type
There are two kinds of data
One is integer,like age,quantity

I have .net assembly that i have registered with the sql server that needs
to provide the front end some information.
This information is compiled by the object (.net class) by executing few
other stored procedures internally.

I have need to return in a select statement a value that could be either the
calculated value or a permitted max value from a table.
By this I mean the following
Select tbl_shelf.width * tbl_shelf.depth as [Area], tbl_machine.maxArea from

I'm using SQL Server 2005
And I have (based on Northwind) configured theDatabase mail
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Mail',

I have a general question about any performance benefit in returning value
from stored procedureas Output Parameter, Return Value or using SELECT
statement.
Do you guys prefer any of the above options to return value due to

I'm doing some reading on remote stored procedures and the text I am reading states:
The processing done by the remote procedure is, by default, not done in the local transaction context.  If the local transaction rolls back, modifications performed by the remote store procedure ...

any simple code or SQL for creating moving averages, basically want to create
30 and 60 day moving averages of events over time with moving averages

I need to get relation between columns which my stored procedure returns
and tables and columns which are used in my stored procedure.
How to get that? See example below.
I use SS2005, SP2.

Ok... tell me how strange this is:
I'm using asp.net 1.1 (and ado.net) with a connection-string like this:

I have two table, Income_tbl and Expense_tbl.  I am trying to create a
simple query to get income and expense.  What I have works but does
not give the "exact" result I am looking for.
(The query is a little more complex then shown below as it joins

I have several installations of sql2005 and all is well.
Until recently I installed on a Vista Business laptop.
Now I can create a database or do anything else. I gte an error
message that I have no permissions on the master database.