Viewing 15 posts - 1 through 15 (of 19 total)
I had to add two extra ticks at the end:
ROM DISK = '''
* @backupPath + @backupFile + ''' WITH STANDBY = N''D:\TelcorLogDump\ROLLBACK_UNDO_Telcor.BAK'''
June 3, 2022 at 1:56 pm
I figured out why the exec @cmd wasn't working. I was filtering out the files before it got to the cursor. Now I have one last problem. I am getting...
June 3, 2022 at 1:53 pm
I should still be able to restore each log in standby mode. I changed the exec @cmd to a select @cmd and I got no results. Something is going wrong...
June 3, 2022 at 1:35 pm
Here is the answer I came up with. It's works for me. Thanks 🙂
select
*,
LTRIM(RTRIM(REPLACE(REPLACE(IIF(LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client Called], CHARINDEX('on',[Time Client Called]), 15),13))) is null, null, LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client Called], CHARINDEX('on',[Time Client Called]), 15),13)))),...
March 3, 2022 at 9:26 pm
0
I got this working. Thank you all for your assistance.
select
*,
LTRIM(RTRIM(REPLACE(REPLACE(IIF(LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client
Called], CHARINDEX('on',[Time Client Called]), 15),13))) is null, null,
LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client Called], CHARINDEX('on',[Time
Client Called]), 15),13)))), 'a', ''),'t',''))) as "Date Client Called",
IIF(LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client...
March 3, 2022 at 9:08 pm
Thank you for your feedback, and I'm so happy there are people like you out helping those of us that just don't get it... I tried your code. I posted...
March 3, 2022 at 6:56 pm
I'm sorry, I had to step away and was not able to respond to my post. I apologize for that.
The date could be 2/1/2022 or 12/1/2022
The time could be 3:27...
March 2, 2022 at 8:20 pm
I got really whacky results using this: patindex('%[0-9]%/[0123][0-9]/[2][012][0-9][0-9]%'
February 28, 2022 at 8:39 pm
The case statement in this SQL statement is not returning the correct results. It is returning all 1's.
Can someone point me in the direction where I am going wrong with...
February 26, 2022 at 3:44 pm
I apologize for posting twice. I didn't know there was a reporting services forum. Thank you!
February 26, 2022 at 3:30 pm
Thank you! I'll give it a try and let you know how it worked for me. Looks like it should work fine.
February 25, 2022 at 11:01 pm
Thank you! This worked great!
February 25, 2022 at 10:03 pm
Moving the fetch next statement fixed my issue.
Thank you!
February 16, 2022 at 9:37 pm
Thank you for your reply. I'm sorry for being such a beginner. Can you give me an example of how I would use SET to acomplish what I am trying...
February 16, 2022 at 6:59 pm
Viewing 15 posts - 1 through 15 (of 19 total)