Viewing 15 posts - 31 through 45 (of 49 total)
You can use ISNULL to replace NULL with blank - eg
SELECT (LEFT(ISNULL( middlename, '') , 1) )
April 10, 2019 at 1:05 pm
You can add a script task to check if file exists - searching this on internet will give a number of options
April 3, 2019 at 8:44 am
There might be more elegant way of doing but one thing that comes to mind is that you can get a week number the usual way for a week before...
March 29, 2019 at 8:55 am
I think this is what you meant and it does work
select
March 25, 2019 at 7:34 am
The remainingJobtime field is varchar
So you have to convert number into string
Try this
March 13, 2019 at 9:34 am
Couple of things that come to my mind without any knowledge of data in the table - can unit cost be < 0 and can unit cost be null -...
February 20, 2019 at 9:46 am
Another way to debug this can be importing the data from csv file into sql server database manually using data import task in SSMS - then you can query it in...
February 20, 2019 at 8:07 am
Just a thought - Are you sure there are no leading spaces in your date - because that will concatenate the string and give an error
Thanks
January 31, 2019 at 5:17 am
Just looking at the data - if the first 7 digits are always going to be same - you can GROUP BY LEFT(OU , 7) - if that's not the case...
January 23, 2019 at 5:04 am
I have been like this person in my previous jobs but don't want to be so in my current one.
Though a person like this is an asset to the company...
January 21, 2019 at 7:41 am
I encountered script task error a while back - turned out the issue was not with script task at all but the package deployment target version pointing to SQL Server...
November 19, 2018 at 9:14 am
Hi
You can still use the pivot function with 'MAX'
A rough example can be:
November 7, 2018 at 7:21 am
Hi
Since you have added a where clause on the left join - it will behave like a inner join - if you replace this with 'and' you will...
November 6, 2018 at 9:38 am
This can be one way of comparing the min date row in one table to max date row in another table
...
October 11, 2018 at 6:52 am
Just wanted to point out that the @loop increment inside the dynamic SQL will not carry through to @loop increment outside the dynamic SQL
Again it depends how you...
March 23, 2018 at 9:39 am
Viewing 15 posts - 31 through 45 (of 49 total)