Piet, Jeff, JCelko, Drew:

This is my almost final draft.  I decided to return just the SUM of seconds of down time of the selected shift of the day, and the...

Great info and articles, Jeff.

On another note, working with the same data:  I would like to filter the data based on date and time, by shift, for example.  I read...

• This reply was modified 8 months, 3 weeks ago by  mjdemaris.
• This reply was modified 8 months, 3 weeks ago by  mjdemaris. Reason: additional info
• This reply was modified 8 months, 3 weeks ago by  mjdemaris. Reason: final form?
• This reply was modified 8 months, 3 weeks ago by  mjdemaris.
• This reply was modified 8 months, 3 weeks ago by  mjdemaris. Reason: missed a couple of steps

This "check" field, is this something that you create as a field in a table?  Because I've never seen that done.

What is the reasoning behind not using BIT flags?  How...

So, this is a derived table and LAG() is a window function.  Well, I just started learning about these and I appreciate the help.  I don't know enough about window...

Thanks Jeff, I will be sure to have some ready to use code in the future.

Right, here's an example of my first thought:

INSERT INTO dbo.table (ProductCode, ProductionDate, SerialNumber)
VALUES ([dbo].[GenerateProductCode], GETDATE(), (SELECT DISTINCT SerialNumber FROM dbo.ItemTable) )

The serial numbers are alpha-numeric, three to...

Yeah, I like that idea.  For instance, if our maintenance crew is prepping for a project, they could use their perpetual cart to add/edit/delete until their list is complete.

  Thank you, Uncle Ben

Ok, so I need one table for storing...

The Excel file is going to be used mainly for the users' viewing pleasure during meetings.  I believe there are going to be two or three different sheets in total,...

So Jeff,

this sounds like a dumb question, but how do I insert a blob (image/pdf/doc) into the table via the SSMS?  Do I need a CAST statement or an SP?

I've...

Jeff,

What exactly determines the print size of the palette?  I'm using Visual Studio to design these reports and have extra columns in the dataset (for the parameters), but I have...

but is there a reason you need to print it from the web (ssrs)?

Brian,

well I was trying to go the easy route for my users.  Select report, enter parameters, view...

Grant,

Ok, so I want to store the files in the Windows file system.  As for using a pointer to the files themselves, that would be the fully qualified file path,...

Well, Mr. Brian Gale,

I took your advice with the global data source and reports and data sets.  Then, I discovered I could change the credentials via the Report Browser.  So,...

Latest update:

"The execution failed for the shared data set 'dataset1', cannot create a connection to data source... for more information navigate to the report server or enable remote errors."

So, I...