very dumb question probably but what user details are you missing exactly ? Group 3 has only one user isn't it ?

I am assuming here that you have integration services installed on the machine.

Can you see tool box on the control flow ? if not right click on the control flow...

Just out of curiosity.. Can't we have OR statements for date ranges after last AND clause within parenthesis () to overcome the problem ?

If not then may be store the...

fetch the first day of the every month then check for its day (as in.. monday,sunday etc..) then on the basis of the outcome .. add 0-6 days to the...

May be.. Anyway Thank you once again.

It works, Thank you Phil. But still it makes me wonder why did ordering DOJ in ascending order changed the output of the column there ? Can you please elaborate...

I could be wrong here but writing a macro to generate EXCEL for each value from the pick list should solve your problem.

Please see if below given code helps in understanding what changes you might have to do to make it work

CREATE TABLE #LOG

(

ERROR VARCHAR(8000)

)

CREATE TABLE #TEST

(

ID SMALLINT

)

BEGIN TRY

BEGIN TRAN

INSERT INTO #TEST

SELECT...

Please take a look at

https://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/.

See if it helps.

EXCEPT operator to find non existing records ? :unsure:

Nice 😀

While executing following script please see results to text...And I used '*' considering you don't have one in the field where you want to do it ... But I believe...

If there isn't any blocking or any other SQL statement running at that moment..could network congestion be an issue ? or automatic file growth happening at the background ? ......

Are you sure that you are taking the backup of the right database and not appending it to the existing backup file? or at least referring to the right backup...

Google is our friend

http://technet.microsoft.com/en-us/library/ms365338.aspx

http://www.codeproject.com/Articles/194097/SSRS-Series-Part-I-Various-ways-of-Report-creation

http://www.sqlcircuit.com/2012/11/ssrs-different-ways-of-deploying-reports.html