Viewing 15 posts - 2,941 through 2,955 (of 3,738 total)
PaulB-TheOneAndOnly (5/22/2011)
Diane Davis (5/19/2011)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 23, 2011 at 12:19 pm
harry.sh16 (5/23/2011)
Please post links from where I can download this and whihc version i would need.
What version of DB2 are you using?
I performed several goggle searches the closest that got...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 23, 2011 at 12:11 pm
I believe that if you install the IBM DB2 Client on the machine(s) that you a using SSIS on it installs the driver.
For better, quicker answers on T-SQL questions, click on the following...
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/
May 23, 2011 at 11:55 am
mulle-78 (5/23/2011)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 23, 2011 at 7:43 am
Jeffrey Williams-493691 (5/22/2011)
Welsh Corgi (5/22/2011)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 1:28 pm
I noticed that you have not defined a Primary Key or a Clustered Index.
Why do you need the Surrogate Key ID when you have a Natural Key ClientID?
How do you...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 12:53 pm
Can you rephrase that?;-)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 12:46 pm
prashantcomp90 (5/22/2011)
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 12:31 pm
Lucky9 (5/22/2011)
Create Table Status
( ID int Identity(1,1),
ClientID int,
StatusStartDate Datetime,
Status Int)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-01-28',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-03-20',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-05-30',2)
Insert...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 10:25 am
brian.cook (7/10/2010)
I did not write this DB, however it has fallen to my hands to make it work for Access 2010, and I do not have much experience with VB...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 10:20 am
Tiya (5/21/2011)
I am doing export only for practice..and learning purpose.thanks for the help..is there any query to import?
One of the options mentioned was SSIS.
You could launch BIDS and create a...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 10:02 am
This is a very simple example.
Perhaps you can make it better?
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'usp_return_Client' AND type = 'P')
...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 9:52 am
How are you going to return StatusEndDate when it is not in your table?
I would not use a reserved words when naming an object, i.e. Table and Column name is...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 9:12 am
Lucky9 (5/22/2011)
ID ClientID StatusStartDate Status
1 100 2010-01-28 1
...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 8:39 am
Did you check the NIC Card?
I had this problem before and setting it to Full Duplex fixed the problem.
If you NIC is set to Auto you will have problems with...
For better, quicker answers on T-SQL questions, click on the following...
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/
May 22, 2011 at 8:34 am
Viewing 15 posts - 2,941 through 2,955 (of 3,738 total)