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...

lots of things wrong here, let me point out a few, and then a script on how to create a linked server.

1. you cannot create objects in the sys. schema

2....

i played with something similar, where i was converting from xml/html entities to the unicode? character char definition.

the problem was i was using a recursive function, and the #of recursion...

the issue is not with your data.

it's with the query you are using...

the error is in the query you are creating, which you did not post.

it looks like you are concatenating a number to a string . like CustomerID + ' '...