Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

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

calculate no.days from two date's values retrieving from two tables using cursor.
hello i'm trying to retreive date value from two different tables to calculate number of days between these two date's values Table 1 : Account (ActNumber, Name, Status, DateOpen, type). Table 2 : Transaction ( TransNumber ,Actnumber ,DateTransact

asked 6/6/2015 5:00:49 AM
by hams101
1 answers

Hi Team   I wanted to know how to use SSIS Excel Refresh Task i understand this connection would work only with 2012 version. However create connectio manager using this option.Could some one help me on this

asked 6/4/2015 6:12:52 AM
by Surender
0 answers

Highlight Text (single word) with color in SSRS
Hi I created parameter which allows us to enter any text eg: London, Reading or Green (anything) and hit view report button. I am getting report filtered only has parameter text value (no problem until now) Now i want to highlight parameter T

asked 6/3/2015 11:52:06 AM
by ven
0 answers

Restore values from Database
Hello sir, good afternoon i need your help regarding SQL server, by-mistaken i updated values of a column in a database hosted online, is there any way undo the transaction. I didn't created any backup of the database. I read that still it can be recoverd

asked 6/3/2015 6:24:51 AM
by Dharmendra
1 answers

Is that possible to develop SSRS report in standard edition(local server) and deploy onto web edition on cloud azure
Hello Everyone, I developed the SSRS reports in standerd edition 2012 that is on local server, Now i need to deploy the same report running on web edition on cloud azure. but i am using SSIS also in standerd edition.

asked 6/3/2015 5:12:23 AM
by Ganesh
0 answers

How to show both detailed and aggregate data in one Tablix in SSRS
I am developing a report in Visual Studio 2013 and report requirements are: Report should include detailed data for each provider who provides individual services to patients Report also should include records for providers who provide group services.

asked 6/2/2015 10:58:05 AM
by helal
0 answers

Implementing TDE(Transferent Data Encryption) as well as Cell Level Encryption
Hi, I have created the database called eClinic. now i wanted to implement TDE and Cell Level Encryption to single database. can it be possible to implement TDE as well as Cell Level Encryption using certificate Please quide. Regards Parashuram

asked 5/30/2015 7:57:52 AM
by Parashuram
0 answers

Test connection failed because of an error in initializing provider
I am new at this SSIS. I know Informatica well (it does what SSIS does). I am creating my first SSIS package, simple, I read a file, a com***tion and then write it to an excel.I am getting the message: "Test connection failed because of an error in i

asked 5/29/2015 5:17:57 PM
by Shark
1 answers

Access Pass-through queries fail on only one machine
Any suggestions? I am troubleshooting MS Access FE db (designed by others) with table links SQLServer BE . FE is for reporting, is located on a server, run from 3 user machines (one at a time). System DSN is the same on all 3 machines. On ONE of the ma

asked 5/29/2015 4:05:15 PM
by jacqui evanchik
0 answers

SQL Server
Hi Guys, How to change the database from normal mode to restoring mode without restoring backup?  

asked 5/28/2015 9:58:06 AM
by Rathish
2 answers

How can I combine detailed and aggreagte data in one table?
To be precise and organized, I have divided my questions into three parts and result. Here is my detailed data in PART 1:PART 1:--Drop Table #partitionovercreate table #partitionover(ProviderID          &n

asked 5/27/2015 8:48:12 PM
by Helal
0 answers

Replication is not working properly when i synchronize it gives this message i will write in the comment
  sql server is unable to complete the operation additional information: an error exception occured while attempting to access the subscription ( view synchronization status ) an exception occured while executing a transact-SQL statement or bat

asked 5/27/2015 12:53:55 AM
by obaidullah
0 answers

sql server reporting service goto url
I am facing problem when passing value for url through data field.   I am passing value in goto url like this ="javascript:void(window.open('file:" &Fields!url.Value &"','_blank'))"   url value = /servername/foldername/Formulá

asked 5/26/2015 4:56:01 AM
by shyam
0 answers

i want to perform a log backup in production server but my databases are in simple recovery model what can i do please help

asked 5/25/2015 2:16:53 PM
by girma mamo
2 answers

To uncluster a SQL2008 and make it as stand alone instance on one of the node
Uncluster a two node SQL 2008 cluster and make it standalone on one of the node. Here is the infrastructure setup NodeA - SQL Default Instance on lies NodeA.NodeB  NodeB is already down and they want to remove the cluster completely and make node

asked 5/25/2015 3:45:39 AM
by Prasaanth
0 answers

Error message
  UPDATE [DBASQLOverview].[dbo].[tblSQL_Servers] SET skip_sql_Overview = 'True' GO   UPDATE [DBASQLOverview].[dbo].[tblSQL_Servers] SET skip_sql_Overview = 'false' Where servers = 'SQL1\DEV1' GO   SELECT * FROM [DBASQLOverview].[

asked 5/19/2015 2:53:36 PM
by John
1 answers

Transactional database or Data warehouse
I am designing a database for a Document Management application using asp.net MVC. This application will have a lots of Metrics for Reporting. Because of the metrics and the reporting I am thinking of designing the whole database as a DataWareHouse. I wan

asked 5/19/2015 12:29:45 PM
by Ebenezer
1 answers

Calulate Salary for one week at a time in a given month
I need to calculate provider salaries in a week that starts on Sunday and ends Saturday. If the calculated salary is <$455, then the total salary=calculated+($455-calculated salary). This seems to be straightforward until I found out that beginnin

asked 5/19/2015 2:02:13 AM
by Helal
0 answers

How to view .trn backup file Sql textment (not filelistonly)
Dear all, How to view .trn backup file  Sql textment  (not filelistonly)     Thanks & regards, Subhamay Chatterjee india

asked 5/15/2015 3:23:43 AM
by Subhamay Chatterjee
1 answers

Damage of the SQL database
Good day, friends! There is the following situation.  On one server, I make a backup of the database. With integrity check everything is carried out. Transfer the backup to another server and restore from it base, has also successfully completed. I

asked 5/13/2015 11:27:31 AM
by baldwin
2 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?


Free T-shirt



User Groups

Author of the Year

More Info








Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.