Viewing 15 posts - 196 through 210 (of 3,543 total)
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?
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...
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...
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
🙂
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
...
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
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 +...
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.
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...
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...
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...
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?
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
March 29, 2019 at 8:18 am
SELECT *, M1+M2, M3+M4, 25 M1Cijena, 25 M2Cijena, 16 M3Cijena, 16 M4Cijena
FROM ...
March 29, 2019 at 7:34 am
Think you want something like this=(Sum(Fields!Booking_Count.Value)/ReportItems!Textbox1.Value)*100
Replace Textbox1 with the actual name of the Total Count textbox
March 29, 2019 at 7:15 am
Viewing 15 posts - 196 through 210 (of 3,543 total)