...Till now, I haven't found an easy way to get all in the pane, but there is a work-around, that needs to split the text in multiple columns, i.e.

DECLARE @LongText...

The query is reducing 2 days for a week from total days. Since, Saturday is a business day for you, it should be reduced by just 1 day. i.e.

DECLARE...

varchar(max), nvarchar(max), varbinary(max), text, image are large value data types. They can store upto 2^31-1 bytes of data (i.e. 2,147,483,647 characters) and with the unicode version you can store...

How about this one?

SELECTLoginOwner, DATEADD( DAY, 0, DATEDIFF( DAY, 0, LoginDateTime ) ) AS LogDate,

MIN( LoginDateTime ) AS MinTime,

MAX( LogoutDateTime ) AS MaxTime

FROMSomeTable

GROUP BY LoginOwner, DATEADD( DAY, 0, DATEDIFF(...

Well, the "SomeAccessServer" is just a name to the linked server, and by which you will accessing the tables in your access db.

Have you replaced the login "sa" in the...

sysdtspackagelog table in msdb database

Well, you can have a computed column or you can do the computing in the query itself.

CREATE TABLE #SomeTable

(

TableID INT NOT NULL IDENTITY(1,1) PRIMARY KEY CLUSTERED,

Active CHAR(1) NOT NULL,

ModifiedDateTime DATETIME...

Another RUNNING TOTAL problem.., See these articles on how to achieve this...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

http://www.sqlteam.com/article/calculating-running-totals

First of all, what are you trying to do?

You used double quotes instead of single quotes, you have not added the select query in CTE, you wanted to...

Ok..., the below query is tested and it works...

SELECTi.Name, ISNULL(s.Date, k.Date), s.stat1, s.stat2, s.stat3, k.kpi1, k.kpi2, k.kpi3

FROM#items i

LEFT JOIN #Stats s

FULL JOIN #KPIs k ON k.ItemID = s.ItemID AND...

Will the below query is supported by your query builder? If not, can you tell us what queries are supported, 'cause I am out of ideas?:D

SELECTi.Name, s.stat1, s.stat2, s.stat3,...

IS_MEMBER function checks whether the current user is a member of the specified windows or sql database role. And to check specifically for object level permissions, see PERMISSIONS function.

I don't see any syntax errors in the query. And from where are you creating the view? Is it from Enterprise Manager or QA? If you are using...

What errors are you getting when accessing the server from the client?

Can you connect to the server from the server itself?

...I was actually correcting my statement in a new reply but you beat me on it:D.

Now for...