Forum Replies Created
Viewing 15 posts - 2,521 through 2,535 (of 13,879 total)
-
Reply To: SSIS 4 Minute Job Takes Over 19 *Hours* on New Server
Even if different server specs does turn out to be the reason, it seems that you have learned quite a lot of new things during the whole investigative process, which...
-
Reply To: SSIS Expression help
Just tested Chris' solution and it seems to do the job.
-
Reply To: SSIS Expression help
What have you tried so far?
-
Reply To: Is it possible to display Date in between in cube without multiplying the Data?
OK, are these date ranges included in your cube? If so, why are you doing that, rather than allowing the end user to perform the aggregation in a pivot table...
-
Reply To: using Powershell scripts to do SQL backups
I'll leave that one for the DBAs here. Counter Strike is a good call, that will do it!
-
Reply To: using Powershell scripts to do SQL backups
Also any other backup ideas anyone can throw out for me to try and increase backup times?
I'm sure that there are lots of ways to do that (eg, play Unreal...
-
Reply To: Select Statement Where Column Does Not Exist
Some of your SQL syntax can be refined a little (not that there was anything wrong with yours):
DROP TABLE IF EXISTS #Test2;
CREATE TABLE #Test2
(
... -
Reply To: Select Statement Where Column Does Not Exist
dallastexas wrote:I have one idea I haven't tried yet (think it will work):
(1) import data into temp file
(2) use alter database to add the missing fields if they do not...
-
Reply To: Best way to replicate 1 table from Production DB to Dev Db
As it's a log table, would I be right in thinking that the only items to be replicated would be new INSERTs? Or are there UPDATEs and DELETEs to contend...
-
Reply To: Access Files Stored in Box.com
Brian, that's a very helpful link, thank you!
Interesting technique too ... I never knew that there was any way round using non-native assemblies in SSIS, other than installing them in...
-
Reply To: Is it possible to display Date in between in cube without multiplying the Data?
How is DiscountMeasure calculated?
-
Reply To: SQL Query Help - CHARINDEX
Jason's solution should run faster, as long as there is never more than a single / in the t1 values.
-
Reply To: SQL Query Help - CHARINDEX
SQL Server wrote:I am sorry. I should have been more clear. Actually I would like to DELETE the records which are NOT matching.
Just need to switch things round a bit:
Reply To: SQL Query Help - CHARINDEX
Try this:
SELECT t1.*
FROM #Test1 t1
CROSS APPLY STRING_SPLIT(t1.SName, '/') ss
JOIN #Test2 t2
ON...
Reply To: how to replace uncounted multiple commas into one comma
Infallible, unless the original text contains some combinations of angled brackets, in which case alternative 'dummy characters' may be employed, for example:
SELECT t.SomeString
...
Viewing 15 posts - 2,521 through 2,535 (of 13,879 total)