So how about.....

SELECT

bm.bill_no,

bm.cust_det,

bm.product,

bm.price,

bm.bill_date

FROM bill_max bm

INNER JOIN

(

SELECT MAX(price) [max_price], cust_det

FROM bill_max

GROUP BY cust_det

) AS max_price

ON max_price.max_price = bm.price

AND max_price.cust_det = bm.cust_det

Depends on how many users you are talking about. I've used sp_help_rev_login and reviewed the output script to select the users I was interested in. For one...

BOL is no longer included with the installation media. You view it online or download it.

See the links below for more information.

http://technet.microsoft.com/en-us/library/ms130214.aspx

http://technet.microsoft.com/en-us/library/ms166020.aspx

I've been faced with a similar issue to this before. In the end created a new empy database and then created synonyms for all the tables referencing the original...

Yes, you could read the file name and path into a variable and then use the variables in the expressions property of the connection manager for the excel spreadsheet.

I don't really know enough about what you are trying to do and who you are building it for. If it was an internal tool just for me I...

One option is to have SQL Server Agent Jobs set up to run the SSIS packages, but don't schedule the jobs to run automatically, and then have a web application...

I'm using SQL 2008 R2 Management Studio to manage a number of 2012, 2008, 2005 and 2000 SQL instances without any major issues. I've never tried backups from the...

I've had this happen in the past, it turned out to be a firewall change made by the network team. I can't recall the exact details but this blog...

From what you've described so far I think it is possible. I've done something similar in the past, but you do need to build some mechanism to update the...

I've migrated a few large databases recently from SQL 2000 to SQL 2005. The method I used was to perform a full backup of the 2000 database, restore this...

I'm not aware of any method to do this directly, however I have automated a process to do this using SSIS and the S3 command line utility from CodePlex (

If BUILTIN\Administrators has been left enabled you could try getting your account added to the server Administrator group temporarily to allow you to log in to SQL Server and then...

It is possible if you use xp_sqlagent_enum_jobs and then convert the Job ID value to a string value using the fn_varbintohexstr function and then find a row in sysprocesses where...

The stored procedure sp_help_revlogin does not return a result set so it will not work with BCP. You will get an error message like "BCP host-files must contain at...