Domain accounts have worked just fine for me for many years.

Koen Verbeeck (4/3/2015)

---

At the top...

I actually came into the "Anything that is NOT about SQL!" forum to ask this question but think it's appropriate here....

How do you report spam?

This is something...

It's worth noting SQLNAIVE, that Eirikur's solution will perform about 3X faster.

I took your solution and put it into a scalar valued function like so:

CREATE FUNCTION dbo.SVF_LOCATE_PATTERN_IN_STRING

(

@Expression VARCHAR(8000),

@SearchString VARCHAR(10),

@OccuranceNumber...

Do you have some DDL and test data so we can re-create and populate your two temp tables?

Nice!

Understood. That's all I could think of, hopefully someone else chimes in.

It has to do with how SSRS explicitly converts values. If the time is 00:00:00 it is assuming you want to treat the values as a...

I recently rolled off a project where we needed to extract some information from the report server catalog (e.g. the reportserver db). This function will includes the report path to...

Since nobody else is providing a solution I'll give it a try. I am simplifying the query against sys.columns because I don't really understand what you are doing. That said,...

You could also modify your stored proc (or ad hoc query) that feeds the dataset to format the data before it gets to SSRS. Your query would look something like...

If you wanted to get a column to act like an identity column but to be a uniqueidentifier instead of an int you could do this:

CREATE TABLE dbo.yourtable

(

pk_col AS newid(),

xxx...

Eirikur Eiriksson (3/31/2015)

---

ScottPletcher (3/31/2015)

---

As a side note, but still critical, let me warn everyone to use lowercase only for data type names in SQL Server. That is, "int" not...

Thanks Luis. That stack overflow thread led me in the right direction.