Sorry - do not. I...

g.britton (11/6/2014)

---

well, isn't that interesting!

Don't know about the "should be done" bit though. My version doesn't need a self-join. It's just weird that SQL loses track of what...

As I recall - you'd have to convert the SAS date values. per the 9.2 version of SAS documentation online, SAS stores its dates in # of days relative...

Brian Ward (11/3/2014)

---

They is no flag as such but there is a default team which if they belong to two teams is not their main team.

What I did was write...

To confirm this - this behavior only works if you use *variable length* data types. You would not be able to get away with that if you were using...

To the best of my knowledge, expanding the size of a variable length field is a metadata-only operation (the table doesn't get rewritten, therefore the indexes don't have to be...

Grant Fritchey (10/29/2014)

---

Matt Miller (#4) (10/29/2014)

---

Grant Fritchey (10/28/2014)

---

The best way is to have a full script that does the restore and cleans up the database to remove or modify the...

Grant Fritchey (10/28/2014)

---

The best way is to have a full script that does the restore and cleans up the database to remove or modify the data that shouldn't be accessible,...

bicky1980 (10/28/2014)

---

Great - I've adapted your statement, but using the case has solved the issue! Thanks

I worded my original query slightly wrong too! Shoudl have said single=25, deposit=35, monthly=value...

As long as you don't have any decimal points or negative numbers.....

Iwas Bornready (10/27/2014)

---

My experience has been that projects are late because of unrealistic deadlines up front. To take a slower approach would only make them later. To be realistic about...

Meow Now (10/27/2014)

---

Developers love to push CI since it's simple and makes sense with application code. It's a whole new beast when you're trying to automate deployment of a terabyte...

I think this becomes more of a "right-sizing problem" than a "who needs them". Managers should and can be a HELP not a hindrance: mine routinely plays the...

davoscollective (10/20/2014)

---

KoldCoffee (10/18/2014)

---

using Adventureworks2008R2 database I'd like to illustrate syntax I ran into and am unfamiliar with and I want to know if it's a mistake that SSMS doesn't catch.

SELECT...

Have you tried simply combining the 2 statements into 1? Something like

DECLARE @a XML;

WITH XMLNAMESPACES (DEFAULT 'http://www.xxxxx')

select @a=(SELECT FileCreationDate,

(

SELECT PCE_TPD.PJN,

(

SELECT top (2) TaskCode, TaskName, RSI,...