Not unless you've got some form of datetime field that's set to the current date on an update.

Timestamp columns are updated whenever a record is changed, but I don't think...

Try an anonymous pull subscription. It's what I've had to do with a firewall between my distributor and subscriber.

Not elegant, but should work

SELECT *

FROM (Select * FROM TestWhereOrder WHERE TypeCode = 'N') NumericTests

WHERE TestWhereOrderID = 100

AND cast(Code as int) = 100

Create a database diagram with just that table. You can specify exactly what the diagram shows (just column names, names and types, etc)

You can print the database diagram

Very simplified down

i.ID, i.Header, i.Subheader, CAST(i.Text AS VARCHAR(200)) from Issues i

group by i.ID, i.Header, i.Subheader, CAST(i.Text AS VARCHAR(200))

Increase the size of the varchar if you need more chars (up to...

It sounds to me like it could be a locking issue. If there are other queries running against the table you're trying to update, your stored proc will be blocked...

Were you logged in as an administrator when you tried to install? If not, uninstall the whole lot, log in as admin and try to reinstall.

Any error message either from the installation or the start service?

Case can only be used within a select statement

Bigint (Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807). Storage size is 8 bytes.)

This should work, although I haven't tested it

Select * FROM A LEFT OUTER JOIN B ON A.a1=B.a1 AND A.a2=B.a2 WHERE B.a1 IS NULL AND B.a2 IS NULL

Two ways, the second may prevent the use of indexes, so be warned.

DECLARE @dt DATETIME

SET @dt = '2004/07/16'

SELECT * FROM tbl

WHERE cTime BETWEEN @dt AND DATEADD(ss,-1,DATEADD(dd,1,@dt))

(all records where cTime...

I do most heartily apologise, I missed out a + when I specified the where clause for you.

It should be

WHERE TplanCond=''' + @Tplan + ''''

*most embarrassed*

That said, I don't think you need the nested SQL statement.

SELECT tblthisproductmodelFinal.lngModelOfficeNum,

tblthisproductPolicyNumbers.lngPolicyNumber AS lngPolicyNumber,

tblConditions.lngConditionNumber AS lngConditionNumber,

tblConditions.numCycle AS numCycle,

...

You're missing some quotes

....WHERE p.TplanCond='thistestplan'

Without the quotes sql is looking for a column named thistestplan, which I assume from your comment doesn't exist.

Replace the where clause in the string...