so then just add a top 1 and order by and you will get the single record from the results set

I would do this one with the tool that is displaying the data as they ususally have much better format masking. Remember a database is for managing data and...

Steve.Cornelius (8/3/2011)

---

I see very little of value in this article. The readers are ever so slightly better informed after reading it, but have acquired no useful information. In fact...

Thanks for these articles Tom. I have ensure the application developers here are reading all of them. Of course the DBA's already get it but like a lot...

Also joins are not constrained to keyed values only, so you can do a traditional join type operator. For joins key add lots to performance but with the data...

What I am seeing here is a bitwise implementation. Here is a very good article on bitwise that may help.

http://www.databasejournal.com/features/mssql/article.php/3359321/Storing-Multiple-Statuses-Using-an-Integer-Column.htm

Hi,

If the column is incomplete it is probably related to your SSMS settings. Go into "Tools\Options" select "QueryResults\SQLServer\ResultsToGrid" and check the maximum number of characters retrieve. Change...

It looks to me like they are using bitwise processing, the ability to store multiple values in a single field.

Have a look at this article http://www.databasejournal.com/features/mssql/article.php/3359321/Storing-Multiple-Statuses-Using-an-Integer-Column.htm

Hi all,

I would not go down this path as it means you are redundantly storing data and breaching some basic normalisation rules. If the new field is always going...

First time I've ever joined a QOTD discussion. In almost 10 years on the site this must be the worst QOTD yet. I quite regularly get them wrong...

This really highlights why I don't like SQL Server's implicit data type conversion.

You could try using the [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] view for each DB, loop through the results issuing a drop constraint command.

I think some knowledge on the app and the desk top setup is needed. The last time I had this sort of an issue it turned out there was...

We're lucky. We don't have a true data warehouse so to provide reporting capabilities without impacting the OLTP we restore nightly the backups into the DW. The big...

oops, looks like my copy of BOL is old too. Tried it and it works fine.