declare @summaryEmp table (ID int,
                           Code varchar(20),
                           Paid money)
create index idx_summaryEmp on @summaryEmp (Code)

I have 2 databases. In the 1st database foo1, I have a table - tfoo1 - which
contains item numbers in the following format, e.g. 12345XYZ345
The second database foo2, item numbers are in the format e.g., XYZ
I need to create a sql script that joins the two tables in separate

I would like to use bulk insert with a text file that contains numbers  both
negative and positive (OK so what the big deal?). It turns out that the
system delivering the text files appends the negative sign behind the number
so it looks like this ('|' being my column delimiter):

Purely theoretical while I'm finalising the design currently, so DDL isn't
directly relevant unless requested.
I'm currently writing a recipe database for an online game. Each recipe is
assigned a level within its appropriate skill, at which it becomes

I have query like this
Declare @var nvarchar(max)
SET @var=
'SELECT

In management studio - get weird message:
error source: Microsoft.Visual Studio.DataTools
error message: 'row values updated or deleted do not make the row unique or
alter multiple rows (5 rows)'

-- If I have a database in Simple recovery mode, it is possible to BACKUP a
FILEGROUP.  However, it does not seem possible to RESTORE it.
-- Is it ever possible to RESTORE it?  I personally didn't think it was
possible in Simple recovery mode, but then it doesn't make sense you ...

In one table I try to pick up one record in each group and do not want
to use cursor. This is a huge table with 100 millons of rows. I need
performance. How can I do this?
For example, the table like below. For each group I need pick one

I'm new to Sql server and i'm stuck with an issue with CTE.
I have a situation where i have to use the following logic...
If (Condition)
begin

I have a normal 1:N relation. My child table is just a list of string
values. I would like to have this list as a single column, comma seperated
So that I woul have a single row, with my parent description, then a column
with the child string valuse comma seperated.

I have a sorting issue.
I have a bunch of records, let's call them NOTES.
Field NOTEID (which is data type INT in the database, but was converted
to nvarchar in the stored procedure) is being sorted alphabetically

Let's say I have a customers table and an orders table. In the orders table,
I have the customer name.
So if I want to select the orders grouped by customer name where the
customer has more than 3 orders, it's easy:

I will need to add a column to a customers database table.  The table has
records more then two years old abd has approx. 10,000 records.  I have never
been able to add a column to a table with much less records.  I will be doing
so with SqlWb unless there is a better way.  We ...

Hello we were recently hit w/ a SQL injection attack.  If I gave the
table name, column name and the text that we want removed from the
fields would someone be able to come up with a stored procedure or
query that I can run to clean this up.  It wasn't to bad to clean up

I know that you can compare old and new values of a non primary
key column in an after update trigger the following way:
select i.col 'newValue', d.col 'oldValue'
from inserted i