smckibbe01
Last Activity: Jul 24 '08, 05:20 PM
Joined: Nov 10 '06
Location:
-
Thanks for your help CK!! -
Unfortunately I have four keys {psPlant, psDate, psMachine, psPipe}
The table looks like:
>psPlant,nvarch ar(1)
>psDate,datetim e
>psMachine,nvar char(1)
>psPipe,nvarcha r(15)
psScheduled,int
psPoured,int
psUpdated,bitLeave a comment:
-
Here is some sample output data. I'm putting it in comma delimited format. I'm not sure if there is a better way.
...Code:Max Turns,AMP,Tons,Sched,Poured,Type,Date(0),Date(1),Date(2),Date(3),Date(4),Date(5),Date(6) ,,0.508,,,153CPB,,,, ,,0.508,,,154CPB,,,, ,,0.508,,,155CPB,,,, ,,0.671,200,,183CPB,160,160,160,160 ,,0.671,,,184CPB,,,, ,,0.671,,,185CPB,,,, ,,1.0605,100,,243CPB,,,,
Leave a comment:
-
I have provided all the information I can about this issue. Can anyone help me. It would be greatly appreciated.Leave a comment:
-
This is what the pivot table looked like when I wrote it with access. Do you know of a page on the internet that describes the differences between access and sql server 2005 pivot table syntax
...Code://string SQL1 = ""; //SQL1 += " TRANSFORM SUM(ps."; //if (SchedPoured.Text.ToString() == "Scheduled") // SQL1 += "psScheduled)";Leave a comment:
-
Like the SQL I provided in the first two messages.Leave a comment:
-
Scheduled:
,,0.508,,,153CP B,,,,
,,0.508,,,154CP B,,,,
,,0.508,,,155CP B,,,,
,,0.671,200,,18 3CPB,160,160,16 0,160
,,0.671,,,184CP B,,,,
,,0.671,,,185CP B,,,,
,,1.0605,100,,2 43CPB,,,,
,,1.0605,,,244C PB,,,,
,,1.0605,,,245C PB,,,,
,,1.535,,,303CP B,,,,
,,1.535,,,304CP B,,,,
,,1.535,,,305CP B,,,,
,,2.0945,50,,36 3CPB,80,80,80,8 0
,,2.0945,,,364C PB,,,,
,,2.0945,,,365C PB,,,,...Leave a comment:
-
pi.piAMP,
pi.piTons,
'',
'',
ps.psPipe,
psDate(0),
psDate(1),
psDate(2),
psDate(3),
psDate(4),
psDate(5),
psDate(6)Leave a comment:
-
The following is PipeInfo for plant "A" and PipeScheduling for one week for plant "A".
PipeInfo:
piPlant,piMachi ne,piPipe,piSeq uence,piMaxTurn s,piAMP,piTons
A,1,153CPB,1,,, 0.508
A,1,154CPB,2,,, 0.508
A,1,155CPB,3,,, 0.508
A,1,183CPB,4,50 ,,0.671
A,1,184CPB,5,,, 0.671
A,1,185CPB,6,,, 0.671
A,1,243CPB,7,50 ,,1.0605
A,1,244CPB,8,,, 1.0605
A,1,245CPB,9,,, 1.0605...Leave a comment:
-
Does anyone know a better way of doing this?Leave a comment:
-
I found Report.NET which works great!!!Leave a comment:
-
I found some software to do this in AS400 with RPG from Symtrax called Compleo.
Does anyone know of an equivalent for the .NET Framework?Leave a comment:
-
C# Generate and Email a PDF
I have a C# program that I would like to generate a PDF from a report and email it without saving it first and then generate the PDF from the saved file. Is this even possible with C#? Any advice or direction would be greatly appreciated. -
This is what I've come up with so far. It is still alitte slow. Any advice?
...Code:SELECT pi.piMaxTurns, pi.piAMP, pi.piTons, '', '', ps.psPipe, SUM(CASE WHEN psDate = '1/7/2008' THEN ps.psScheduled END) AS Col1, SUM(CASE WHEN psDate = '1/8/2008' THEN ps.psScheduled END) AS Col2, SUM(CASELeave a comment:
-
Convert MS Access Pivot Query to SQL Server 2005
I have Pivot Table query in MS Access that I would like to run in SQL Server 2005. Can anyone help me to convert the syntax over to SQL Server. The following is the query in MS Access:
...Code:TRANSFORM SUM(ps.psScheduled) SELECT pi.piMaxTurns, pi.piAMP, pi.piTons, '', '', ps.psPipe FROM PipeScheduling ps -
That works great! Thanks!Leave a comment:
-
C# SQL Server SELECT STATEMENT Class
I've written class in C# that performs a select statement in SQL Server and retrieves the reader rows into a DataTable. I then use the DataTable to populate a datagrid, listbox, etc...
I think this class is inefficient. Does anyone have any ideas to make it faster or cleaner if that is possible.
...Code:class db_Select { public db_Select(string SQL) { SqlCommand -
I added some more memory from 512 to 1280 and it runs much better on the slowest machine.Leave a comment:
-
I appreciate all your help. I am going to try to get the slowest user more memory and hopefully that will determine if that is a factor.Leave a comment:
-
Yes but it is still slow with that grid unless they get out of the whole and then go back in.Leave a comment:
No activity results to display
Leave a comment: