Michelle-138172 (7/6/2015)

---

We are in the process of moving existing clustered SQL server databases to AWS. There is one major database that has intensive reads and writes transactions. I'm wondering what...

ByronOne (7/6/2015)

---

Thanks for getting back Steve. I'm still struggling to get this to work. I create the new field as suggested and add a filter using this field in the...

Please see my updated code above, as I realized there was a condition that could break it.

BallaKet (7/5/2015)

---

Hello!

I created a new job that keeps on failing with the following message:

"xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query,...

OLSONEJ (7/6/2015)

---

sg, my apologies for the confusion.

This will operate based on fiscal year 07-01-2014 to 06-30-2015. I am in need of a count of consecutive fiscal years...

OLSONEJ (7/6/2015)

---

Ok, started playing with this a little more over the 4th. I have come up with the following and it is getting the count of years based on...

You could use an EXECUTE SQL Task with the destination of the data being a variable instead of some kind of recordset destination. Then you can test the...

ByronOne (7/5/2015)

---

An update....

When I add the format(parameter name, "MMM yyyy") to the linked report parameters it does bring back the months relevant data but only for the first day of...

abhas (7/6/2015)

---

Hi All,

I am having a column which is ntext and contains below type of data.

{ "running":"true", "all":{ }, "GPAs" : [ {"type":"item", "alias":"i_11111"} ,"GPA":"1.75" }, {"element": {"type":"item", "alias":"i_11111"}...

santa326 (7/3/2015)

---

Hi ,

This is What I tried.

Finally I am trying to get Document ID as well into the Final Table.

CTE work fine if I execute from "WITH" till end.

--Indent Numbering

--select...

coachmkavanaugh (7/5/2015)

---

Holy cow, thank you so much! This is very close!!!

There seems to be some duplicates returned from the query, sometime 2 times, other times 3, some 4 times.

Times...

coachmkavanaugh (7/4/2015)

---

This is what was returned when applied to the competition.

last_Namefirst_nameAgeEventMeetmotivational_descriptiontime_standardmin_agemax_ageFinished Time

StimesKelsey16200 I.M.DCST @ WDSTAA2:19.7916162:18.92

This logic sems to work when it applied looking for the highest total level motivation_description. I...

blueazul (7/2/2015)

---

I'm mostly curious why SQL Server's async cursor population is not working as I would expect. I have no exact problem to be solved. In general, an async cursor...

coachmkavanaugh (7/4/2015)

---

It did on my test case momentarily and then when I applied to my larger population it didn't.

I am not sure what happened. I am not sure where to...

coachmkavanaugh (7/2/2015)

---

This sorts it by the motivational type, but if someone has a 'AAAA' value returned, I don't want any of the other times returned. I want to keep the...