Guys, Funny to see your competitive contribution to my problem. Learned a lot, thanks again!:-)

Hi, this works! Thanks

The only thing that is missing is that the days with no events are not mentioned. Is there a way to display these days with an eventcount...

Thanks, but that was not what I wanted to show. What I want is a table that contains two field.

Date and the number of events that are running on that...

Hello all,

Thanks for your help. The solutions you've provided are super and far beyond my current skill level.

Learned a lot, Thanks again!!!

Mike

Thanks jmcgarvey,

The problem for me is not the comma delimetered insertion. For me the problem is to add multiple records with multiple columns into a table.

Hope that you, or someone...

Hi SSCommitted,

Super...thanks a lot!

Mike

Hi GilaMonster en Celko,

Thanks for your reactions. With help of your tips i've solved my puzzle.

@celko: Thanks again for your lessons in netiquette, still learning......:-)

Mike

Hi Celko,

A lot of critics, but thanks for that! Will try to use your suggestions in my following posts.

Cheers,

Mike

Thanks Imex, This rocks!

I dont think the problem is wildcard certificate related.

I also tried to use a self signed certificate, but this also not works...

same errors

Mike

No unfortunaltly i recieve error code 17182 TDSSNICLient initialization failed with error 0xd, status code 0x38.

Reason: an error occured while obtaining or using the certificate for SSL. Check settings in...

Laurie and Dwain,

Thanks for your help.... case solved!!!

Mike

hi J Livingston,

That article helps me a lot.. Thanks for your suggestion!!

Mike

Hi CELKO,

Thanks for your reply. Your code looks a little bit complex for me so I will studie on it.

Hope i get my project on wheels...

Mike

CREATE TABLE [ParentRegionList](

[RegionID] [int] NOT NULL,

[RegionType] [nvarchar](50) NULL,

[RegionName] [nvarchar](255) NULL,

[ParentRegionID] [int] NULL

)

INSERT INTO [ParentRegionList] ([RegionID],[RegionType],[RegionName],[ParentRegionID]) VALUES (1,'Continent','Europe',0)

INSERT INTO [ParentRegionList] ([RegionID],[RegionType],[RegionName],[ParentRegionID]) VALUES (2,'Continent','North America',0)

INSERT INTO [ParentRegionList] ([RegionID],[RegionType],[RegionName],[ParentRegionID]) VALUES (500,'Country','The Netherlands',1)

INSERT INTO...