Nils Gustav Stråbø (10/7/2010)

---

You won't believe how many people that actually use NOLOCK or READ_UNCOMMITTED to "fix" concurrency and locking problems. One of our vendors use NOLOCK in every(!) SELECT...

Great question. Really got my brain kick started this morning which I desperately needed because I was out of coffee at home this morning. 😉 Took me several trips through...

Well it is very hard to break into your own application because you know where the holes are. I know that sounds a bit silly but trust me I have...

lcarrethers (9/29/2010)

---

The row count is the same but in one field there is only one record in it. It should be 6 records.

This is only happening on 2 machines,...

What do you mean by not all the data? Do you mean the rowcount is different or the content of fields is different when using SSMS?

Your else statement will never find anything.

You are saying if a certain record does not exist then insert it.

IF NOT EXISTS(SELECT * FROM dbo.[File] A where A.[FileName]not in (select...

something this should get you in the ballpark...

create table #MyTable

(

datetype varchar(6)

)

insert #MyTable select '200612'

insert #MyTable select '200705'

insert #MyTable select '200711'

insert #MyTable select 'nodate'

select * from #MyTable

where ISNUMERIC(datetype) = 1

select case...

You can't just stick a few characters together and cast them as a date, there has to be some sort of delimiter (typically a '/'). If possible maybe you...

If you just take off the group by clause from the version where did select count(*), it should work just fine.

SELECT COUNT(*)

FROM T401_CALL_LOG_3MTH C401 (NOLOCK)

LEFT OUTER JOIN

dbo.T575C_ACCT_STC T575 (NOLOCK)

ON

T575.FACS_SYS_ACCT_NB =...

My suggestion would be to create a stored procedure that can handle all your inserts. Keeps it in a nice tidy package, makes transaction handling simple and allows you to...

I don't know anyone that would even consider allowing an application on the...

Well you can check in your finally block and if there any transactions either commit or rollback. Not the cleanest choice but disposing of your connection will force the .net...

Look into try-catch blocks in c# and make sure that you always commit or rollback transactions. Then you should use a finally block to release your connections back to the...

They do all have values. Without some tables and some data there is next to nothing anyone can do to help.

Try to help us help by posting some table definitions and sample data.

Taking a stab in the dark there are no duplicates.

These two rows are unique.

3 c N 653 0...