Forum Replies Created
Viewing 15 posts - 2,401 through 2,415 (of 13,852 total)
-
Reply To: How to get RowCount and ResultSet from CTE
Mr. Brian Gale wrote:if I understand right, you want to do an insert into 2 different temp tables from a CTE in a single query? If so, I don't think that is...
-
Reply To: Joining a table based on date range - Case Statement?
Try this:
DROP TABLE IF EXISTS #Sales;
DROP TABLE IF EXISTS #FiscalPeriods;
CREATE TABLE #Sales
(
SOPTYPE SMALLINT NOT NULL
,SOPNUMBE CHAR(21) NOT NULL
... -
Reply To: Color Coding data based on values
SQL Server wrote:I tried =IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black") and it is not working. Could it be because we have some NULL values?
What does "not working" mean?
- Results in an error? (If so,...
-
Reply To: Reorder rank upon condition
Matrix_you wrote:I was hoping for a quick resolution. But i guess tou ar right i need to develop an algo.
Thanks for all the help
Cheers
Had you been able/prepared to accurately describe...
-
Reply To: Reorder rank upon condition
I am going to let someone else try to help you. I do not understand.
-
Reply To: Reorder rank upon condition
Matrix_you wrote:I already tried something similar. But, it does not work.
Cheers
Not very helpful.
It provides the output you requested, so what's the problem?
-
Reply To: Embedded SQL script in deployed package
I found one thing, the packages from colleague A (the ones working) have the scripts as "directinput" whereas the packages from colleague B (the ones throwing error path not found)...
-
Reply To: Reorder rank upon condition
This provides the desired results (I think), but I'm not convinced it's the best solution.
DROP TABLE IF EXISTS #Custom;
CREATE TABLE #Custom
(
Noseqtrt SMALLINT NULL
... -
Reply To: Reorder rank upon condition
Taking the case where NoSeqTrt = 4, would it be correct to say that there are eight students at that stop, including two sets of siblings?
And your desired ranking logic...
-
Reply To: Reorder rank upon condition
What does the Number Address column represent, exactly?
-
Reply To: Parallel Inserts using Table Lock
What is your question?
-
Reply To: Parse Semi colon data in seperate columns
Instead of
TRIM(x)
Use
LTRIM(RTRIM(x))
-
Reply To: Parse Semi colon data in seperate columns
pietlinden wrote:This worked:
SELECT t.*
, ca.value
FROM #tblTest t
CROSS APPLY STRING_SPLIT(t.FileData, ';') ca
WHERE LEN(TRIM(ca.Value))>0;Really?
-
Reply To: Parse Semi colon data in seperate columns
Parsename() works only on strings which have . (full-stop) as their delimiter.
If there are only ever two columns, here is one way:
DROP TABLE IF EXISTS #Test;
CREATE TABLE... -
Reply To: how to pass datetime variable from Execute SQL task to the execute process task
Sergiy wrote:You need to declare those variables in sp_executesql as OUTPUT parameters
And map them to package variables, to use them in subsequent tasks.
Viewing 15 posts - 2,401 through 2,415 (of 13,852 total)