blakmk (10/8/2012)

---

Having tested it on a very large table. The transaction rolls back. Although i know there is sql process that kicks in periodically to rollback transactions. However not sure...

+1

Especially since this an ASP.NET application using transactions like this is incredibly...

Or for an even better approach don't use pass through sql from your .NET app. Instead use parameters. From the issues you are facing it is very likely that your...

blakmk (10/8/2012)

---

I have a requirement to return a batch of records and then mark the batch complete. I was thinking to acheive this with a select and the update. Something...

The code looks ok. It is impossible for us to know if it is correct though. You need to figure out what the error is. This can be somewhat painful...

bitbucket-25253 (10/5/2012)

---

Sean Lange (10/5/2012)

---

ben.brugman (10/5/2012)

---

bitbucket-25253 (10/5/2012)

---

I have what I call a sandbox DB to hold scripts, some T-SQL and have it set up so as to be able to search...

David_D (10/5/2012)

---

[font="Arial Black"]Regarding this book:[/font]

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer) [Paperback]

Paul Turley (Author) & Dan Wood (Author)

[font="Arial Black"]Which SQL Developer Edition...

You're welcome. Glad that worked and thanks for letting me know.

54.69.6d.20 (10/5/2012)

---

Sean Lange (10/5/2012)

---

54.69.6d.20 (10/5/2012)

---

hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried...

This should work based on your example.

create table #SomeTable

(

[ACCOUNTKEY] [int] NOT NULL,

[ACCOUNTSERVICEKEY] [int] NOT NULL,

[SERVICEOPTIONSKEY] [int] NOT NULL

)

insert #SomeTable

select 1000, 1050, 1016 union all

select 1000, 1051, 1020 union all

select 1000,...

54.69.6d.20 (10/5/2012)

---

hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried it on the...

No problem. Happy to help. The best thing you can do is to...

Just to help you with future posts, if you post your data in a nice and clean consumable format it will go a long way.

CREATE TABLE dbo.IRBT

(

MOODYSRATE CHAR(10) NOT...

54.69.6d.20 (10/5/2012)

---

Sean Lange (10/5/2012)

---

Since you mentioned this is a webserver, did you add an exception to this machine for the ports that sql is using (default 1433)? I am guessing...

So you...