Viewing 15 posts - 14,101 through 14,115 (of 26,486 total)
Are you trying to query a server in another domain? Is there a trust relationship between the domains?
Linked servers may work, but it depends on the volumn of data...
November 28, 2011 at 9:45 pm
First, this is your code reformatted to make it a bit more readable:
set dateformat 'dmy';
update tbPhoneStatus set
statuscd = '01'
from
(select
...
November 28, 2011 at 9:41 pm
Remi, thank you for taking the time to reformat the code. Yes, it looks like a possible table scan due to the calculations in the CASE clause in the...
November 25, 2011 at 1:17 am
By the paperwork when you purchased SQL Server 2008. It is no longer (since SQL Server 2005) kept in the server. It is now all paper based. ...
November 25, 2011 at 1:07 am
RMiranda (11/24/2011)
/* Order Function Returned Table *
Need to minimaly change a function(GetBigTableData),
so that it returns the same results but ordered.
PS: Working in SQL Server 2005
*/
/*...
November 24, 2011 at 11:18 pm
Dev (11/24/2011)
They may not remember and that is why it should be declared as NOT NULL.
Well, I guess we will have to agree to disagree as I believe...
November 24, 2011 at 12:17 pm
My first question for you is this, have you looked up the DATEADD function in Books Online? If you have, what don't you understand in the query?
November 24, 2011 at 3:54 am
If all updates and inserts are done via stored procedures then the stored procedure can be written to ensure that the created/modified columns are properly updated. If inserts/updates are...
November 24, 2011 at 3:49 am
Just curious why you are limiting yourself to just individuals that have passed this Microsoft certification test. I'm sure there are qualified individuals out there who haven't taken this...
November 24, 2011 at 3:21 am
Is this the Oracle code you are trying to convert?
November 24, 2011 at 3:17 am
Looks to me like you have fulltext indexing setup on this database and it is being used for one of your tables.
November 24, 2011 at 3:11 am
I don't have an answer to your question, but I have a question since you are asking this question in a SQL Server 2008 forum. What is the value...
November 24, 2011 at 2:59 am
Personally, I'd like to see the code formatted so that it is readable as well. From what I can see indexing may not help the query completely. I...
November 24, 2011 at 12:57 am
Too general, doesn't tell me anything. You need to figure out what was running on the system when it experienced the memory problem. How you do thin, I'm...
November 23, 2011 at 4:09 pm
J Livingston SQL (11/23/2011)
does this help you....
SELECT Contract, Client, COUNT(*) AS ContractCountFROM tbl_temp
GROUP BY Contract, Client
HAVING (COUNT(*) > 1)
Actually, I think this is what is needed:
select Contract, count(distinct Client)...
November 23, 2011 at 4:04 pm
Viewing 15 posts - 14,101 through 14,115 (of 26,486 total)