Viewing 11 posts - 31 through 41 (of 41 total)
Here's an example table:
CREATE TABLE Start
(
Start_IDCHAR(10)NOT NULL,
School_State_StartCHAR(25)NOT NULL,
)
;
INSERT INTO Start
(
Start_ID,
School_State_Start
)
VALUES
('1234','Ready'),
('5678','Ready'),
('6546','Ready'),
('9874','Ready'),
('6510','Ready'),
('9871','Ready'),
('3333','Soon'),
('1111','Soon'),
('2222','Soon'),
('4444','Soon'),
('5555','Soon'),
('6666','Soon'),
('7777','Soon'),
('9876','Someday'),
('9999','Someday'),
('1298','Someday'),
('4321','Someday')
Here is the query I used to stack the results in SSMS to make analysis easier
SELECT 'Ready' AS 'Current Cycle', COUNT(DISTINCT.Start.Start_ID)...
May 3, 2012 at 12:22 pm
Thanks for the explanation and example. Another of the many purposes of chicken... 🙂
May 2, 2012 at 3:48 pm
Evil Kraig F (4/30/2012)
May 1, 2012 at 1:32 pm
Thanks for the replies. Here is the error I'm receiving
Error converting data type varchar to numeric.
Here is the actual query, which is at the end of a few cte queries:...
May 1, 2012 at 1:11 pm
Grant Fritchey (4/18/2012)
GilaMonster (4/18/2012)
DataAnalyst110 (4/18/2012)
if not exists (select * from master.dbo.syslogins where loginname = N'GalacticReporting')
BEGIN
declare @logindb nvarchar(132),...
April 18, 2012 at 8:49 am
SQLKnowItAll (4/18/2012)
Take a look here at the sp_addlogin stored proc. It shows you the parameters.
Thanks Jared. That's helpful.
April 18, 2012 at 8:48 am
GilaMonster (4/18/2012)
DataAnalyst110 (4/18/2012)
if not exists (select * from master.dbo.syslogins where loginname = N'GalacticReporting')
BEGIN
declare @logindb nvarchar(132), @loginlang nvarchar(132)...
April 18, 2012 at 8:40 am
Thanks Jared. That did just what I needed.
April 10, 2012 at 1:08 pm
One more question on this particular query. Notice I have to put "WHERE holder_Version_Code_Enrollment = 'AR-46'" in every SELECT statement. Is there any way to do this once for the...
April 10, 2012 at 12:38 pm
Thanks for pointing out the obvious 🙂 I was looking for something technical, and should have checked the syntax again!
April 3, 2012 at 2:26 pm
Thanks, Jared. Here she is...
/*Primary Applications Received*/
SELECT 'Primary Applications Received' AS 'Current Application Cycle', COUNT(DISTINCT Enrollment.Individual_ID) AS Count
FROM Enrollment JOIN Individual_Status_Changes ON Enrollment.Enrollment_ID = Individual_Status_Changes.Enrollment_ID
WHERE holder_Version_Code_Enrollment = 'AR-46'
AND Individual_Status_Changes.Individual_New_Entity_Status =...
April 3, 2012 at 2:13 pm
Viewing 11 posts - 31 through 41 (of 41 total)