Jason Selburg (10/7/2015)

---

SELECT col1, col2, col3, CAST(NULL as BIT) as newCol4, CAST(NULL as VARCHAR(6)) as newCol5 FROM yourTable

in this example, newCol4 and newCol5 are your non-existent columns. Using the CAST,...

Thank you for the links. I came across IF...

Same error message.

Lynn Pettis (8/31/2015)

---

The following should work:

update n SET

[INTERNET-ADDRESS] = 'bsmith@acme.com'

from

SKYWARD.PUB.NAME n

INNER JOIN SKYWARD.PUB.QUDDAT-DATA qd

...

Lowell (8/31/2015)

---

this looks right to me, and is sytactically correct, but you didn't mentione what the new value was.

i would use the ansi 92 syntax to make it clear to...

Thanks. It's been updated.

Thank you for your quick reply. If I use an UPDATE statement for this, how do I tell it to match on the employee number between the spreadsheet and the...

Thank you for the feedback. I had to alter what you posted slightly to get it to work. See below:

Thanks for the feedback I will look over the article you posted a link to and back to you. Thank you for taking a look at this for me.

Looking at the query, I don't see anywhere that is calculating the percentages?

I do not have a sql insert statement for this data as it is being inserted from a...

There's so much to know about BI but I can break it down into 3 groups: Reporting, ETL and Analysis. If you want to go the reporting route learn SSRS...

I think this is what you are asking for:

USE [CurriculumPD]

GO

/****** Object: Table [dbo].[LDCScores] Script Date: 6/3/2015 8:02:38 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE...

J Livingston SQL (3/10/2014)

---

maybe of some use

with cte_names as

(

SELECT StudentID, MAX(StudentName) AS StudentName

FROM lcdscores

GROUP BY StudentID

)

SELECT lcdscores.StudentID

...

Attached is a spreadsheet that depicts what we have in SQL and what the output needs to be based on that information. It is a very small sample, but you...

IT wasn't notified of the project until last minute. An excel spreadsheet was already distributed out to teachers to submit their scores with. It's not the ideal situation, but it's...