VS 2005 SQL Reports – Need to convert 5 character string to datatime
Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called ‘Duration’. The datatype is char(5) e.g. “00:30″ to represent a half hour. I suppose I need to change the datatype to sum it but can’t figure out how to. What [...]
Answer Question
| March 31, 2012 8:16 PM
SQL, SQL Server, SSRS, Visual Studio 2005, VS 2005
Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called ‘Duration’. The datatype is char(5) e.g. “00:30″ to represent a half hour. I suppose I need to change the datatype to sum it but can’t figure out how to. What [...]
Answer Question
| March 31, 2012 8:16 PM
SQL, SQL Server, SSRS, Visual Studio 2005, VS 2005
SQL Server Management Studio Express 2005
I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?
Answer Question
| March 31, 2012 5:18 PM
SQL Server 2005 Express, SQL Server Management Studio, SQL Server Management Studio 2005, SQL Server Management Studio Express, SSMS
I have installed Studio Express on my system but I am not able to start with it. I am not able to connect to the server. Error-40 and Error-26 is coming.What is the procedure to connect?
Answer Question
| March 31, 2012 5:18 PM
SQL Server 2005 Express, SQL Server Management Studio, SQL Server Management Studio 2005, SQL Server Management Studio Express, SSMS
Query Optimizer not Selecting Index on a Computed Column – Performs Table Scan
Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by. The computed column is not persisted and there is a non-cluster index on it (the only index on the table). When [...]
Answer Question
| March 31, 2012 6:27 PM
SQL Query, SQL Server 2008, SQL Server 2008 64-bit
Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by. The computed column is not persisted and there is a non-cluster index on it (the only index on the table). When [...]
Answer Question
| March 31, 2012 6:27 PM
SQL Query, SQL Server 2008, SQL Server 2008 64-bit
Free IT Book: Building Applications in the Cloud
This week’s free IT book is Christopher Moyer’s Building Applications in the Cloud: Concepts, Patterns, and Projects. “Don’t just migrate the cloud: Use cloud architectural patterns that deliver superior performance, scalability, and availability” with this great resource. Answer one of five questions and post the link to your answer in the discussion area below. Entourage, [...]
Answer Question
| March 31, 2012 1:29 PM
AS/400, Business Intelligence, Channel, CIO, Cloud storage, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is Christopher Moyer’s Building Applications in the Cloud: Concepts, Patterns, and Projects. “Don’t just migrate the cloud: Use cloud architectural patterns that deliver superior performance, scalability, and availability” with this great resource. Answer one of five questions and post the link to your answer in the discussion area below. Entourage, [...]
Answer Question
| March 31, 2012 1:29 PM
AS/400, Business Intelligence, Channel, CIO, Cloud storage, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
VPN Hollander Powerlink Server issues
I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having [...]
Answer Question
| March 31, 2012 3:34 AM
SQL Database, SQL Server 2005 performance, SQL Server security, VPN connectivity, Windows XP Pro SP3
I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having [...]
Answer Question
| March 31, 2012 3:34 AM
SQL Database, SQL Server 2005 performance, SQL Server security, VPN connectivity, Windows XP Pro SP3
VPN Connectivity Issue with SQL Database
My Issue is with a VPN Connection. I have an SQL Data Base set up on a Windows XP Pro machine. We are using a Clear Motorola WFIMAX Modem and an AirPort Extreme Router. I have port 1723 Forwarded and Out going and Incoming Connections created on both Server and Client. The Server has a [...]
Answer Question
| March 31, 2012 1:26 AM
Networking services, SQL Database, VPN connection problem, VPN connectivity, VPN issue
My Issue is with a VPN Connection. I have an SQL Data Base set up on a Windows XP Pro machine. We are using a Clear Motorola WFIMAX Modem and an AirPort Extreme Router. I have port 1723 Forwarded and Out going and Incoming Connections created on both Server and Client. The Server has a [...]
Answer Question
| March 31, 2012 1:26 AM
Networking services, SQL Database, VPN connection problem, VPN connectivity, VPN issue
Validating Active Directory login from within a stored-procedure
I have an application that needs to use active directory to ensure user login is valid. The issue is that the machine is in a different domain than our AD server. I am looking at creating a clr procedure on the SQL server that is in the same domain. Then from the application execute a procedure [...]
Answer Question
| July 5, 2011 3:14 PM
Active Directory, Active Directory security, CLR Active Directory, Stored Procedures
I have an application that needs to use active directory to ensure user login is valid. The issue is that the machine is in a different domain than our AD server. I am looking at creating a clr procedure on the SQL server that is in the same domain. Then from the application execute a procedure [...]
Answer Question
| July 5, 2011 3:14 PM
Active Directory, Active Directory security, CLR Active Directory, Stored Procedures
conversion of SQL Server 2008 stored procedure to Oracle 10g
Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g
Answer Question
| May 15, 2012 7:54 AM
Oracle 10g, SQL Server 2008, SQL stored procedures
Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g
Answer Question
| May 15, 2012 7:54 AM
Oracle 10g, SQL Server 2008, SQL stored procedures
Trustworthy Self-study material for SQL Server and Oracle
As a novice, I am seeking advice regarding the best (trustworthy) self-study material for Microsoft Sql server or Oracle exams and that would teach me what I need to know for training.
Answer Question
| July 1, 2011 2:51 PM
Oracle, Oracle training, SQL Server, SQL Server Training
As a novice, I am seeking advice regarding the best (trustworthy) self-study material for Microsoft Sql server or Oracle exams and that would teach me what I need to know for training.
Answer Question
| July 1, 2011 2:51 PM
Oracle, Oracle training, SQL Server, SQL Server Training
Optimize SQL 2005 databases on a schedule
How can I optimize my SQL 2005 databases on a schedule?
Answer Question
| June 28, 2011 6:21 PM
SQL 2005, SQL 2005 Database, SQL Database, SQL Server 2005, SQL Server 2005 Database
How can I optimize my SQL 2005 databases on a schedule?
Answer Question
| June 28, 2011 6:21 PM
SQL 2005, SQL 2005 Database, SQL Database, SQL Server 2005, SQL Server 2005 Database
Reading xml url into SQL Server 2008 Table with OpenXML
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]
Answer Question
| June 28, 2011 5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]
Answer Question
| June 28, 2011 5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development
Open IT Forum: What are your views on social networking platforms in your network?
I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT’s changing attitude toward cloud-based offerings such as social networking platforms. I’d love to hear from practicing IT professionals about the impact of these platforms on the network, whether it’s security or storage. Share your opinion or experience, [...]
Answer Question
| July 8, 2011 3:28 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, Platform integration, Platform Solutions, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT’s changing attitude toward cloud-based offerings such as social networking platforms. I’d love to hear from practicing IT professionals about the impact of these platforms on the network, whether it’s security or storage. Share your opinion or experience, [...]
Answer Question
| July 8, 2011 3:28 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, Platform integration, Platform Solutions, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free IT Book: CompTIA Security+ Certification Passport
This week’s free IT book is Mike Meyers’ CompTIA Security+ Certification Passport: Revised for the new CompTIA Security+ exam (SY0-301). The new edition provides a condensed and concise review of CompTIA’s well-established security credential. For a chance to win this quick review, cram-style test preparation guide that offers 100% coverage of all exam objectives for [...]
Answer Question
| September 16, 2011 8:37 PM
AS/400, Business Intelligence, Channel, CIO, CompTIA, CompTIA Security+, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is Mike Meyers’ CompTIA Security+ Certification Passport: Revised for the new CompTIA Security+ exam (SY0-301). The new edition provides a condensed and concise review of CompTIA’s well-established security credential. For a chance to win this quick review, cram-style test preparation guide that offers 100% coverage of all exam objectives for [...]
Answer Question
| September 16, 2011 8:37 PM
AS/400, Business Intelligence, Channel, CIO, CompTIA, CompTIA Security+, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL code made simpler
I have 2 files that are clones – created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the [...]
Answer Question
| June 24, 2011 7:11 PM
CRTDUPOBJ, SQL iSeries, SQL Server, V5R4
I have 2 files that are clones – created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the [...]
Answer Question
| June 24, 2011 7:11 PM
CRTDUPOBJ, SQL iSeries, SQL Server, V5R4
DBF in AS/400 – last record written
Hi , There is file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it. Thanks
Answer Question
| June 22, 2011 3:58 PM
AS/400, AS/400 Database File, Database Files, RPG, RPGLE
Hi , There is file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it. Thanks
Answer Question
| June 22, 2011 3:58 PM
AS/400, AS/400 Database File, Database Files, RPG, RPGLE
UNICODE Characters
When you run the query below: SELECT ‘✘ РǻuľO Čєѕaя ™’ She is returning this: “?? Ulo C? To? ™” How to query return without truncating the text?
Answer Question
| June 22, 2011 3:10 PM
SQL Query, SQL Server, SSMS, Unicode
When you run the query below: SELECT ‘✘ РǻuľO Čєѕaя ™’ She is returning this: “?? Ulo C? To? ™” How to query return without truncating the text?
Answer Question
| June 22, 2011 3:10 PM
SQL Query, SQL Server, SSMS, Unicode
System tables in SQL Server
How to view System tables in drop down menu of a database in SQL SERVER 2005
Answer Question
| June 23, 2011 12:43 PM
Database, SQL 2005, SQL Server 2005, System tables
How to view System tables in drop down menu of a database in SQL SERVER 2005
Answer Question
| June 23, 2011 12:43 PM
Database, SQL 2005, SQL Server 2005, System tables
iSeries SQL case on AS/400
Is there an equivalent to case when exists on the as/400?
Answer Question
| June 23, 2011 10:14 AM
AS/400 SQL, DB2 SQL, iSeries, iSeries SQL
Is there an equivalent to case when exists on the as/400?
Answer Question
| June 23, 2011 10:14 AM
AS/400 SQL, DB2 SQL, iSeries, iSeries SQL
View in SQL 2000
How to create view with parameter? Thanks and regards.
Answer Question
| June 22, 2011 9:12 AM
SQL 2000, SQL Parameters, SQL Server, SQL Server 2000, SQL View
How to create view with parameter? Thanks and regards.
Answer Question
| June 22, 2011 9:12 AM
SQL 2000, SQL Parameters, SQL Server, SQL Server 2000, SQL View
Can you use variables as input and output when calling a stored procedure in COBOL?
If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data. So far, that [...]
Answer Question
| June 27, 2011 5:02 PM
CL variables, COBOL, SQL procedure, SQL variables, Variable fields
If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data. So far, that [...]
Answer Question
| June 27, 2011 5:02 PM
CL variables, COBOL, SQL procedure, SQL variables, Variable fields
