It gives me no records, although I have records specific to my username in there, when I remove the filter it works, I am sure there is something wrong with...

I even tried this, still not getting the result set specific to my userid

Under data set properties -> Filters

Expression: network_user_name

Operator = 0

Value =User!UserID

Thank you Michael, I figured it out. I was just missing some brackets.

Here's my stored procedure:

(

@UserFirstName AS varchar(20) = Null,

@EventSource AS varchar(30) = Null

)

Where

al.audit_event_id = '1234'

@UserFirstName IS NULL OR UR.first_name Like '%' + @UserFirstName + '%'

@EventSource IS NULL OR al.event_source LIKE '%'...

Oh Wow, and I was using the CTE's and cross joins , This works and looks so clean.

This actually happened to be a job that whenever there is a...

Yes In this case I only want 1 row stating '1002' under the column 'LID'. In the sample data the datatype for DraftDt and RequestedDt is varchar but in real...

Can anyone help me out here please, I would really appreciate it.

I am working on two techniques but both of them are not giving me the required result>

1)

SELECT DISTINCT LID FROM TEST_TABLE_Dupe_Pay AS A

CROSS APPLY (SELECT TOP 1 B.DraftDt,

...

Thank you guys. That really helps

Wow Luis, that's a masterpiece. !!!!

Thanks Luis,

I am trying to fine tune this:

SELECT distinct

(select count (distinct LoanID) FROM Q_C_Main_Sub1 WHERE DAY(LastWorked) = DAY(GETDATE()) and MONTH(LastWorked) = MONTH(GETDATE()) and YEAR(LastWorked) = YEAR(GETDATE()) and PrimStat =...

Thanks Luis, that works. the reason I wanted to do joins is because there are 8 collectors, and I wanted to get rid of inline queries, If I follow this...

Thanks !!! its working

I read it somewhere merge statement has a less complicated code to write. which would be better in my case, merge or update? merge is getting me...

Can anyone help???

so far I have the code below, I am trying to update TEST_TABLE1 from the table 'SRV' on the server 'New', not sure if I am using correct syntax.

It...