SQL How to split out the Time from a DateTime col then use that in a WHERE Clause
The reason I needed the time splitting out was because I was working on an assignment to create a room booking project in vb.net. The database is stored in SQL Server and I had to use a table called Bookings which had the following 3 columns: BookDate StartTime EndTime I wanted to create a query [...]
View Answer
| January 4, 2012 3:43 PM
SQL, SQL Server
The reason I needed the time splitting out was because I was working on an assignment to create a room booking project in vb.net. The database is stored in SQL Server and I had to use a table called Bookings which had the following 3 columns: BookDate StartTime EndTime I wanted to create a query [...]
View Answer
| January 4, 2012 3:43 PM
SQL, SQL Server
Open IT Forum: What cloud concern do you need addressed?
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
OK I see two issues: 1. Larger organisations being able to allow internally-hosted and supported applications and webs. This does require in-house expertise or else contracted support and development from external organisations. However it may be preferable to host the data in-house (even if at a data centre) and retain maximum control. This needs to [...]
View Answer
| December 30, 2011 6:16 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
What are your favorite cloud security blogs?
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s not really a “blog” but it’all the rest ! Very good site with an system and application online vulnerabilities checking tool ! <a href=”http://secunia.com/vulnerability_scanning/online/?task=intro”></a> => http://secunia.com/vulnerability_scanning/online/?task=intro The best: https://blog.cloudsecurityalliance.org/
View Answer
| December 30, 2011 6:14 AM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Security bloggers, SQL Server, Storage, Virtualization, VoIP, Windows Server
Automate SSRS report
You might be able to pass the values for all of the contractid’s at the same time, then split them in the report so that it runs for all of them at the same time. Then you can set up the reports to automatically send and you won’t have to do anything manually…I love technology! [...]
View Answer
| May 10, 2013 9:20 PM
SSRS reports, Visual Studio
You might be able to pass the values for all of the contractid’s at the same time, then split them in the report so that it runs for all of them at the same time. Then you can set up the reports to automatically send and you won’t have to do anything manually…I love technology! [...]
View Answer
| May 10, 2013 9:20 PM
SSRS reports, Visual Studio
sql server 2005 do not show Add new administrator in Surface area Configuration
Can you log into SSMS using the SA password or your local login (depending on how you set up security during the install) and add the user from inside the SSMS interface?
View Answer
| December 8, 2011 9:04 PM
SQL Server 2005
Can you log into SSMS using the SA password or your local login (depending on how you set up security during the install) and add the user from inside the SSMS interface?
View Answer
| December 8, 2011 9:04 PM
SQL Server 2005
detach the .mdf files from sql server
Why are you trying to detach the database? Can’t you just take a backup of the database? You can easily enough configure a job to run on the 1st of every month.
View Answer
| November 23, 2011 1:45 PM
SQL Server, SQL Server backup
Why are you trying to detach the database? Can’t you just take a backup of the database? You can easily enough configure a job to run on the 1st of every month.
View Answer
| November 23, 2011 1:45 PM
SQL Server, SQL Server backup
Announcing the HP Elite Series Scavenger Hunt (sponsored)
what ever happened with this
View Answer
| November 17, 2011 5:21 AM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, EliteBook, Exchange, Giveaways, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
what ever happened with this
View Answer
| November 17, 2011 5:21 AM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, EliteBook, Exchange, Giveaways, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
AS400 – SQLRPGLE
There will be no specific function in SQL for recognizing display files. As you mentioned, we can decide the variable names dynamically. But, We cant be able to map these variables with DSPF Record format. Pradeep.
View Answer
| November 13, 2011 4:25 AM
AS/400 Display File, AS400 - Embedded SQL, Dynamic SQL, Embedded SQL, SQLRPGLE
There will be no specific function in SQL for recognizing display files. As you mentioned, we can decide the variable names dynamically. But, We cant be able to map these variables with DSPF Record format. Pradeep.
View Answer
| November 13, 2011 4:25 AM
AS/400 Display File, AS400 - Embedded SQL, Dynamic SQL, Embedded SQL, SQLRPGLE
Running Crystal Reports with a SQL Server Login instead of a Network Login
Sounds like your database server isn’t configured for both NT and SQL authentication. or you can use sa user that have access over target database.
View Answer
| November 5, 2011 12:02 PM
Crystal Reports, Crystal Reports error messages, Crystal Runtime, SQL Server
Sounds like your database server isn’t configured for both NT and SQL authentication. or you can use sa user that have access over target database.
View Answer
| November 5, 2011 12:02 PM
Crystal Reports, Crystal Reports error messages, Crystal Runtime, SQL Server
Archiving and Purging Data
Your current technique seams sound. I would recommend sticking with the existing method, and simply moving the data from the current server to the archive server using DTS or SSIS on a daily basis. Then on the server with the current years worth of data delete all data which is over on year old. Are [...]
View Answer
| November 1, 2011 9:57 AM
SQL Server administration, SQL Server archiving
Your current technique seams sound. I would recommend sticking with the existing method, and simply moving the data from the current server to the archive server using DTS or SSIS on a daily basis. Then on the server with the current years worth of data delete all data which is over on year old. Are [...]
View Answer
| November 1, 2011 9:57 AM
SQL Server administration, SQL Server archiving
How to recover the deleted database using transaction log file?
Log file could not be used to backup the entire database of your computer server. Since it is just a log file, you can only see the logs of the activities done in your computer system like installing, editing, adding, deleting, etc.
View Answer
| October 31, 2011 2:00 AM
Data Recovery, SQL Log Files, SQL Server, SQL Server transaction logs, Windows, Windows Server, Windows Server 2003, Windows Server 2003 Backup
Log file could not be used to backup the entire database of your computer server. Since it is just a log file, you can only see the logs of the activities done in your computer system like installing, editing, adding, deleting, etc.
View Answer
| October 31, 2011 2:00 AM
Data Recovery, SQL Log Files, SQL Server, SQL Server transaction logs, Windows, Windows Server, Windows Server 2003, Windows Server 2003 Backup
upgrade SQL Server 2008 32-bit to 64-bit
All you need to do is detach the database from the old server and attach it to the new server. You can also backup the database and restore it to the new server. As far as the database is considered it doesn’t care if it’s on a 32bit or 64bit system.
View Answer
| October 27, 2011 9:02 PM
Microsoft SQL Server
All you need to do is detach the database from the old server and attach it to the new server. You can also backup the database and restore it to the new server. As far as the database is considered it doesn’t care if it’s on a 32bit or 64bit system.
View Answer
| October 27, 2011 9:02 PM
Microsoft SQL Server
SSRS 2008 R2 Trendlines
Hi NHSNick, Just follow the article, it has your solution: http://blogs.msdn.com/b/robertbruckner/archive/2008/11/09/trendlines-calculated-series-in-reporting-services-charts.aspx Also refer to the article, it has some good work: http://beyondrelational.com/blogs/chintak/archive/2010/12/02/add-a-moving-average-trend-line-to-bar-column-chart-in-ssrs.aspx Hope it helps you Do update us again. Thank you Anil <a href=”http://www.lepide.com”>LEPIDE</a>
View Answer
| October 24, 2011 7:21 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
Hi NHSNick, Just follow the article, it has your solution: http://blogs.msdn.com/b/robertbruckner/archive/2008/11/09/trendlines-calculated-series-in-reporting-services-charts.aspx Also refer to the article, it has some good work: http://beyondrelational.com/blogs/chintak/archive/2010/12/02/add-a-moving-average-trend-line-to-bar-column-chart-in-ssrs.aspx Hope it helps you Do update us again. Thank you Anil <a href=”http://www.lepide.com”>LEPIDE</a>
View Answer
| October 24, 2011 7:21 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
SQL Server backup to remote internet location
Backups can be done via the normal backup processes in SQL Server via the BACKUP DATABASE and BACKUP LOG statements. Getting the data to an internet location. How you get the files to that location will depend totally on the internet location that you will be uploading the files to.
View Answer
| October 20, 2011 2:55 AM
SQL Backup, SQL Database, SQL Server, SQL Server backup
Backups can be done via the normal backup processes in SQL Server via the BACKUP DATABASE and BACKUP LOG statements. Getting the data to an internet location. How you get the files to that location will depend totally on the internet location that you will be uploading the files to.
View Answer
| October 20, 2011 2:55 AM
SQL Backup, SQL Database, SQL Server, SQL Server backup
Free IT Book: Demystifying the Virtual Desktop
http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/#viewquestion http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/ hope to win
View Answer
| October 18, 2011 4:36 PM
AS/400, Business Intelligence, Channel, CIO, 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
http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/#viewquestion http://itknowledgeexchange.techtarget.com/itanswers/extend-hdd/ hope to win
View Answer
| October 18, 2011 4:36 PM
AS/400, Business Intelligence, Channel, CIO, 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
MS Project Server errors
Determining given trouble is a <a href=”http://www.recoverytoolbox.com/project.html”>ms project recovery</a>. Present software owns some required facilities such as working with big mpp files, using high end, clear interface, launching under low system requirements, any version of Windows OS.
View Answer
| October 16, 2011 11:07 AM
invalid currency, Microsoft Project, Microsoft Project 2007, Microsoft Project Errors, SharePoint 2007, SQL Server 2005, Windows Server 2003, Windows Server 2007
Determining given trouble is a <a href=”http://www.recoverytoolbox.com/project.html”>ms project recovery</a>. Present software owns some required facilities such as working with big mpp files, using high end, clear interface, launching under low system requirements, any version of Windows OS.
View Answer
| October 16, 2011 11:07 AM
invalid currency, Microsoft Project, Microsoft Project 2007, Microsoft Project Errors, SharePoint 2007, SQL Server 2005, Windows Server 2003, Windows Server 2007
EXTENDED: IT Scripts Contest now ends October 17
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
IT Scripts. If i win, i promise, i’ll start scripting (even in 3D), because now, i’m too busy in coding real stuff ! lol )
View Answer
| October 13, 2011 2:46 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
conversion of oracle trigger to MS SQL
There are some conversion tools you could use (paid and free), but you will have to review the resultant code to make sure everything is Ok. Here are a couple of links you might find useful: <a href=”http://search.swissql.com/oratosql/”>Oracle to SQL Server Stored Procedure Migration</a> (<b>supposedly </b>free online migration) <a href=”http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx”>Free Microsoft SQL Server Database Migration [...]
View Answer
| October 12, 2011 2:50 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server
There are some conversion tools you could use (paid and free), but you will have to review the resultant code to make sure everything is Ok. Here are a couple of links you might find useful: <a href=”http://search.swissql.com/oratosql/”>Oracle to SQL Server Stored Procedure Migration</a> (<b>supposedly </b>free online migration) <a href=”http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx”>Free Microsoft SQL Server Database Migration [...]
View Answer
| October 12, 2011 2:50 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server
Return only one word– SQL
If you know that there is a match why not just return the value that you are looking for? If you wanted to pull the value from the column you would need to use the SUBSTRING and PATINDEX (in SQL Server at least) to get that value from the column.
View Answer
| October 5, 2011 11:53 PM
Oracle, Oracle SQL, SQL, SQL Server
If you know that there is a match why not just return the value that you are looking for? If you wanted to pull the value from the column you would need to use the SUBSTRING and PATINDEX (in SQL Server at least) to get that value from the column.
View Answer
| October 5, 2011 11:53 PM
Oracle, Oracle SQL, SQL, SQL Server
Error Message in SQL Server 2008 code.
Remove the comma after Emp.LoginID.
View Answer
| October 5, 2011 1:33 PM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
Remove the comma after Emp.LoginID.
View Answer
| October 5, 2011 1:33 PM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008
