I'm writing a quick and dirty report to give to the powers that be showing
just how often - or not - certain reports are run. I'm also going to include
some other anecdotal information. One of the things I'd like to include are
average times (rendering, data retrieval, etc.). ...

I have 2 rather important database updates that I need to make today, and I want to make sure I get the syntax, actually more importantly the update correct!  It's query 2 I am more concerned about.
Requirements
1.  Update 1: Update CustomChar4 in the Outlet table to the value in ...

I am trying to use a WHERE clause with a LIKE condition to find records that
have a single quote in a column text entry.  Below is what I have tried but
all fail.
...WHERE [Subfile] LIKE '%David's%'

My problem is I have a SQL statement that works great in Access 2003, but
when I try to transfer to SQL 2000 it errors on me mainly around the EXISTS
section.  I have tried multiple scenarios, but seem unable to get it to work.
Can anyone explain why an EXISTS in the SELECT ...

Good morning. I'd like to extract data from a single table containing
expenses, aggregating monthly totals by type.
Here's the simplified structure of the existing table
myTBL

The following piece of SQL takes more than 2 minutes in 2005 whereas it
takes less than 10 seconds in SQL 7 -
--ORIGINAL
IF (

I'm trying to generate a list of addresses from our address table that
don't use standard street abbreviations or don't have any street title
or abbreviation at all.  The column in the address table that I need
to look at is called address_1.

(Apologies if this is a repost, my first hasn't shown up after 4 hours)
I'm trying to create a table variable which matches the schema of an
existing table with an added 'NewUid' column, and I want to populate it with
select data from the live table, and then insert this data back ...

Is it possible to declare a table variable and get the structure from an
existing table?
Something like "select * into @my_table" or any other recommended way
Thanks,

I have table Classification.
In this table one column like Definition
That columns contains the data like
Definition

For this table
Id bigint identity(1,1)
Attribute nvarchar(50) not null
PeriodNumber bigint not null

Can I assume that I can reliably rollback TRUNCATE statement?   Will
something like this work reliably: (I need Result table be always
consistent).
BEGIN TRY

I have two databases, one for test and another for production purposes.
Every night production database is being backed up and restored into a test
database. I've mistakingly deleted one table from the test database. What is
the best way to recreate deleted table from the ...

when trying to insert a MySQL time datatype into a SQL Server 2005 DatTime
(using a C# program) format I get the error message:
Unable to cast object of type 'System.TimeSpan' to type
'System.IConvertible'.Couldn't store <22:00:00> in StartHour Column.  

I want to get following output:
Create Table RowToColumn
(
    Col1 Int,