No Idea (7/8/2009)

---

Thank you very much Terry, that worked on my sample data so I'm sure it will work on the rest. I do not know how the

LEFT OUTER JOIN...

No Idea (7/8/2009)

---

Thank you very much Terry, that worked on my sample data so I'm sure it will work on the rest. I do not know how the

LEFT OUTER JOIN...

No Idea (7/8/2009)

---

Thank you very much Terry, that worked on my sample data so I'm sure it will work on the rest. I do not know how the

LEFT OUTER JOIN...

Greetings,

For your INSERT:

INSERT INTO TestID

(OldLicenseNumber)

SELECT

DISTINCT OldLicenseNumber

FROM TableFrom2002

WHERE NOT EXISTS

(SELECT OldLicenseNumber FROM TestID)

You might want to change this to:

INSERT INTO TestID (OldLicensceNumber)

SELECT DISTINCT

t2.OldLicenceNumber

FROM...

Greetings,

The SQL engine will convert an integer number to a decimal number automatically when performing a math function and when one of the parts is a decimal number. In...

Greetings,

Maybe what you could try is a WHILE loop.

DECLARE @StPos int

DECLARE @StartID int

DECLARE @StopID int

DECLARE @DoneFlag bit

DECLARE @String varchar(MAX)

DECLARE @ID varchar(20)

SELECT

@StPos =...

trudye10 (7/8/2009)

---

Hi guys, I am receiving the error:

The multi-part identifier could not be bound. Here is the code:

UPDATE dbo.tbl_fees

SET dbo.tbl_fees.TRCODE = DDTRNF.TRCODE,

dbo.tbl_fees.TRDATE = DDTRNF.TRDATE

From DDTRNF INNER JOIN...

Jeff Moden (7/7/2009)

---

GSquared (7/7/2009)

---

Ian Scarlett (7/7/2009)

---

Rather than add a SortOrder column to the table, just include one in your query e.g.

select id, forename, case when forename = 'Kim' then 1...

Greetings Michael,

What you might be able to do is create a computed column based on a sub select to hold your average.

SELECT

*,

(

SELECT

...

Greetings Kevin,

You might first want to try modifying the .NET code by adding:

protected void _Selecting(object sender, SqlDataSourceSelectingEventArgs e)

{

...

Greetings,

Maybe this might be a way to get your records to the second procedure.

DECLARE @HldClassID int

DECLARE @HldStudentID int

DECLARE ClassesCursor CURSOR LOCAL READ_ONLY FOR

SELECT

...

Greetings Lee,

Thank you for your reply and the code. I have not worked with Multidimensional Expressions (MDX) before. So, it may take a bit of time to study...

Greetings Richard,

Do you have a table for the different teams and for different team members?

If so, then what you could do is this:

SELECT

s1.TeamName,

s1.TeamMemberName,

ISNULL(a.AppointmentYearMonth, 'NA')...

So what does the edge of the coin have to do with encryption? It would seem nothing at all, other than to consider that the chances of getting the...

AndyD (4/10/2009)

The quantum guys say there is no way to predict the flip of a coin. Einstein would argue there is. IFF you knew all of the forces and assumptions,...