Viewing 15 posts - 3,556 through 3,570 (of 5,109 total)
sgmunson - Monday, July 10, 2017 7:47 AMCONVERT the date field to varchar() for display purposes as part of the query.
At this...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 10, 2017 at 8:10 am
Thanks for your reply.
I created the table, but I do not see it anywhere? Can...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 10, 2017 at 7:28 am
Have to agree with Steve here. If you had 1 or 2 values coming back, then OUTPUT parameters would be fine, but you have 18 variables there. A resultset is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 10, 2017 at 6:01 am
Brandie Tarvin - Friday, July 7, 2017 9:03 AMIf the answer is '42', what is the question?
42 + 0? 🙂
This also...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 9:06 am
At first I thought the same thing, Phil. Then i read it again and, unless I'm mistaken, the OP is actually setting the value of a date to a variable,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 8:42 am
I'm not sure I completely understand what your requirement is here, what do you mean my the value obtained by a parameter? Does your SP have a OUTPUT value that...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 8:03 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 7:15 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 6:51 am
As Beatrix said. The best thing to do is as soon as you switch the database recovery mode is take a backup, if you're able to. Otherwise, any transaction log...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 6:45 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 6:38 am
Also, 26/08/2014 5:23 is not 2 hours ahead of 26-08-2014 15:23, it's 10 hours before. 26/08/2014 5:23 = 26/08/2014 05:23 = 26/08/2014 5:23am.
Are all the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 6:28 am
Have to agree with Phil here, how does 1409030583 become 2014-08-26 05:23:00.000? I can't see any correlated numbers in these two values, apart from that (possibly) the 14 at the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 6:15 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 3:27 am
The error is giving the game away here, you haven'tt supplied enough columns. Your table @BaseTable has 11 columns, however, your OUTPUT INTO only has 8. You need to supply...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 2:39 am
Like this:DECLARE @SearchValue varchar(20), @OutputParam int;
SET @SearchValue = 'Your Value';
EXEC dbo.YourSP @Param1 = @SearchValue , @Param2 = @OutputParam OUTPUT;
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 7, 2017 at 1:19 am
Viewing 15 posts - 3,556 through 3,570 (of 5,109 total)