Viewing 15 posts - 1 through 15 (of 23 total)
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...
July 31, 2024 at 4:13 pm
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...
July 25, 2024 at 1:52 am
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...
June 28, 2024 at 4:04 pm
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...
June 25, 2024 at 4:24 pm
Thanks Jeff, I will be sure to have some ready to use code in the future.
June 25, 2024 at 4:16 pm
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...
April 24, 2024 at 4:11 pm
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.
April 17, 2024 at 4:30 pm
With great power comes great responsibiity!.
Thank you, Uncle Ben 🙂
properly structured set of tables for use in a multi-tenant environment
Ok, so I need one table for storing...
April 16, 2024 at 4:00 pm
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,...
February 21, 2024 at 1:58 am
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...
October 31, 2023 at 5:27 pm
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...
October 30, 2023 at 5:12 pm
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...
October 27, 2023 at 6:24 pm
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,...
October 27, 2023 at 6:14 pm
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,...
August 31, 2023 at 11:58 pm
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...
August 31, 2023 at 5:30 pm
Viewing 15 posts - 1 through 15 (of 23 total)