Viewing 15 posts - 196 through 210 (of 3,544 total)
Not a problem. Happy to help. Hopefully we hear from a few others as well. There is some degree of disagreement on this topic.
Not from me 🙂
Far away is close at hand in the images of elsewhere.
Anon.
May 15, 2019 at 1:04 pm
What do you mean by :-
with out the need for using any parameters?
current month?
what other field do you have to signify what month the data belongs to?
Far away is close at hand in the images of elsewhere.
Anon.
May 15, 2019 at 12:57 pm
Totally agree with the XP_CmdShell thing. Of course, if you do that, you don't need PowerShell to begin with. Just create the file deletion commands directly from...
Far away is close at hand in the images of elsewhere.
Anon.
May 9, 2019 at 7:42 am
Totally agree with the XP_CmdShell thing. Of course, if you do that, you don't need PowerShell to begin with. Just create the file deletion commands directly from MSDB backup...
Far away is close at hand in the images of elsewhere.
Anon.
May 8, 2019 at 1:56 pm
how would you call that from a stored procedure
XP_CMDSHELL
or SQL Server job
SQL Agent has Powershell type
🙂
Far away is close at hand in the images of elsewhere.
Anon.
May 8, 2019 at 7:47 am
If your data, as you are implying, will have more than 4 columns then I would reshape the data thus, obviously extending it to cover all the columns
...
Far away is close at hand in the images of elsewhere.
Anon.
May 1, 2019 at 2:07 pm
If your data, as you are implying, will have more than 4 columns then I would reshape the data thus, obviously extending it to cover all the columns
Far away is close at hand in the images of elsewhere.
Anon.
May 1, 2019 at 12:42 pm
Here is a quick example 😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @TSTR VARCHAR(50) = '.....SSMS.....';
SELECT
STUFF(@TSTR,1,PATINDEX('%[^\.]%',@TSTR) - 1,'') AS TRIM_LEFT
,LEFT(@TSTR,(1 +...
Far away is close at hand in the images of elsewhere.
Anon.
April 23, 2019 at 12:15 pm
If you are talking about a contiguous leading non space character then a combination of PATINDEX and STUFF should work.
For trailing use REVERSE, PATINDEX and LEFT.
Far away is close at hand in the images of elsewhere.
Anon.
April 23, 2019 at 8:11 am
The words that strike me here is ...
I have a good job, but have been offered one from a company i once worked for
The first step is to sit...
Far away is close at hand in the images of elsewhere.
Anon.
April 15, 2019 at 7:57 am
SELECT[Name],EmployeNo,[Date],[Value],Attendence,
CASE WHEN PreviousAttendence = 1
AND Attendence = 1
AND DATEDIFF(day,PreviousDate,[Date]) = 1
THEN CAST(PreviousDate as varchar(20)) + ' - ' + CAST([Date] as varchar(20))
END AS [Calculate Hr's difference]
FROM(
SELECTe.[Name],e.EmployeNo,e.[Date],e.[Value],e.Attendence,
LAG(Attendence,1,0) OVER...
Far away is close at hand in the images of elsewhere.
Anon.
April 2, 2019 at 1:33 pm
As for not using MERGE, it was awful in SQL Server 2008. Since then, it has got better; but there are still some concerns on things. Pretty sure Aaron...
Far away is close at hand in the images of elsewhere.
Anon.
April 1, 2019 at 2:45 pm
I don't think you can because only the inserted table is in scope for INSERT.
Why do you not use MERGE?
Far away is close at hand in the images of elsewhere.
Anon.
April 1, 2019 at 12:33 pm
Sorry missed the Sum
=(Sum(Fields!Booking_Count.Value)/ReportItems!Textbox1.Value)*100
*Edited my original post as well
Far away is close at hand in the images of elsewhere.
Anon.
March 29, 2019 at 8:18 am
SELECT *, M1+M2, M3+M4, 25 M1Cijena, 25 M2Cijena, 16 M3Cijena, 16 M4Cijena
FROM ...
Far away is close at hand in the images of elsewhere.
Anon.
March 29, 2019 at 7:34 am
Viewing 15 posts - 196 through 210 (of 3,544 total)