How to select MAX(value) in a SELECT

I have this table with the following values: Field1 Field2 Field3 1 200.00 abc 1 …

how to ignore error message in sql

I have one procedure in which suppose I got error on 10 lines then ignore that error message and ex…

Getting an average of the record set

hi, I have following query SELECT  TOP 6   smu_reading FROM    &…

Creating index in a large table

Hello: When creating a non-clustered index in a column in a large table, will the time it…

Using Dimensional Level Security In SQL Reporting Services

I have a cube that has a "corporate" hierarchy dimension.  I have explicitly set some cube lev…

Is custom paging needed with thousands of results?

Has anyone created custom paging with Reporting Services? I have some reports that return half a mi…

Append output on DTS?

Is there a way to have DTS export text append the file instead of overwritting? Any other suggestio…

2005 Linked to an Oracle database, REALLY slow...

We have a new 2005 database that I have linked to an Oracle 9i database. I have tried using bo…

Bad Eyes

It seems that most DBAs that I know are a little bit older and more experienced. It's fairly rare t…

DMO DTS

How do you go through all the DTS on a SQL 2000 server and list the the connections under "Dis…

Problem detaching ,says in use

I am trying to detach, but it comes back a in use. I then run sp2_who, comes back as 'sa' only. I h…

Backup Software

I've been designated the sys admin for a sql server, and am investigating the best way to backup th…

problem detaching ,says in use

Bulk insert text terminator and tab delimiter

I am just learning SQl Server. I am trying to import a text file using Bulk Insert. The file has " …

sp_executesql

Anyone knows why this is throwing an error ? declare @i char(1) set @i='a' exec sp_executesql 'sele…