Keep in mind that all of the code samples are using top 1 with no order by. If you require the "first" record to be meaningful you will need to...

Mick Opalak (3/13/2013)

---

No, I'd like not just the first 50 characters but all of the characters in the field. I'd like the first 50 characters, then a carriage return,...

aheadley (3/13/2013)

---

Thank you. Changing to the column instead of the parameter worked. Is the new join syntax standard SQL? My programs need to run against multiple databases...

aheadley (3/13/2013)

---

I get the following error: Each GROUP BY expression must contain at least one column that is not an outer reference

when I try to run this query:

INSERT INTO...

Hi and welcome to SSC. Since you are new around here you probably have not had a chance to see the article about best practices when posting questions. You can...

You could use SSIS but somewhere along the way you will have to write some queries for this level of custom data comparison.

sql4us (3/13/2013)

---

Hi All,

I want to know how to add percentage symbol(%) to my final sql statment column names in stored procedure, query below

set @finalSelect = 'SELECT NAME,State,TotalPop, ' + @parameter...

You are going to have to write your own queries for this. This type of thing is generally done using left joins from one table to the other. Without any...

Mick Opalak (3/13/2013)

---

Notice how the DB_Roles and Server_Roles columns are super wide, even with the Maximum set in the options like you suggested. I need these last two columns...

Seems to me that the only real issue here is that you have a varchar(64) column that should be a datetime column.

As you said yourself, there is not much information...

Lynn Pettis (3/13/2013)

---

Sean Lange (3/13/2013)

---

tn_350z (3/13/2013)

---

Hopefully, I am posting this in a right area if not I am sorry. Dont mind the $$$$,#### and ****

I am trying to get...

Erin-489205 (3/13/2013)

---

I am trying to create an update trigger that updates isactive field depending on different criteria.

If DateField1 is >= GETDATE() OR DateField2 >= GETDATE() AND Extension =1 then IsActive...

tn_350z (3/13/2013)

---

Hopefully, I am posting this in a right area if not I am sorry. Dont mind the $$$$,#### and ****

I am trying to get the last 60 days...

Mia G (3/13/2013)

---

I was greeted this morning with alerts that the user connection count on one of our testing DB server was up to 380. I verified this amount...

rajagopalanseeth (3/13/2013)

---

Hi,

I have a table that has around 5000 records. I have a requirement that i want to change a varchar column to UNIQUE, but the problem...