If you want...

i had not heard of iReport before your post, i was expecting a SQL related question, of course.

i guess...

ok weird requirement, this won't work if ad Hoc is disabled, obviously.

this works for me on my dev machine, which does allow adhoc:

--DROP PROC pr_Processes

CREATE PROCEDURE pr_Processes

@SERVERNAME varchar(128)

AS

BEGIN --PROC

DECLARE @sql...

justin_post (10/30/2012)

---

On the front end, new students get added regularly. If I used the view I created today, on Friday, it wouldn't contain any new students that had been added...

justin_post (10/30/2012)

---

One more thing, with the data constantly changing, will I need to create a view each day or how would I make sure that the data stays up to...

He means do something like this:

create the view via TSQL, for example:

CREATE VIEW MyView

AS

SELECT

[Student Number],

IRN,

Name,

Gender,

Address,

city,

state,

...

You mean like this?

SELECT *

FROM SomeTable

WHERE SomeColumn LIKE '%' + CHAR(33) + '%'

this is wrong...it's looking for a table that happens to have a dot in it's name:

[Test].[dbo.Table].LastStartUpTime

--should be

[Test].[dbo].[Table].LastStartUpTime

but that would grant execute on...

you can use a neat trick with RAISERROR to get an immediate result inside the loop, if that's what you want/need.

a basic example:

--print error immediately in batch

declare @i int,

...

sounds like a case statement or a union all, but i'm having trouble figuring out where your data is

soemthing like this?

SELECT Servername, ApplicationID, 'Table1' AS Appserver FROM Table1 UNION...

briancampbellmcad (10/29/2012)

---

A little outside my experience... I open cmd and see "Administrator: C:\WINDOWS\system32\cmd.exe" as the header of my command prompt... not sure what and where to type in my...

i don't see index_id = 1 , which would be the clustered index.

I see index_id 0, which means the table is a heap, and all the downsides that entails.

what...

it gets a little outside of a lot of peoples comfort zones, but in .NET you can do a lot things on the client.. .left join/inner join/full join on the...

also, for the prerequisites:

install the AccessDatabaseEngine_x64.exe from microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=13255

make sure you open an Administrative command prompt window, and run it with the c:\Downloads\AccessDatabaseEngine_x64.exe /passive

command line flag;

this will force the...