Mr.IncrediblyBored
Lifer
Uh, so did I. Did you even read my first comment? And I quote: *ahem*
-
We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.
SQL Question...
Page 2 - Seeking answers? Join the AnandTech community: where nearly half-a-million members share solutions and discuss the latest tech.
Mr.IncrediblyBored
Lifer
When I find out what pundit means, you're gonna be in sooo much trouble. 😀
Mr.IncrediblyBored
Lifer
Spooner, can you post the DDL to both tables (source and destination tables)?
Descartes, I'm hardly a pundit of any language. The app my company makes works in Oracle, SQL Server, and Sybase Server Anywhere, and any database specific SQL needs to be converted into all formats, so I have spent some time in TSQL - though I do my development work in Oracle.
You seem to have a good grasp of the low level workings of TSQL databases. Much more so than I (in Oracle)... 😱
Descartes, I'm hardly a pundit of any language. The app my company makes works in Oracle, SQL Server, and Sybase Server Anywhere, and any database specific SQL needs to be converted into all formats, so I have spent some time in TSQL - though I do my development work in Oracle.
You seem to have a good grasp of the low level workings of TSQL databases. Much more so than I (in Oracle)... 😱
I'll tell you how I've done something like this in TSQL. Don't laugh for TSQL lacks the more lucid facilities of PL/SQL. When .NET is native w/ SQL Server.NET, that won't be the case 😉
Sometimes, when integrating w/ other platforms, I need to pad date fields. So, I *could* do something like...
case len(cast(month(somedatefield) as char(2))
when 1 then '0' + cast(month(somedatefield) as char(2))
else cast(month(somedatefield) as char(2))
end
That's just to give you an idea of a possibility. Obviously that many casts isn't good, so you'd want to declare a single variable for it, etc.
I know there has to be a more efficient way to do that in PL/SQL? In TSQL, we also have an extended sproc called xp_sprintf, that wraps C/C++'s sprintf that would do this beautifully. I'm sure there's a PL/SQL equivalent?
Sometimes, when integrating w/ other platforms, I need to pad date fields. So, I *could* do something like...
case len(cast(month(somedatefield) as char(2))
when 1 then '0' + cast(month(somedatefield) as char(2))
else cast(month(somedatefield) as char(2))
end
That's just to give you an idea of a possibility. Obviously that many casts isn't good, so you'd want to declare a single variable for it, etc.
I know there has to be a more efficient way to do that in PL/SQL? In TSQL, we also have an extended sproc called xp_sprintf, that wraps C/C++'s sprintf that would do this beautifully. I'm sure there's a PL/SQL equivalent?
I'll tell you how I've done something like this in TSQL. Don't laugh for TSQL lacks the more lucid facilities of PL/SQL. When .NET is native w/ SQL Server.NET, that won't be the case 😉
Sometimes, when integrating w/ other platforms, I need to pad date fields. So, I *could* do something like...
case len(cast(month(somedatefield) as char(2))
when 1 then '0' + cast(month(somedatefield) as char(2))
else cast(month(somedatefield) as char(2))
end
That's just to give you an idea of a possibility. Obviously that many casts isn't good, so you'd want to declare a single variable for it, etc.
I know there has to be a more efficient way to do that in PL/SQL? In TSQL, we also have an extended sproc called xp_sprintf, that wraps C/C++'s sprintf that would do this beautifully. I'm sure there's a PL/SQL equivalent?
Sometimes, when integrating w/ other platforms, I need to pad date fields. So, I *could* do something like...
case len(cast(month(somedatefield) as char(2))
when 1 then '0' + cast(month(somedatefield) as char(2))
else cast(month(somedatefield) as char(2))
end
That's just to give you an idea of a possibility. Obviously that many casts isn't good, so you'd want to declare a single variable for it, etc.
I know there has to be a more efficient way to do that in PL/SQL? In TSQL, we also have an extended sproc called xp_sprintf, that wraps C/C++'s sprintf that would do this beautifully. I'm sure there's a PL/SQL equivalent?
Mr.IncrediblyBored
Lifer
DDL my friend! Post the DDL to the tables in question! I wanna get a better idea of how these tables are defined.
Mr.IncrediblyBored
Lifer
Oops, double post.
Mr.IncrediblyBored
Lifer
Lucid facilities? PL/SQL for any pre-Oracle9 platform doesn't even support CASE statements. The only comparable equivalent would be DECODE(variable, if constant1, then return X, if constant2, then return Y, else return Z). :frown:
edit: fixed formatting.
Mr.IncrediblyBored
Lifer
Wait, subforms? Are you looking at the data through some form? Is it possible the form is formatting the output incorrectly? It's possible the actual data in the table is fine.
Please find out how these tables/columns are defined. Post the DDL. Post the DDL. Post the DDL.
here's the table I'm pulling "screen_entry_value" from
Name Null? Type
------------------------------- -------- ----
ELEMENT_ENTRY_VALUE_ID NOT NULL NUMBER(15)
EFFECTIVE_START_DATE NOT NULL DATE
EFFECTIVE_END_DATE NOT NULL DATE
INPUT_VALUE_ID NOT NULL NUMBER(9)
ELEMENT_ENTRY_ID NOT NULL NUMBER(15)
SCREEN_ENTRY_VALUE VARCHAR2(60)
sorry about the formatting 😱
Name Null? Type
------------------------------- -------- ----
ELEMENT_ENTRY_VALUE_ID NOT NULL NUMBER(15)
EFFECTIVE_START_DATE NOT NULL DATE
EFFECTIVE_END_DATE NOT NULL DATE
INPUT_VALUE_ID NOT NULL NUMBER(9)
ELEMENT_ENTRY_ID NOT NULL NUMBER(15)
SCREEN_ENTRY_VALUE VARCHAR2(60)
sorry about the formatting 😱
FUNCTION Procedure fPadNumber(
RETURN NUMBER;
IS
CURSOR cur_lngNum IS
SELECT screen_entry_value
FROM MyTable
WHERE my-where-statements-here;
IntPOS integer;
lngNum Long;
strNum VARCHAR;
BEGIN
OPEN cur_lngNum;
strNum = to_char(cur_lngNum,'0999.99');
lngNum = to_Number(strNum);
RETURN lngNum;
END fPadNumber;
RETURN NUMBER;
IS
CURSOR cur_lngNum IS
SELECT screen_entry_value
FROM MyTable
WHERE my-where-statements-here;
IntPOS integer;
lngNum Long;
strNum VARCHAR;
BEGIN
OPEN cur_lngNum;
strNum = to_char(cur_lngNum,'0999.99');
lngNum = to_Number(strNum);
RETURN lngNum;
END fPadNumber;
TRENDING THREADS
-
Discussion Zen 5 Speculation (EPYC Turin and Strix Point/Granite Ridge - Ryzen 9000)- Started by DisEnchantment
- Replies: 25K
-
Discussion Intel Meteor, Arrow, Lunar & Panther Lakes + WCL Discussion Threads
- Started by Tigerick
- Replies: 25K
-
Discussion Intel current and future Lakes & Rapids thread- Started by TheF34RChannel
- Replies: 24K
-
-
