Viewing 15 posts - 1,471 through 1,485 (of 3,500 total)
Go crazy. Post your code in here...
PROCEDURE [dbo].[USP_AUTO_MOVE_TBMESSAGEREDUCE_DONE_AND_REJECT_TO_SENT]
@TopRecord INT = 50000
, @ManagementID TINYINT
, @ResText VARCHAR(MAX) OUTPUT
AS
DECLARE
@NEWLINE CHAR(1)
,@SubLoop_Rows...
July 19, 2017 at 9:48 pm
Why are the month numbers in quotes? They're numbers, not text.
July 19, 2017 at 4:03 pm
You would need to update those, removing the proper number of characters (Use LEFT() and LEN() in an update query... Since you only have a few cases, you could write...
July 19, 2017 at 12:25 am
Lowell posted some code that output a dataset as an HTML table not too long ago. Look around for it.
July 18, 2017 at 11:56 pm
Go to Dice or any tech-oriented job site and look for jobs... and see what you find.
July 16, 2017 at 8:15 am
Oh, cool! I knew there had to be a less messy way of doing it! Thanks!
July 14, 2017 at 8:51 pm
Looks like you missed the CREATE TABLE part of this script...
July 12, 2017 at 7:52 pm
Any chance you could post some CREATE TABLE and INSERT scripts so we can all play with the same data?
July 12, 2017 at 3:57 pm
Please explain what records you want from Table B. An outer join returns nulls from Table B if there are no records that match those in A.
Compare
SELECT a.Field1,...
July 12, 2017 at 3:05 pm
Only way I can think of getting this to work would be to add a running total in your query.... if that's not an option, then this could get ugly.
July 12, 2017 at 11:38 am
What are you going to use this for? I'm asking because in SSRS, this is really simple. You would add a tablix to your report surface, and just group by...
July 12, 2017 at 9:18 am
You don't have PowerShell? Why not download it?
July 11, 2017 at 10:49 pm
What if you did it using PowerPivot and DAX. There are functions for that. CLOSINGBALANCE stuff, etc. Is that an option? What did you intend to do with the data....
July 10, 2017 at 2:31 pm
Sort of an apples vs oranges comparison. They're used for different purposes. What's your end goal?
July 10, 2017 at 1:24 am
Viewing 15 posts - 1,471 through 1,485 (of 3,500 total)