Anybody?

http://arcanecode.com/2010/07/13/adding-query-parameters-to-sql-server-2008-reporting-services-reports/

This helped me alot, and creating a Dataset with the custom values I wanted I.E. 1, 2, 3 and Adjustment/Transfer/Variance

Perfect thank you! That makes more sense now lol

So its because its going through a series of filters rather then determining if the value is or is not there.

Why would that where clause not work? Ive used similar ones before :/

SHIT! Thanks stupid stupid stupid me 🙂

Luis Cazares (5/14/2014)

---

That's the beauty of relational databases, you don't need to store the repeated values. You just need to use the joins wisely.

CREATE TABLE #Employees(

emp__id...

Its because I need to create a report that sees what employees have put in time or not for the last week. And unfortunately we have 2 different systems for...

I did it when I was messing around with it, I posted the original code.

Hmm, how would removing NOLOCK give inaccurate data?

And ya I just graduated last May and my ive been really lucking in bringing up mt T-SQL, however I wish I was...

I was going to but still all the subscriptions and the disabling them when the job is finished is still extremely stupid, since the description of the subscription just shows...