Helpful Queries - Revision history

Cody Gallagher at 17:44, 15 May 2020

2020-05-15T17:44:13Z

Cody Gallagher at 17:43, 15 May 2020

2020-05-15T17:43:57Z

Cody Gallagher at 17:42, 15 May 2020

2020-05-15T17:42:48Z

Cody Gallagher at 15:16, 27 February 2020

2020-02-27T15:16:24Z

Cody Gallagher at 22:59, 26 February 2020

2020-02-26T22:59:50Z

Cody Gallagher at 22:57, 26 February 2020

2020-02-26T22:57:14Z

Cody Gallagher at 22:09, 26 February 2020

2020-02-26T22:09:53Z

Cody Gallagher at 22:03, 26 February 2020

2020-02-26T22:03:20Z

Cody Gallagher at 20:36, 26 February 2020

2020-02-26T20:36:43Z

Cody Gallagher: Created page with "''This page contains queries that have been found useful for Prams users.'' ---- ◄ QueryX2 To use one of the queries below, copy all the data and paste into QueryX2, ch..."

2020-02-26T20:36:35Z

Created page with "''This page contains queries that have been found useful for Prams users.'' ---- ◄ QueryX2 To use one of the queries below, copy all the data and paste into QueryX2, ch..."

New page

''This page contains queries that have been found useful for Prams users.''
----
◄ [[QueryX2]]

To use one of the queries below, copy all the data and paste into QueryX2, change the parameters, then run the query.

If you are having difficulties running a query or need a new query built, call Prams at 303-904-6855.

{| class = "wikitable"
|-
|Query 1
|Code
|Result
|-
|}

@@ Line 53: / Line 53: @@
 </syntaxhighlight>
 |-
-<!
+<!--
---Template
+Template
 | Query Name
 |<syntaxhighlight lang="SQL"> code </syntaxhighlight>

@@ Line 53: / Line 53: @@
 </syntaxhighlight>
 |-
 --Template
---| Query Name
+| Query Name
---|<syntaxhighlight lang="SQL"> code </syntaxhighlight>
+|<syntaxhighlight lang="SQL"> code </syntaxhighlight>
---|-
+|-
 |}

@@ Line 31: / Line 31: @@
 ORDER BY s.user_ref, prod_date
 </syntaxhighlight>
 |-
 |}

@@ Line 9: / Line 9: @@
 {| class = "wikitable"
 |-
-|Query 1
+|Start and End Lease total Inventories.
 |<syntaxhighlight lang="SQL">
 #TOTAL 5 6
 ----------------------------
---Change these parameters'
+--Change these parameters:
 #DEFINE :AGR='The Lease #'
 #DEFINE :PDT='mm/dd/yyyy'
@@ Line 31: / Line 31: @@
 ORDER BY s.user_ref, prod_date
 </syntaxhighlight>
-|Result
 |-
 |}

@@ Line 10: / Line 10: @@
 |-
 |Query 1
+|<syntaxhighlight lang="SQL">
+#TOTAL 5 6
 |-
 |}
@@ Line 17: / Line 37: @@
-<syntaxhighlight lang="python" line='line'>
 Copyright © {{CURRENTYEAR}} by PRAMS Plus LLC. All Rights Reserved.

← Older revision		Revision as of 20:36, 26 February 2020
Line 14:		Line 14:
	\|-		\|-
	\|}		\|}
		+
		+
		+
		+
		+
		+
		+	Copyright © {{CURRENTYEAR}} by PRAMS Plus LLC. All Rights Reserved.