Learn more about SQL Server tools

solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips

   Got a SQL tip?
            We want to know!

SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

Coalesce BookingHour and BookingMinutes and show BookingHour as minutes
WIthin the same statement, is it possible to"translate" the BookingLengthHour into Minutes and COALESCE both columns together so that both display in one column as minutes? If not, how might I accomplish this? Both BookingLengthHour and BookingLengthM

asked 6/10/2014 1:14:14 PM
by Jon Lellelid
1 answers

Exhibit an SVG image stored in the database
Hello,   Have searched high and low, but not found a good solution yet. We have in our database a column that stores an svg stream (ex: <svg viewbox><polygon ...></svg>).   We would like to use that svg stream to exibhit th

asked 6/9/2014 4:35:51 PM
by Mateus
0 answers

create powershell script for NIC Health check and Group policy
anybody create powershell script for NIC Health check and Group policy elated  plz do needful

asked 6/7/2014 6:36:36 AM
by chandu
0 answers

  There are two tables : Table1 : id empid 1 49 2 50 3 51 4 52 5 54  Table 2 : empid date 49 08/27/13 50 08/27/13 51 08/27/13 52 08/27/13 49 10/05/12 49

asked 6/6/2014 11:16:44 AM
by Deepak
2 answers

Architecture/Design to maintain multiple version of application database
We have a Silverlight based application which currently supports only one production version. Idea is to support three concurrent versions of the same application and user will switch to the newer versions based on their interest or they can still continu

asked 6/6/2014 8:39:10 AM
by Saikat
1 answers

SQL Server Job issue -- It's an emergency
Hi,One of our Production Servers contains a job (Daily run) which gets the Data from another Server and dump into local DB. From last couple of days, it is failing with the reason "Unspecified error occurred on SQL Server. Connection may have been termina

asked 6/6/2014 7:29:28 AM
by Ajaykumar
1 answers

Adding counter to name
Trying to add a counter to names only when IDs are the same. My query adds counter to all names regardless if IDs are the same or not. I have includes both results of my query and the ideal one. --Drop table ##ProvCREATE TABLE ##prov ( id VARCHAR(1)

asked 6/4/2014 4:22:50 PM
by Helal
1 answers

Policy Based Management - Server Permission Checking
(Please disgrard my typing) I am trying to determine the best way to proceed on a project.  Basically I have some predefined server permissions that I need to check for.  i.e., Alter\Create View Server State My List is fairly long and consists

asked 6/2/2014 3:47:52 PM
by Swoozie
2 answers

Creating Repayment database
Hi experts, please note that I am a beginner in banking programming, and I want to create a table that calculate the repayment amounts.       As shown in the below table, the cardno 5140560000001142 has a trnamt of 1239 so that means th

asked 6/2/2014 11:55:22 AM
by Sofian
0 answers

Update sql server tables using inner join

asked 6/2/2014 2:59:07 AM
by Guruvayurappan sivaguruswamynathan
1 answers

SQL Server 2012 Standard Edition Failover Cluster Windows 2012 R1 --> Windows 2012 R2
My current production environment is SQL Server 2012 R1 Standard Edition on a Failover Cluster in Windows 2012 R1.  I am new to SQL Server, 15 years Oracle DBA.   My system administrator is upgrading the operating system to Windows 2012 R2 and

asked 5/30/2014 5:49:45 PM
by Keith Brockman
2 answers

How are all you SSRS admins handling the increased permissions requirements in 2012?
We are migrating from SSRS 2008 R2 integrated with SharePoint 2010 to SharePoint 2013. In our test migrations, everything works great except for end users being unable to create subscriptions. Turns out this was an intentional design change on the part o

asked 5/30/2014 3:36:35 PM
by Eric Riehl
1 answers

Severity 017
I am a new DBA and I recently got an alert message saying I got insufficient resource, how do I find the root cause of this or the query causing this and how do I troubleshoot this problem, can anyone give me a step by step guide please? DATE/TIME: 

asked 5/29/2014 3:28:18 PM
by tigist
0 answers

Login valid but database unavailable
Hi,   I have received an error message. Here is the error code: Error: 18456, Severity: 14, State: 38 Do you have any idea for this? Best    

asked 5/28/2014 11:06:47 AM
by Drivers123
2 answers

SSRS Localization
Hi ,  Is there a way we can localize the prompts (names) in the rdl for a specific language.  Say i have an option to chose languages from a dropdown in the report , the report should change the language once i chose "Spanish" from english.&nb

asked 5/28/2014 2:26:22 AM
by arpitha prasad
0 answers

Blank cells SSRS report
Have multiple cells in different columns of SSRS report that I would lik to show as NA Is there a way to do this globally for the report?

asked 5/27/2014 1:41:52 PM
by Joe Munch
0 answers

  Data in one table is not required and it's 8 GB size.  In SQL articles after deleting data, SHRINK is not advised for big databases. So please suggest what is the best option to remove 8GB unwanted data from the total 250 GB database. 

asked 5/27/2014 4:43:41 AM
by Vinu
1 answers

how to add addition 7 hour to all SQL Server Agent jobs' schedule
I have 100 SQL Agent jobs with various schedule. And, I needed to add addition 7 hour ahead to existing schedule.    For instance, Job_A has schedule Occurs every week on Monday, Tuesday, Wednesday, Thursday, Friday at 6:00:00 PM.

asked 5/22/2014 3:58:57 PM
by Edwin
0 answers

Calculated Member in SSAS
I have one Fact Table with three Dimensions. I need to write a Calculated Member in SSAS  using this sql code below, but I am lost. Fact Table--> FacteTMS Dimensions---> 1)  DimeTMSOrg  (2) DimDate   SELECT   &

asked 5/22/2014 1:03:13 PM
by Ebenezer Aniapam
0 answers

using filters and parameters to the grouped column in ssrs
Hi, i have created a linked report, in which the first report has two columns servername and databases. Servername is grouped column and drill down is enabled, on expansion which shows the list of databases in the server. these database names are used

asked 5/21/2014 7:55:02 PM
by saravana
0 answers

Sponsor Information

Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | today's tip | first timer?
Some names and products listed are the registered trademarks of their respective owners.