Viewing 15 posts - 4,846 through 4,860 (of 13,877 total)
A method of importing csv files into a SQL table where the file layouts...
December 7, 2017 at 7:33 am
December 7, 2017 at 7:10 am
Thank You for your reply, It will solve this issue that I am having. However,...
December 7, 2017 at 5:50 am
Nicely done, but there are couple of drawbacks
1. The function doesn't handle the non-alpha characters in...
December 7, 2017 at 5:41 am
I thought I did... just tried on the server with 2016 instance installed (only version...
December 6, 2017 at 1:56 pm
So I am trying to set up SQL Server 2016, to migrate off 2008R2. SSIS...
December 6, 2017 at 1:42 pm
Hi Guys,
Here is the one Data from my source is erroring out.
"E:60 Pic: 20...
December 6, 2017 at 1:07 pm
Use DBCC OPENTRAN to look for open transactions.
December 6, 2017 at 10:46 am
And here's that query again, for those with standard-width screens 🙂SELECT
(
SELECT ISNULL(SUM(TOTAL_PAYMENTS), 0)
FROM Orders
WHERE
ST_ID IN (
December 5, 2017 at 12:51 pm
Not sure about the error, but this task may work better using xp_Dirtree. Here is an example:
DROP TABLE IF EXISTS #Results
CREATE TABLE #Results
(
December 5, 2017 at 12:49 pm
December 5, 2017 at 8:24 am
December 4, 2017 at 10:21 am
Can you paste the code from your script task?
December 4, 2017 at 9:54 am
Viewing 15 posts - 4,846 through 4,860 (of 13,877 total)