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 that your new...

ronan.healy (10/5/2012)

---

well there will be alot more rows in my table some will have negwatch some wont so what i need to do is update the MIDIRB rows in the...

54.69.6d.20 (10/5/2012)

---

Sean Lange (10/5/2012)

---

I kind of...

No problem.

So the ddl for ACRT should look like this?

CREATE TABLE ACRT

(

CNO CHAR(100) NOT NULL,

OPICSCNO CHAR(100) NULL,

MOODYSRATE CHAR(10) NOT NULL,

SNPRATE CHAR(10) NOT NULL,

FITCHRATE CHAR(10) NOT NULL,

MOODYSIRB NUMERIC(4) NULL,

SPIRB NUMERIC(4)...

prady_1988 (10/5/2012)

---

Sean Lange (10/5/2012)

---

Still nothing to test with but I think this might be close to what you want...

select A, b, MAX(C), MAX(D), MAX(E), MAX(F), g

from

(

SELECT distinct

BASE1.AssetID AS a

,BASE1.Name As...

ronan.healy (10/5/2012)

---

sorry put in the older version of table

CNO ...

I kind of figured that...what is...

Well the inserts have incorrect string delimiters for sql. When I changed the " to ' I can't insert to ACRT, the insert doesn't match the table definition.

so what im...

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 by key words,...

ronan.healy (10/5/2012)

---

hi i have 2 tables

in 1 i have the following

rateN1 rateN2 rateN3 rate

a aa aaa 1

b bb bbb 2

c cc ccc 4

d dd ddd 6

table 2 has the...

54.69.6d.20 (10/5/2012)

---

Sean Lange (10/5/2012)

---

54.69.6d.20 (10/5/2012)

---

I just setup a new Win2011 64bit SBS server which is now hosting our website (Was on an old 2003 server, where 2008 SQL was hosted...

crux1187 (10/5/2012)

---

I am wondering if there is a way to overwrite or customize the system error thrown by SQL server. For example error message 521,instead of the default message you...

54.69.6d.20 (10/5/2012)

---

I just setup a new Win2011 64bit SBS server which is now hosting our website (Was on an old 2003 server, where 2008 SQL was hosted on too). Some...

Your google-fu is just failing you today. Try searching "code snippet storage". You will find lots of apps for doing just that.

parth83.rawal (10/4/2012)

---

Hi,

I am using FOR XML to generate the HTML and following is my query. i want to apply class in td, how can i achieve the same ??

CAST (...