Newbie poster here but long time voyeur!

What are people’s experiences in jumping over versions when upgrading? We are currently looking at going from 2008R2 to 2016 for a...

Cadavre - Thank you for all your help

This is what I have so far, how do I get more than one row of data in the results:

CREATE TABLE #TemplateDictionary(

[TMPL_OBJECT_NAME] [nvarchar](100) NOT NULL,

[FieldName] [nvarchar](100) NOT NULL,

[FieldDataType] [nvarchar](100) NOT...

Cadavre,

I have read both the articles you posted and have attempted to apply this to my solution but with no luck as yet.

So if you could offer some more help...

Thanks Cadavre - that produces exactly the results I asked for, but I guess I maybe simplified my question too much.

The problem I have is that No. of rows is...

This is a bit more accurate set-up.

declare @MeetingRoom table

(

MeetingDate SMALLDATETIME

,RoomNo Varchar(20)

)

INSERT INTO @MeetingRoom

Values

('2011-01-03','Room1'), -- Mon

('2011-01-03','Room1'), -- Mon

('2011-01-04','Room1'), -- Tues

('2011-01-03','Room2'), -- Mon

('2011-01-04','Room2'), -- Tues

('2011-01-05','Room2'), -- Weds

('2011-01-07','Room3'), -- Fri

('2011-01-04','Room4'), -- Tues

('2011-01-05','Room4'), --...

Hi GSquare,

Thanks for your response.

I already have a calendar table as you have suggest. I simplified my problem and left this fact out of the description, which maybe I shouldn't...

again many thanks for everyone's help and also thanks for the pointers on code setup. I'll make sure I do this on all future posts.

Many thanks for all the code

Very helpful thanks

Great article and examples.

How would I get the provideoutput code (see below) to write to a database table rather than printing to screen? I'm using the VB.NET version, but would...