Viewing 15 posts - 856 through 870 (of 1,478 total)
There is no such thing as array in SQL. The closest thing can be a temporary table or a table variable.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2009 at 9:09 am
ODBC is not a database. ODBC is a standard for database access. There is an ODBC driver that can be used to any database that supports this standard...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2009 at 8:08 am
Try to modify your code like this:
Declare @Report_Date VARCHAR(11);
SET @Report_Date = CONVERT(varchar,GETDATE()-1,101);
INSERT INTO table2 (Report_Date,CR_GP,Cr_Grp_TTCount)
SELECT Top(10) @Report_Date, CR_GP, COUNT(DISTINCT TID) AS TTCount
FROM table1.dbo.db1
WHERE (CONVERT(nvarchar, DATEADD(s, CREATE_DATE, CONVERT(DATETIME, '1970-01-01 00:00:00',...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2009 at 7:58 am
You have to understand that the more details that you write, the more chances are that someone will be able to help you. Currently all we know is...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2009 at 7:44 am
This is just to add a bit on Chraig’s answer. Using dynamic SQL has its own price in terms of security and query plan usage. I strongly advice...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2009 at 7:28 am
How do you pull the data? Where are you pulling it from? What is the data type of the original source?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2009 at 7:10 am
You can define scheduled tasks in SQL Server. I suggest that you’ll look for reading material about Jobs and SQL Server agent in order to learn how to schedule...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 9:00 am
I didn’t try it, so I can’t tell you for sure that it works, but if I had to come up with a solution for it, I would have try...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 7:59 am
It looks like there is a DDL trigger on create login statement. The trigger produces the runtime error and preventing you from adding a new login. Check the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 7:54 am
I’m sorry, but I do think that this is not logical to expect that the server will get all formats of dates and interpret all of them correctly. I...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 7:31 am
I don’t know if you know it or not, but when you rebuilding an index takes it offline while it is being rebuild. If it is a cluster index,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 6:09 am
While I agree with Jack that you shouldn’t use the option of auto_close for the databases, I don’t think that this is the cause of your problems. When user...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 2:56 am
If you mean for difference between
Select WhatEver from MyTable where ID in (1,2,3)
And
Select WhatEver from MyTable where ID = 1 OR ID=2 OR ID=3
Then both will produce the same...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 2:19 am
Nice demo. Defiantly proves the point. I have to admit that it did surprise me, but every day I learn something(s) new
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 10, 2009 at 8:22 am
Lowell (8/10/2009)
Note, the length of the data type should...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 10, 2009 at 7:46 am
Viewing 15 posts - 856 through 870 (of 1,478 total)