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

...

DAVID.MANGATAL (9/7/2014)

---

I use SSIS Business Intelligence Development Studio 2008R2 to handle ETL tasks from relational databases and flatfiles.

One client has asked me to extract from a third parties RESTful API...

In short: A clustered index can be thought of as the structure of the table, it can only have one structure at the time. In other words, it determines the...

Here is an example code demonstrating a method but not a solution. For a full solution, follow Lynn's advice on supplying further information.

😎

USE tempdb;

GO

;WITH SAMPLE_DATA(ACTIVITY_DATE) AS

(SELECT ACTIVITY_DATE FROM (VALUES

...

Luis Cazares (9/7/2014)

---

Isn't that...

Just a thought, what about the ability to rate questions? Could be something like "splendid question" all the way down to "interesting" or "PICNIC".

😎

...but it works for Joe in HR (that's his default schema);-)

😎

Luis Cazares (9/7/2014)

---

This is like torture. I'm at the office, unable to watch the first games of the NFL season and can only see all the spam promoting supposed pages...