Eric M Russell (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a forum to answer questions that you should answer on your...

Steve Jones - SSC Editor (5/18/2016)

---

This is certainly an implementation issue (and a knowing of the standard that is being followed). However, that's part of why I thought it was...

crmitchell (5/18/2016)

---

patrickmcginnis59 10839 (5/18/2016)

---

Perry Whittle (5/17/2016)

---

This is not an integer expression.

The code first checks the binary values for @a and...

Lowell (5/18/2016)

For Q1 &2 ,hope this helps. I recently upgraded my windows 7 laptop to windows 10.

I have the VS2010/VS2012/VS2013 installed,and use them all depending on which environment i'm supporting.

that...

Perry Whittle (5/17/2016)

---

This is not an integer expression.

The code first checks the binary values for @a and @b-2, do they...

Jeff Moden (4/26/2016)

---

Solomon Rutzky (4/25/2016)

---

Disagree with what, exactly? You started this whole sub-topic of "Tower of Babel" because you mistakenly thought that Sachin was introducing both VB and C#. Since...

Solomon Rutzky (4/25/2016)

Disagree with what, exactly? You started this whole sub-topic of "Tower of Babel" because you mistakenly thought that Sachin was introducing both VB and C#. Since that isn't...

Make it a case statement!

CREATE FUNCTION [dbo].[KDT_FN_FORMATDATETIME](

@DateFormatvarchar(50),

@DateDATETIME

)

RETURNS VARCHAR(30)

AS

BEGIN

RETURN CASE

WHEN @DateFormat = 'dd-mm-yyyy' THEN Cast(day(@Date) as varchar(2))+'-'+(substring(datename(m, @Date),1,3))+'-'+cast(year(@Date) as varchar(4))

WHEN @DateFormat = 'MMM DD YYYY HH:mm Am/pm' THEN CONVERT(VARCHAR(30),@Date,100)

WHEN...

since you're going through the trouble of doing dynamic sql because of changing database names, maybe its worth your while to look at parameters of sqlcmd. Its much more convenient,...

you'll also have to include the question from the quiz_data table or else you'll be using the same (unselected) answers on all the questions.

My guess follows, not tested however!

SELECT Student,...

Sachin Nandanwar (4/5/2016)

---

Few months back I had a situation where I had to create instance of class that supported multiple inheritance(MI).C# does not support MI but C++(CPP) does.C# supports MI...

was anybody able to get a tally table looking solution to work with the delimiter inside quotes exclusion? its obviously easy with a loop, but was curious about the tally...

Jeff Moden (4/5/2016)

---

So why make it more of a hodgepodge? Both C# and VB are...

chrisn-585491 (3/31/2016)

---

Gary Varga (3/31/2016)

---

Manic Star (3/31/2016)

---

chrisn-585491 (3/31/2016)

---

As do I, since not all clients understand or enable PS or any other advance...

Jeff Moden (4/4/2016)

---

So then you agree that there should be no language barriers and that anyone can bring whatever they're comfortable with to any task, correct? Whether I know...