Please post the full error message you are getting as well as the queries that are failing.

I have a guess at what is happening, I would like to see the...

mw112009 (5/14/2015)

---

no did not work.. Since this was an link to an Oracle database.

However I found it while googling...

Select top 100 * FROM CDRQ_Moderage..[CDR].[EEG_TEXT_T]

This works! 🙂 GOT TO...

from

Test.dbo.PREL P, << do you mean to have this here

[ZZZ\XXX].HCM.dbo.tPerson --Did you mean to do a cartesian join here??

inner join [ZZZ\XXX].HCM.dbo.tPersonLocationHist tPersonJobHistAlias

on (tPerson.PersonGUID = tPersonJobHistAlias.PersonGUID and tPersonJobHistAlias.PersonLocationEndDate is...

aaron.reese (5/14/2015)

---

I am trying to run a test migration of our application from V8 to V9. To do this I am creating an empty database by running the Tasks...

Prem-321257 (5/14/2015)

---

It does have matching parameter.

SiteID - int

UserID - varchar(32)

If we remove the user_login_test view in the query and replace it with one of the permanent table - it runs...

mw112009 (5/14/2015)

---

Please see attached. We were able to successfully create a link.

I am having a hard time writing a "Select top 100 * FROM ???? "

Help...

rtrice81 (5/14/2015)

---

It would be 3 years to the day the query is ran, my date column is CAST(CustomPollersStatus.Status AS Date)

I updated the WHERE to this

WHERE (CustomPollers.UniqueName = 'APCupsBasicBatteryLastReplaceDate') AND (CAST(CustomPollerStatus.Status...

They could be anything...

thomashohner (5/13/2015)

---

I actually just took this exam last week. Yes much more of a trivia contest then a measure of skill. I'm doing the MCSA track because my employer is...

Only two reasons I would get the certs right now. One, if my employer came to me and said it was a requirement for my job. Two, validation of...

You need to grant VIEW SERVER STATE to the SQL login or a role to which it belongs.

Luis Cazares (5/13/2015)

---

Lynn Pettis (5/13/2015)

---

May or may not answer the question. How do you want to handle the null date values? What would the results look like if...

Luis Cazares (5/13/2015)

---

This seems to do the trick. Please be sure to understand what it is doing and ask any questions that you have.

Running totals became a lot easier on...

jasona.work (5/13/2015)

---

Looks like Grant hadn't had his daily mandatory caffiene intake when he posted here:

:hehe:

On an unrelated note, does anyone here have any experience with Barracudda Networks backup appliance, both...

Luis Cazares (5/13/2015)

---

This is very similar to what Lynn already posted, with a little improvement to make the JOIN clause SARGable. I agree that recursion is not needed, neither the...