This logic would require some kind of looping to work. You also need a where clause in your update. Probably use a subselect for your incrementing? ...

We really need to query to attempt help. It is likely a bad join causing a table scan....nothing a rewrite of the query or an index can't fix.....let's see...

Give this self join method a try..I apologize for any syntax errors ahead of time...I don't have access to my sql server at the moment to test with....

select datediff(day, a.statusbegindate,...

Are you using sql reporting services for this? If so, use an expression to truncate the field on normal display and then create a toggle to show the remainder....Need...

I'd also try using coalesce instead of isnull. I've seen some posts about performance being better with coalesce.

Select e_ina11,E_Create_Date,e_Org_FileName From Element

Where coalesce(e_Ina11,1) = 1

AND E_Create_Date >...

You can also try running the command

SET ANSI_NULLS OFF

at the beginning of your query. See http://msdn.microsoft.com/en-us/library/ms188048.aspx for more details....

this query will help:

--http://www.sqlservercentral.com/articles/DMV/64425/

use master

SELECT [Spid] = session_Id

, ecid

, [Database] = DB_NAME(sp.dbid)

, [User] = nt_username

, [Status] = er.status

, [Wait] = wait_type

, [Individual Query] = SUBSTRING (qt.text,

...

Sure it can be done. With more details about the problems you are trying to solve we can give you some better advice. Moving the reporting services install...

By default, xp_cmdshell runs against the operating system as the user that the sql server service runs under. This may or may not be an active directory account. ...

You are the man....Rock on!

One more:

http://msdn.microsoft.com/en-us/library/aa337424(SQL.90).aspx

It can. One of my customers has a reporting services box with a data warehouse on it. We have two other databases on seperate servers that I access...

http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx

EXEC master..xp_cmdshell 'dir /od'

Do you want to do this from within SQL server...if so, you have options...xp_cmdshell, the undocumented stored procedure master.sys.xp_dirtree (http://www.mssqltips.com/tip.asp?tip=1460), or powershell. I'm currently using xp_cmdshell for...

This will depend on your version of Great Plains. My experience is that database migrations are normally coupled with version upgrades in Great Plains. Best advice is for...