Viewing 10 posts - 1 through 10 (of 10 total)
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...
November 10, 2017 at 3:06 am
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...
November 22, 2011 at 5:51 am
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...
November 22, 2011 at 5:35 am
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...
November 22, 2011 at 3:41 am
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'), --...
January 31, 2011 at 1:03 pm
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...
January 31, 2011 at 12:14 pm
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.
May 1, 2010 at 1:31 am
Many thanks for all the code
Very helpful thanks
April 30, 2010 at 2:13 am
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...
April 19, 2010 at 10:25 am
Viewing 10 posts - 1 through 10 (of 10 total)