I need to remove some duplicates records from a temp table while using the
below sql statement.
SELECT *
INTO VAmerica_Temp2

I have the following SP :
USE [RR_Logistics]
GO
SET ANSI_NULLS ON

I am using the datatype money and when there is no change it displays
the dollar amount like this:
$60 instead of $60.00.
However is there was a dollar amount of $60.01, it would display the

How can I automatically run a stored procedure at 45 minutes past the hour,
every hour (SQL 2005)?

I have a table of people and I would like to retrieve all the persons
that are somehow duplicated (I will consider 3 columns for this:
FirstName, LastName and MiddleName)
These are my 2 possible options to do this:

We have a CRM called Goldvision, it stores copies of emails in the
database. It has a table for attachments. The size of this table is
around 20Gb. If we were to store the attachments in the file system,
would it also be 20Gb?

I have an image upload utility, and i want to make sure that if the
same image is uploaded twice, and counter will be appended to the
@ImagePath.  For right now, i'm just adding the string 'tempCounter'
and trying to get the @ImageCnt to increment properly.  Basically, the

I have a table similar to this one:
SerialNo        Description                   StartDate
EndDate                 RepairDate                  RejectDate
001               TableA                          03/12/08

A customer reported some odd behavior, and it turned out to be because a
trigger was disabled.  Access to the SQL Server is quite limited, and it
seems very unlikely that anyone intentionally disabled this trigger.
Is there any way---like if the system has a problem with the ...

Hi People,
I would like to have an sql statement that would return me a simple sequence
of numbers, something like this:
SELECT * FROM GenerateSequence(1, 4) would simply return

I was having a problem with a query of the form
SELECT a FROM b GROUP BY c HAVING Min(x) = y
running very slowly (over 30 seconds).
I tried all the usual optimisation tools etc., but no luck.

I have a child proc that takes an input variable as an argument passed
from its parent.  It optionally modifies it, then I want to pass it back
to the parent.  Do I have to declare two separate args, one for INPUT
and the other for OUTPUT?

After numerous unsuccessful searches, I am creating a template file
that will allow me to search for a string in each and every sproc,
view, or trigger on my server.  Unfortunately, though, I'm not a valid
user in every database on the server (and there are a lot of databases

The cutoff date of my query is current date, but I want to have the cutoff
date to be any date that user want.    All the getdate() should be
@cutoff_date parameter something like that.  I don't know how to do that with
query (not stored procedure) .  I use this query in View.  ...

After many hours (and days) of trying to get my little smart client / WCF
application up and running I finally have come to an error connecting to the
SQL Express 2008 on the server from my data access layer.
"The server was not found or was not accessible. Verify that the ...