Search Results | SQL Server Performance Forums

SQL Server 2000 Reporting Services Installation - Error Code25619

Thread by: jbharani, Aug 19, 2008, 1 replies, in forum: SQL Server Reporting Services

I am installing SQL Server 2000 Reporting Services on MS Windows Server 2003 Standard Edition. I get the error " The installer has encountered an...

Change View column collation

Thread by: jbharani, Mar 7, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

guys, I recently migrated one database from sql 2k to sql 2k5. Now the problem is I have to change the view column collation can anyone help me in...

Convert from mm/dd/yyyy to yyyymmdd

Post by: jbharani, Oct 24, 2007 in forum: SQL Server 2005 General Developer Questions

Thanks for your reply...

Convert from mm/dd/yyyy to yyyymmdd

Post by: jbharani, Oct 24, 2007 in forum: SQL Server 2005 General Developer Questions

I have used your reply Madhivanan....

Convert from mm/dd/yyyy to yyyymmdd

Post by: jbharani, Oct 23, 2007 in forum: SQL Server 2005 General Developer Questions

Hi Guys, I could convert datetime to int ... i used this : convert (char(10),Date,112) O/P: 20030306

Convert from mm/dd/yyyy to yyyymmdd

Post by: jbharani, Oct 23, 2007 in forum: SQL Server 2005 General Developer Questions

its not just for display purpose...

Convert from mm/dd/yyyy to yyyymmdd

Post by: jbharani, Oct 23, 2007 in forum: SQL Server 2005 General Developer Questions

actually Frank i need to convert the datatype from datetime to int... so if i use that i'll get the output in yymmdd format...but i need it in...

Convert from mm/dd/yyyy to yyyymmdd

Post by: jbharani, Oct 23, 2007 in forum: SQL Server 2005 General Developer Questions

SELECT CONVERT(VARCHAR(8),GETDATE(),112) If i use this the output format will be yymmdd ....

Convert from mm/dd/yyyy to yyyymmdd

Post by: jbharani, Oct 23, 2007 in forum: SQL Server 2005 General Developer Questions

I have two tables oldtbl and newtbl.I am trying to populate the newtbl from oldtbl , In Oldtbl i have a column by name Date of type (datetime).... in...

Convert from mm/dd/yyyy to yyyymmdd

Thread by: jbharani, Oct 22, 2007, 19 replies, in forum: SQL Server 2005 General Developer Questions

Hi friends, I have a Date column as MM/DD/YYYY(datetime) i need to convert this to YYYYMMDD(int). Can anyone help me in converting this.... i tried...

Getting an Error when importing data from a flat file to a table

Post by: jbharani, Oct 9, 2007 in forum: SQL Server 2005 General Developer Questions

I am using Enterprise Edition SP2...

Inserting rows from other table...

Post by: jbharani, Oct 9, 2007 in forum: SQL Server 2005 General Developer Questions

The Linked Servers are already setup.....

Getting an Error when importing data from a flat file to a table

Thread by: jbharani, Oct 8, 2007, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi Friends, I am trying to import data from a flat file(.txt) to a table already created on a database... I am getting this error TITLE: SQL Server...

Inserting rows from other table...

Post by: jbharani, Oct 5, 2007 in forum: SQL Server 2005 General Developer Questions

Thanq... I'll try these methods ...

Inserting rows from other table...

Thread by: jbharani, Oct 4, 2007, 7 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I am a newbie to the developer concepts ..... I need help inserting the rows in a table... I have 2 servers Server1 (2005) and Server2...