Steve Jones - SSC Editor (6/10/2016)

---

It's funny. Some people see titles, some don't. Some see tags, some don't.

It becomes hard to make a good question that doesn't give things away,...

K-K-K-Kofee ... must ... get ...

The applicant from Hell ...

Luis Cazares (8/5/2015)

---

You could use something as the differences of EXEC() and sp_executesql. Or just ask for them. You might want to ask about how to prevent SQL Injection (or...

OK, thanks.

[font="Comic Sans MS"](but it still looks weird...)[/font]

I have used a trivial example - should have considered that the normal reaction would be that dynamic T-SQL is totally unwarranted for something so silly. I agree.

I already...

The points are not merely "bragging" points. They are a way to recognize the tremendous effort made so generously by the heavy hitters providing answers and guidance to the entire...

"Too much existing code to break".

Microsoft did push Visual Basic dot nyet invalidating VB 6 code.

Microsoft did bump Silverlight off the main path - though still supported, the new Edge...

Thanks, Steve for this question, which highlights that the use of SELF is really dangerous. If you create a procedure and add WITH EXECUTE AS SELF to it, anyone...

I was left with the impression that this would cause the name of the CREATOR of the stored proc to appear even if an another user ran it.

In the old days, [font="Courier New"]NULL[/font] was meant as "does not apply". For instance, in a common table [font="Courier New"]Entities[/font] shared by both persons and legal persons (companies) the row...

Just finishing K. Kellenberger's "Expert T-SQL Window functions in SQL Server". CTE's are used extensively. In...

I suggest you look at your datasource definition. This will tell you where the data is coming from.

Did not think of this possibility. I just considered this was posted in the SSRS forum ...

You will need a column to display the results.

It does not have to be an "extra" column in the tablix, you can use an existing column, if it does not...