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'm working with a stored procedure written by our software vendor and
trying to get the results of this stored procedure exported into some kind of
file so i can load it up on another server for reporting purposes.
The stored proc uses the FOR XML RAW command and I had lots of ...

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.  ...