Luis Cazares (5/1/2015)

---

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him...

Ed Wagner (5/1/2015)

---

Sean Lange (5/1/2015)

---

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with...

Jeff Moden (5/1/2015)

---

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him and Ed...

You should stop using the text datatype. It has been deprecated for a decade and is a serious pain to deal with. You have to cast/convert it to varchar(max) every...

diogo_1984 (5/1/2015)

---

I wish my transform variable, so that adding the OR operator, and the words within the quotes are not to put the OR.

ALTER PROCEDURE

@product = ' 'ORANGE LEMON'...

Sam Garth (5/1/2015)

---

I have another similar one if anyone can help.

CREATE TABLE #Courses (RandomID INT, PersonID INT, CourseTitle NVARCHAR(200), CourseDate DATETIME)

INSERT INTO #Courses

VALUES

(1,1,'Maths','2015-05-01 15:30'),

(2,1,'Science','2015-05-01 15:30'),

(3,1,'Science','2015-05-01 15:30'),

(4,1,'Science','2015-06-01 15:30'),

(5,1,'Maths','2015-04-01 15:30'),

(6,2,'Science','2015-05-01 15:30'),

(7,3,'Science','2015-05-01 15:30'),

(8,4,'Science','2015-05-01...

diogo_1984 (5/1/2015)

---

I have a problem I'm having trouble solving.

I have an application I write a textbox: 'SQL SQL' MICROSOFT 'SQL SQL'

When I click a button, I wanted to receive as...

waseemshaikh345 (5/1/2015)

---

Hello I am trying to find a way where I can search for a column that is associated in all tables of the database. I have created a...

No kidding. This is yet another reason why...

I agree!!! Especially hate them when they don't have the proper datatypes and causes issues like this. They are also...

For anybody else wanting to look at this I formatted it and put it in a code window so it is legible.

CREATE PROCEDURE [Spr_Insert_CR_Property_Seizure] (@XmlDoc NTEXT)

AS

BEGIN

DECLARE @iDoc INT

DECLARE @Unit_ID INT

DECLARE...

And one last suggestion, you should NOT store calculated data like CumulativeGPA. You should instead calculate that as you need it. This is like storing Age, as soon as you...

Your tables are severely lacking in normalization. You...

mm7861 (4/29/2015)

---

The Fiscal Year will always start on 6th April. I've managed to create the Fiscal Start Date based on the DateKey in the calendar table using this code;

SELECT DateKey,...

No there are two links I posted. The first one...