annetteharper.info
BI Publisher | Annette Harper
http://www.annetteharper.info/category/bi-publisher
Skip to main content. Category Archives: BI Publisher. BI Publisher Parameters Need Conversion to use as SQL Server Variables. February 2, 2014. My team recently had to use BI Publisher 11g with a SQL Server 2008R2 datasource and found that simply copying the source SQL code into BIP and setting variables declared in the script equal to BIP parameters didn’t work. Long story short, a simple convert did the trick. Declare @Var1 datetime = :Var1; Declare @Var2 int = :Var2; Declare @Var3 varchar(15) = :Var3;.
annetteharper.info
February | 2014 | Annette Harper
http://www.annetteharper.info/2014/02
Skip to main content. BI Publisher Parameters Need Conversion to use as SQL Server Variables. February 2, 2014. My team recently had to use BI Publisher 11g with a SQL Server 2008R2 datasource and found that simply copying the source SQL code into BIP and setting variables declared in the script equal to BIP parameters didn’t work. Long story short, a simple convert did the trick. Declare @Var1 datetime = :Var1; Declare @Var2 int = :Var2; Declare @Var3 varchar(15) = :Var3;. Proudly powered by WordPress.
annetteharper.info
m.annette.harper@gmail.com | Annette Harper
http://www.annetteharper.info/author/m-annette-harpergmail-com
Skip to main content. Author Archives: m.annette.harper@gmail.com. August 28, 2014. Those elusive women. They seem to have dropped into the family line from an alien spaceship or popped into existence like a magician’s assistant. Who are they and where did they come from? On to that lateral research. Click to email this to a friend (Opens in new window). Click to print (Opens in new window). Click to share on LinkedIn (Opens in new window). Share on Facebook (Opens in new window). February 2, 2014. So, t...
annetteharper.info
Finding Maiden Names | Annette Harper
http://www.annetteharper.info/2014/08/28/finding-maiden-names
Skip to main content. August 28, 2014. Those elusive women. They seem to have dropped into the family line from an alien spaceship or popped into existence like a magician’s assistant. Who are they and where did they come from? On to that lateral research. I was shocked and very pleased to receive a copy the very next day (thank you, Deb Lowrance). In the obituary, Solomon’s mother was named as Susan Wurstler Lantzer. Voila. The lesson is that my mother is also my brother’s mother. Send to Email Address.
annetteharper.info
August | 2014 | Annette Harper
http://www.annetteharper.info/2014/08
Skip to main content. August 28, 2014. Those elusive women. They seem to have dropped into the family line from an alien spaceship or popped into existence like a magician’s assistant. Who are they and where did they come from? On to that lateral research. I was shocked and very pleased to receive a copy the very next day (thank you, Deb Lowrance). In the obituary, Solomon’s mother was named as Susan Wurstler Lantzer. Voila. The lesson is that my mother is also my brother’s mother. Send to Email Address.
annetteharper.info
BI Publisher Parameters Need Conversion to use as SQL Server Variables | Annette Harper
http://www.annetteharper.info/2014/02/02/parameters-and-declared-variables-in-oracle-bi-publisher-11g-with-sql-server-datasources
Skip to main content. BI Publisher Parameters Need Conversion to use as SQL Server Variables. February 2, 2014. My team recently had to use BI Publisher 11g with a SQL Server 2008R2 datasource and found that simply copying the source SQL code into BIP and setting variables declared in the script equal to BIP parameters didn’t work. Long story short, a simple convert did the trick. Declare @Var1 datetime = :Var1; Declare @Var2 int = :Var2; Declare @Var3 varchar(15) = :Var3;. April 13, 2015 at 12:18 am.
annetteharper.info
About Me | Annette Harper
http://www.annetteharper.info/sample-page
Skip to main content. Click to email this to a friend (Opens in new window). Click to print (Opens in new window). Click to share on LinkedIn (Opens in new window). Share on Facebook (Opens in new window). Click to share on Twitter (Opens in new window). Click to share on Google (Opens in new window). BI Publisher Parameters Need Conversion to use as SQL Server Variables. On BI Publisher Parameters Need Conversion to use as SQL Server Variables. Proudly powered by WordPress. Send to Email Address.