Try the following

SELECT count(*)

FROM tbl

CROSS APPLY SEMANTICSIMILARITYTABLE(tbl, txt, tbl.ID) a

When save the formated excel, leave the cursor one the second blank line, which force the imported data into the third line, somehow this will leave the cell format intact....

Try to create NumErrorLogs as String Value.

It could be only one error (3012), the errorlog can verify that. The other one (3098) could be a warning, which would not appear in catch block.

add user as alias to the object owner.

try

select distinct
 cast (propertyid as int) as propertyid
 from syc_weblog
 where CAST(CAST(property_id AS INT) AS varchar(50)) not in
 (select (CAST(address_agency_details_id as int)) as propertyid
 from residentialsalescache
 WHERE CAST(CAST(Address_Agency_Details_Id AS INT) AS varchar(50)))

Try:

select a.AccountID, a.AccountName, b.Duplicated

From Account a

inner join (

select accountname, count(*) as duplicated

from account group by accountname

having count(*) > 1) b on a.accountname = b.accountname

if you data have unique constrain, then identity (or similar concept) may help you.

create table with identity column and key field of your data.

populate it with the key field.

join two...

select a.docid, a.docname, isnull(b.avaragerating,0)avaragerating,

 isnull(b.ratingcount,0) as ratingcount

from tbl_documents a

 left outer join

(select docid, sum(rating)/count(*)as avaragerating, count(*) as ratingcount

 from tbl_rating

 group by docid) b on a.docid = b.docid

Try this

select a.docid, a.docname, isnull(b.avaragerating,0)avaragerating

from tbl_documents a

 left outer join

(select docid, sum(rating)/count(*)as avaragerating

 from tbl_rating

 group by docid) b on a.docid = b.docid

create table outside stored procedure.

create stored procedure with filename as parameter.

Here is sample:

--prepare csv data file, in dos command, assume local pubs database.

bcp pubs.dbo.authors out authors.csv -S(local) -T -c -t,

--create...

portion your job is an option.

1) no problem in synchronization.

3) restore full backup, then the last differential backup.

put constraint in the password column is another option.

Windows account for sa is the sql server startup account.

For scheduled jobs, it is sqlserveragent startup account.