Makes no difference in terms of SQL injection.

😎

Sure made me question but not necessarily did it urge me to write one:-P

😎

sgroesz (9/9/2014)

---

I've set up a report with two parameters, @StartDate and @EndDate. Report users expect to enter the following values:

StartDate: 9/20/2013 EndDate: 9/20/2013 -- Show all records dated...

Quick...

The procedure is either in an...

Quick note, cannot recommend a string manipulation of the XML, rather use the XMLNAMESPACES directive, here is a quick parsing demo, note that the datatype specification in the value functions...

Amu (9/8/2014)

---

I have an application which one of the query (within stored procedure) execution plan keeps changing. I am running rebuild index and update stats on regular basis on this...

agbondoc (8/19/2014)

---

Hi everyone,

I have been task to decode a very long Hex string to decimal for further analysis. The output I'm told should be two (2) columns between 2,000...

Thanks for the question Steve but oooops:crazy:, please correct the answer!

😎

Sean Lange (9/8/2014)

---

Just for grins here is another way to do this. This is a little convoluted but I want to use integer math for this. 😀

create table #SomeDates (MyDate...

As mentioned before, this can be an injection attack surface if not done properly, normally far more fail there than succeed. Look first at other alternatives like Gail's "catch all",...

In order to advice any further on the subject, more information is needed, without the info on network topology, connectivity etc., it is pure guesswork.

Keep in mind that in order...

itsanjayg (9/8/2014)

---

Hello Mr. Steve,

thanks for question.

I tried in SQL2012 and it works fine without any error.

like this....

CREATE SYNONYM Emp FOR Appconfig

SELECT * FROM emp

it will successfully show all records...

Ooops, greater than is stead of less than in the last filter:pinch: Misread the post as "where three last activities are in a period greater or equal to 15 days"

😎

USE...

For completeness, here is a complete solution to the problem using the method I posted earlier and the sample data set posted.

😎

;WITH QUERY_BASE AS

(

SELECT

...