Forum Replies Created
Viewing 15 posts - 4,261 through 4,275 (of 13,877 total)
-
RE: LEFT JOIN with CASE subquery ?
Lynn Pettis - Wednesday, July 18, 2018 1:51 PM -
RE: LEFT JOIN with CASE subquery ?
Please elaborate a little: in the case where INS4.Modifier <> '26', what do you want to happen?
Perhaps you are looking for this?left join
INS4 on Proc_CD_Urology.urology... -
RE: SSIS Expression in the Derived Column Transformation Editor
Something like this:
right("0" + TOKEN( @[User::TextDate] , "/",1 ),2) + "/" + right("0"+TOKEN( @[User::TextDate] , "/",2 ),2) + "/" + TOKEN( @[User::TextDate] , "/",3 ) -
RE: Converting Excel Formula into TSQL
Ronnie Rahman - Wednesday, July 18, 2018 10:40 AM -
RE: how to concert nvarchart to int in case statement
In case it helps others, here is a formatted version of the original code:
SELECT DISTINCT
Num = T0.TransId
, T0.Ref1
, T0.RefDate
, ... -
RE: Loading more than 1 billion records from CSV File
learningsqlkid - Tuesday, July 17, 2018 5:47 PM -
RE: recover the number of files processed by a Foreach loop
Not quite right. See this:
-
RE: Possible to Run SQL Task and Data Task Flow in Parallel
quinn.jay - Monday, July 16, 2018 9:40 AM -
RE: recover the number of files processed by a Foreach loop
joujousagem2006 1602 - Monday, July 16, 2018 2:21 AM -
RE: Validate whether at least 1 record per user is marked as primary
Darrell Woodard - Friday, July 13, 2018 2:16 PM -
RE: Importing XML Files into a flat table
Luke L - Friday, July 13, 2018 12:28 PMRE: Jobs vs jobs with steps
.. maybe something is carry within the job
Please explain what you mean by this.
RE: Importing XML Files into a flat table
Luke L - Friday, July 13, 2018 12:08 PMRE: Sql geo-spatial linked server query
OPENQUERY takes only a single 'query' parameter, with a maximum length of 8,000, so splitting up the input as you are doing is not going to work (because you are...
Viewing 15 posts - 4,261 through 4,275 (of 13,877 total)
