VarChar to Numeric in SSRS
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
Flowchart and algorithm
How can I find a flow chart and algorithm of a program that finds the minimum of three values?
Answer Question
| May 12, 2013 11:18 AM
SQL program, SQL Server 2005
How can I find a flow chart and algorithm of a program that finds the minimum of three values?
Answer Question
| May 12, 2013 11:18 AM
SQL program, SQL Server 2005
Flowchart
Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!
Answer Question
| May 12, 2013 11:13 AM
Algorithms, SQL Server 2005
Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!
Answer Question
| May 12, 2013 11:13 AM
Algorithms, SQL Server 2005
MSDTC promoting a transaction only in some environments
We have a service which uses LINGTOSQL to process some updates on a remote SQL box. On some machines everything is fine and it works without DTC enabled. On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn’t been enabled correctly. This is on SQL [...]
Answer Question
| May 8, 2013 2:45 PM
DTC, SQL 2008, SQL 2008 R2
We have a service which uses LINGTOSQL to process some updates on a remote SQL box. On some machines everything is fine and it works without DTC enabled. On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn’t been enabled correctly. This is on SQL [...]
Answer Question
| May 8, 2013 2:45 PM
DTC, SQL 2008, SQL 2008 R2
How to insert Hex values through SQL/400
Hi, I’m creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can [...]
Answer Question
| April 23, 2013 11:07 PM
SQL Database, SQL Query, SQL/400
Hi, I’m creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can [...]
Answer Question
| April 23, 2013 11:07 PM
SQL Database, SQL Query, SQL/400
Any unsurpassed method to start-off this procedure an appropriate
I’m used to a setup which welcomes anyone who wishes a sort of an executive entry to a domain only to get imputed to the domain admin’s group. I apologize for such faulty actions, and am now separating all of our “admins” into their own groups. Specifically, I have users who require permission to assign [...]
Answer Question
| April 19, 2013 5:31 AM
SQL Server, SQL Server permissions
I’m used to a setup which welcomes anyone who wishes a sort of an executive entry to a domain only to get imputed to the domain admin’s group. I apologize for such faulty actions, and am now separating all of our “admins” into their own groups. Specifically, I have users who require permission to assign [...]
Answer Question
| April 19, 2013 5:31 AM
SQL Server, SQL Server permissions
Access
How do I access SQL data in software?
Answer Question
| April 18, 2013 11:20 AM
SQL Database, VB .NET
How do I access SQL data in software?
Answer Question
| April 18, 2013 11:20 AM
SQL Database, VB .NET
How to read MS SQL tables using iSeries RPG
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?
Answer Question
| April 4, 2013 9:27 PM
iSeries, RPG Program, SQL 2008
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?
Answer Question
| April 4, 2013 9:27 PM
iSeries, RPG Program, SQL 2008
SQL Plus stops before finishing
Why does SQL+ stop after running so many characters in a long SQL statement?
Answer Question
| April 3, 2013 12:23 PM
SQL Plus, SQL statement
Why does SQL+ stop after running so many characters in a long SQL statement?
Answer Question
| April 3, 2013 12:23 PM
SQL Plus, SQL statement
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
webservice and iDB2 connections slow on startup
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]
Answer Question
| April 1, 2013 2:11 PM
AS 400, DB2 connectivity, i series, SQL Server
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]
Answer Question
| April 1, 2013 2:11 PM
AS 400, DB2 connectivity, i series, SQL Server
I need the date to go to my dataTable
I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont [...]
Answer Question
| March 29, 2013 5:10 PM
SQL Database, VB 2012
I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont [...]
Answer Question
| March 29, 2013 5:10 PM
SQL Database, VB 2012
Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]
Answer Question
| March 29, 2013 9:37 AM
Microsoft Excel 2003, SSRS 2008
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]
Answer Question
| March 29, 2013 9:37 AM
Microsoft Excel 2003, SSRS 2008
Exchange – extracting email properties
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]
Answer Question
| March 29, 2013 9:35 PM
Microsoft Exchange 2007, SQL Server tables
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]
Answer Question
| March 29, 2013 9:35 PM
Microsoft Exchange 2007, SQL Server tables
Importing Excel data into SQL Server and filtering columns of Excel data in SQL
I’m trying to import Excel sheet’s data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?
Answer Question
| March 26, 2013 5:34 AM
Microsoft Excel 2010, SQL Server
I’m trying to import Excel sheet’s data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?
Answer Question
| March 26, 2013 5:34 AM
Microsoft Excel 2010, SQL Server
Server upgrade 2003 to 2008
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.
Answer Question
| March 26, 2013 10:13 PM
SQL Server 2003, SQL Server 2008 R2
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.
Answer Question
| March 26, 2013 10:13 PM
SQL Server 2003, SQL Server 2008 R2
Unidirectional replication in SQL Server 2008
Can transactional replication be bidirectional?
Answer Question
| March 25, 2013 2:29 PM
SQL Server 2008, SQL Server replication
Can transactional replication be bidirectional?
Answer Question
| March 25, 2013 2:29 PM
SQL Server 2008, SQL Server replication
Linked server SQL select into
I’m trying to create a stored procedure that will trigger every 15 minutes via a server agent job. I need to pull data back from a linked server to our SQL server. The tables have the same columns/fields just different names. I know the linked server logic works because I get the data if I [...]
Answer Question
| March 22, 2013 3:57 PM
SQL Server, SQL Server Agent Jobs
I’m trying to create a stored procedure that will trigger every 15 minutes via a server agent job. I need to pull data back from a linked server to our SQL server. The tables have the same columns/fields just different names. I know the linked server logic works because I get the data if I [...]
Answer Question
| March 22, 2013 3:57 PM
SQL Server, SQL Server Agent Jobs
Getting DB2 data into SQL 2008 database
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]
Answer Question
| March 20, 2013 7:59 PM
AS/400, DB2, iSeries, SQL 2008
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]
Answer Question
| March 20, 2013 7:59 PM
AS/400, DB2, iSeries, SQL 2008
Creating service accounts in Windows 7 home edition
In Mike Hotek’s book SQL Server 2008 he gave instructions on how to create service accounts using XP. How do I create these accounts using Windows 7 home edition? Thanks.
Answer Question
| March 14, 2013 12:38 AM
SQL Server 2008, Windows 7
In Mike Hotek’s book SQL Server 2008 he gave instructions on how to create service accounts using XP. How do I create these accounts using Windows 7 home edition? Thanks.
Answer Question
| March 14, 2013 12:38 AM
SQL Server 2008, Windows 7
