(Your answer solved the error - thanks!)

Thanks for your input.

The first part of my post was an typo on my part - I had been getting the 'incorrect syntax' previously...

• This reply was modified 5 years, 5 months ago by  cajun_sql.
• This reply was modified 5 years, 5 months ago by  cajun_sql.
• This reply was modified 5 years, 5 months ago by  cajun_sql.

Thanks very much!

I've been also looking at the example in the link you referenced. I just left the @urlKEY value empty, as I wasn't sure where its value came...

Thanks,

I've been working on this search/replace string and had a question about why the replace still is not occurring.

Below is the actual SQL I've been using in test:

UPDATE [dbo].[tbl_a]

SET...

daniel.freedman 80164 (10/15/2015)

---

It looks like you're overthinking it. Try something like this:

INSERT INTO aaa_test_users (UserName, first_name, last_name)

FROM aaa_test_sp

INSERT INTO aaa_test_users_positions (UserID, position, phone)

SELECT aaa_test_users.UserID, aaa_test_sp.position, aaa_test_sp.phone

FROM...

Sean Lange (8/20/2014)

---

cajun_sql (8/20/2014)

---

Sean Lange (8/20/2014)

---

cajun_sql (8/20/2014)

---

Thanks.

Why does the SQL INSERT statement succeed where...

Sean Lange (8/20/2014)

---

cajun_sql (8/20/2014)

---

Thanks.

Why does the SQL INSERT statement succeed where the Recordset AddNew...

Thanks.

Why does the SQL INSERT statement succeed where the Recordset AddNew fails?

Thanks - I wanted to share the solution, thanks to user AlwaysLoadingData on StackExchange:

SELECT

KSA.ID as KSA_ID

,KSA.KSA_Version

,KSA.KSA_Sort_Order_Number

...

LutzM (11/27/2013)

---

I'd go with a separate table with the columns ObjectiveId (as a foreign key reference to the current table), OutcomeId, KSA_aspectNo, KSA_AspectValue together with a column referencing the related.

I'm...

:-)Thanks for the great question, and (in your answer) thanks for showing the scenarios in which the other choices could be valid.

Nice detail work.

Thanks for the great question! Can't ever get enough on triggers! 🙂

I don't work with triggers that often, so it's a great boost to get a good question...

Thanks for this!

I've been using a similar script, and I was wondering if it would be possible to include data in the same row as the data found? In...

Miles Neale (2/19/2013)

---

True or False: If a train leave Detroit going east at 40 MPH and a truck leaves Bosie Idaho going west three hours earlier at random speeds...

Yes, it would be very interesting to learn more about CHOOSE. While I don't currently run 2012, I think a question that applied more to the functioning of the...

If I could see any movie in a theater, it would be "Ball of Fire" with Stanwyck, Cooper, and Gene Krupa. Being a drummer myself, this is heaven! 🙂