There's no subquery there. Have you got any triggers on the table?

The normal cause of this error is a subquery returning > 1 value, which is of course invalid...

It's scoped to the session, so it's dropped when the proc terminates.

What's the problem exactly? REPLACE() will replace any number of occurrences in a string.

Oops... make that '2012 Jul 18 23:59:59:997'!

BTW DateTime is only accurate to 3 milliseconds.

Wildcards only work on character fields.

To get all records for a date you can do this:

select * from mytable where UploadDate BETWEEN '2012 July 18' AND '2012 July 19'

or you...

SQL will not set multiple values to a variable like that.

It effectively gets set 3 times, once for each row, overwriting the previous.

You need to concatenate the values yourself in...

Post the query so people can have a look at it:-)

Good point...

How about this: I haven't tested it myself because there's no test data supplied 🙂

WITH CTE_2010 AS

(

Select [Business Unit],

Count([Business Unit]) [Total No Of Tenders],

Sum(Case When [Submitted Status] =...

Then Chris' method works (very fast in the presence of a Clustered Index on Col1) with just a couple o' tweeks...

UPDATE t1

SET col2 = x.col2

--...

Record_Type & Tag_Lot_No must appear somewhere else in the database - hopefully in the tables you want to join to. If they do, you will need to add the...

You could do this:

Create table myTable (ID int, col1 int, col2 int);

insert into myTable values (1, 10, 15);

insert into myTable values (1, 20, 25);

insert into myTable values (1, 30, 45);

insert...

It depends what front end you're using. You might use ADO.NET with a transaction, or you could set up individual SQL stored procedures to insert the master & child...

It would be something along these lines:

DECLARE @MyTableVar TABLE

(

empcode nvarchar(300)

);

BEGIN TRANSACTION

BEGIN TRY

-- Update master table

INSERT INTO EmployeeMaster.....

OUTPUT INSERTED.empcode INTO @MyTableVar

-- Update child table

INSERT INTO EmployeeDetail (empcode,...

Try this:

--Activate the EXEC & comment out the PRINT.

IF OBJECT_ID('tempdb..#tables') IS NOT NULL DROP TABLE #tables;

IF OBJECT_ID('tempdb..#Columns') IS NOT NULL DROP TABLE #Columns;

select *

into #tables

from sys.tables where type =...