Forum Replies Created
Viewing 15 posts - 4,231 through 4,245 (of 13,855 total)
-
RE: Update table using inner join
That LEFT JOIN is potentially a problem. For the rows in supplierpack which have no match in Entertainer, are you hoping that supplierbarcode will be set to NULL? Can you try again with...
-
RE: Throttling the CPU / Disk IO for SQL Restore Option
Sridhar-137443 - Thursday, July 19, 2018 9:34 AM -
RE: Keep only the true changes in a massive table
SQL_Surfer - Thursday, July 19, 2018 8:39 AM -
RE: SSIS Catalog / Connection Managers with Expressions
doughora - Thursday, July 19, 2018 8:23 AM -
RE: Throttling the CPU / Disk IO for SQL Restore Option
Sridhar-137443 - Thursday, July 19, 2018 7:51 AMPresumably you have considered...
-
RE: Recursive Trigger - Query
arvind.patil 60171 - Thursday, July 19, 2018 6:25 AM -
RE: Recursive Trigger - Query
arvind.patil 60171 - Thursday, July 19, 2018 5:39 AM -
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:
Viewing 15 posts - 4,231 through 4,245 (of 13,855 total)