SQL SERVER – Function to Convert List to Table « SQL Server Journey with SQL Authority

Feeds:: Posts; Comments

« SQL SERVER – Primary Key Constraints and Unique Key Constraints

SQL SERVER – FIX : Error 15023: User already exists in current database. »

SQL SERVER – Function to Convert List to Table

February 10, 2007 by pinaldave

Update : (5/5/2007)
I have updated the UDF to support SQL SERVER 2005.
Visit :SQL SERVER – UDF – Function to Convert List to Table

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology | 9 Comments

9 Responses

on December 17, 2007 at 12:59 pm | Reply Arun

whether there is any way to find the Creating Date of the Table in SQL 2005
- on February 15, 2010 at 6:32 pm | Reply Madhivanan
  
  EXEC sp_help ‘your_table’
  
  or
  
  select create_date from sys.objects where name=’your_table’
on April 12, 2008 at 2:09 pm | Reply Dhanu Sahu

I am new sqlserver i tried every query suggest by you but i cant remove my duplicate row likes Date,Day

1 2 12-Apr-2008 9:00 AM 11:00 PM Saturday 14 4/12/2008 3:17:11 AM 04 Saturday 2008
2 2 12-Apr-2008 7:00 AM 11:00 PM Saturday 16 4/12/2008 3:19:27 AM 04 Saturday 2008
3 2 11-Apr-2008 9:00 AM 10:00 PM Friday 13 4/11/2008 3:24:32 AM 04 Friday 2008
7 2 11-Apr-2008 8:00 AM 10:00 PM Friday 14 4/11/2008 3:28:18 AM 04 Friday 2008
8 2 11-Apr-2008 5:00 AM 10:00 PM Friday 17 4/11/2008 3:29:20 AM 04 Friday 2008
9 2 11-Apr-2008 10:30AM 11:30PM FriDay 12 fbggfb 4/12/2008 3:17:11 AM dfbdfbdfb 04 FriDay 2008
on June 18, 2008 at 4:54 pm | Reply anurag kulshrestha

i have some problem ,

i want to create a table name country (country list) and want to insert country name (500 country name )
it is to difficult for me apply
this “insert into country (country_name) (‘ INDIA’)”
single name again an again

so i want to know how will i insert large amount of data in single entity as in country _name

With Regard
Anurag Kulshrestha
- on February 15, 2010 at 6:34 pm | Reply Madhivanan
  
  Have data in a text file and import them using BULK INSERT command
on June 20, 2008 at 3:50 pm | Reply Charanpreet Singh

hello anurag kulshrestha,Solution for U

set nocount on;
declare @values nvarchar(4000);
set @values=’India|Pakistan|Iran|USA|Australia|Greek|German|turkey|New Zealand|China|Brazil’
declare @Del char(1);
set @Del=’|';
set @values=@values+@Del;
declare @value nvarchar(100);
WHILE charindex(@Del,@values,0) 0
BEGIN
select @value=rtrim(ltrim(substring(@values,1,charindex(@Del,@values,0)-1))),@values=rtrim (ltrim(substring(@values,charindex(@Del,@values,0)+1,len(@values))))
if not exists(select @value from daybook where Title=@value)
begin
Insert into DayBook(Title) values(@value)
end
END
on July 14, 2008 at 5:30 pm | Reply Ganesh

Hi ,pinal

I just want to know the query which we can use to list all available servers in mssql 2000/2005.

Regards..
Ganesh
- on February 15, 2010 at 6:37 pm | Reply Madhivanan
  
  select * from sys.servers
on September 26, 2010 at 10:59 pm | Reply Koteswarrao

Hi,

How to post the queries ?

Thanks
Koteswarrao