Grants & Nonprofit Local Training and Educational Opportunities Calendar
Error: Invalid object name 'grants_event'.
Query: SELECT DATEPART(d,ed.TheDate) AS TheDate FROM grants_event_date ed LEFT JOIN grants_event e ON (e.GrantEventID = ed.GrantEventID) WHERE ed.TheDate >= '2013-05-01' AND ed.TheDate < '06-01-2013' ORDER BY ed.TheDate,ed.StartTimeError: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: SELECT '2013-'+holidayAnnualDate AS annualDate,CONVERT(VARCHAR(10),holidaySpecificDate,120) AS specDate,holidayDescription FROM LibPublic.dbo.holidays
Query: SELECT DATEPART(d,ed.TheDate) AS TheDate FROM grants_event_date ed LEFT JOIN grants_event e ON (e.GrantEventID = ed.GrantEventID) WHERE ed.TheDate >= '2013-05-01' AND ed.TheDate < '06-01-2013' ORDER BY ed.TheDate,ed.StartTimeError: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: SELECT '2013-'+holidayAnnualDate AS annualDate,CONVERT(VARCHAR(10),holidaySpecificDate,120) AS specDate,holidayDescription FROM LibPublic.dbo.holidays
| S | M | T | W | T | F | S | |
|---|---|---|---|---|---|---|---|
| week | 28 |
29 |
30 |
1
|
2
|
3
|
4
|
| week |
5
|
6
|
7
|
8
|
9
|
10
|
11
|
| week |
12
|
13
|
14
|
15
|
16
|
17
|
18
|
| week |
19
|
20
|
21
|
22
|
23
|
24
|
25
|
| week |
26
|
27
|
28
|
29
|
30
|
31
|
1 |
Error: Database 'LibPublic' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Query: USE LibPublic; SELECT granteventdateid FROM grants_event_date ed LEFT JOIN grants_event e ON (e.GrantEventID = ed.GrantEventID) LEFT JOIN grants_sponsor s ON (e.SponsorID=s.SponsorID) LEFT JOIN grants_meeting_type t ON (ed.TypeID=t.TypeID) WHERE 1=1 AND Title <> 'Null' AND ed.TheDate IS NOT NULL AND ed.TheDate >= CONVERT(VARCHAR(10),GETDATE(),101) ORDER BY ed.TheDate,ed.StartTime
Query: USE LibPublic; SELECT granteventdateid FROM grants_event_date ed LEFT JOIN grants_event e ON (e.GrantEventID = ed.GrantEventID) LEFT JOIN grants_sponsor s ON (e.SponsorID=s.SponsorID) LEFT JOIN grants_meeting_type t ON (ed.TypeID=t.TypeID) WHERE 1=1 AND Title <> 'Null' AND ed.TheDate IS NOT NULL AND ed.TheDate >= CONVERT(VARCHAR(10),GETDATE(),101) ORDER BY ed.TheDate,ed.StartTime