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 >>

How to transfer XML files from folder to another folder with a new name change using SQL 2008.
Hi,   Hope someone could help me on this.   Problem: I have an SQL jobs that gets the XML file  from specific folder and transfer to database. However if that XML file will come in bulk. I'm thinking if how can I transfer all of that u

asked 7/9/2015 10:16:56 PM
by Jay Lorca
2 answers

How frequently are system tables in SQL updated
Hi   I recently came across a tip in which we can find the number of rows in a table from sysindexes aystem table. I want to know how frequently is it updated. Are all the system tables up to date all the time   Regards, Harini

asked 7/9/2015 7:41:33 AM
by Harini
2 answers

Multiple Data Sources for Single SSAS Database
What is the right approach and the best way to describe the solution to this problem: multiple, identical schema, application datasources from a line-of-business-application, spread around the globe corporate need for analysis and reporting at HQ SSA

asked 7/7/2015 2:31:05 PM
by Martin Daniel
0 answers

Suscriptions mhtml problem
hello could help me, I have a problem with the signing in MHTML format, because if I have a small board sends it but if it is large not provided, I can modify these properties ? Thank you for your help  

asked 7/6/2015 11:55:09 AM
by Victor Paz
0 answers

SSRS Rendering Extention PPTX
Hello, On reporting services is the ability to view reports on multiple rendering format except for PPT / PPTX. Looking at the net there Aspose.Slides the tool does good apparently, but that is not free. So I saw that there was the possibility of developi

asked 7/6/2015 4:36:33 AM
by Aurelien
0 answers

Rows to Columns
i have the below text in one column i need to split it to mutiple columns the belwo script is not working     SELECT Name, Date_Start, Time_Start, Date_End, Time_EndFROM (  SELECT Calendar_Data FROM dbo.Calendar_Data) Calendar_DataPIVO

asked 7/3/2015 8:45:21 PM
by Ikrami Sami
0 answers

Control flow statements in Where clause
I am fetching data from a table on the basis of few parameters which are used in a where clause for filter criteria. The Parameters are number of days and customer name (@days and @customer name). Below are the things which I want to achieve.   1)

asked 7/2/2015 5:57:41 AM
by Vipinkumar Mishra
1 answers

A SQL expression which can compile a logic through a condition.
Hi Experts,   I am starter in SQL! Task: I have a requirement to Generate the Invoicing log errors (SAP ISU)  Table: ETRG , Dimension: ANLAGE(Installation) and   Key Date : ABRDATS(Schedule Billing Peroid) lOGIC---->  To retrie

asked 6/30/2015 9:10:44 AM
by bhanu chandar dake
0 answers

suppose restoring database was corrupted how to recovery it

asked 6/29/2015 2:48:23 PM
by rao
1 answers

Find Duplicate Clients based on Last and First Name
Hi all, I need to be able to find duplicate names (Last and First) to prevent entering duplicate records in a Client table. I was looking at the SOUNDEX() function, but in many post they say it is not recommended to use.  Is there any other MS-SQL

asked 6/29/2015 11:16:08 AM
by Edhy Rijo
0 answers

Stored Procedure is confusing, help!
I inherited this stored procedure and I am having issues figuring out exactly what it is doing after it is reassigning the ID. Any input is appreciated. CREATE PROCEDURE [dbo].[Delete_my_Content] @user_id as varchar(255),     --U

asked 6/26/2015 9:35:30 AM
by Jenna
0 answers

SQL Server 2014 merge replication throws PRIMARY KEY violation during the initialization of Subscriber
I am using SQL Server 2014 SP1 to set up merge replication on Windows 2008. The databases (Publisher & Subscriber) are restored from the production back up of SQL Server 2005 publisher database. The merge replication set up on SQL Server 2005 works f

asked 6/25/2015 1:07:18 PM
by Isaac
1 answers

Need to script out a sql job using t-sql or stored procedure
HI  Can any one help me in scirpting out all the sql jobs using t-sql    Regards Sandeep

asked 6/25/2015 6:05:50 AM
by Sandeep
1 answers

Query with Object types mentioned
Hi, I used your below query to make a dependency report, but I need to include object type as well. Could you please help how to modify this query for the same: --------------------------------------------------------------------- WITH DepTree (referen

asked 6/25/2015 3:24:59 AM
by FK
1 answers

SQL query behind an SSAS datasource view
Hi,   Is there a way to get the SQL query behind an SSAS datasource view?   Thanks, Bryan

asked 6/25/2015 12:57:46 AM
by Bryan
0 answers

SSIS Package with dynamic source and multiple tables in each source and dynamic staging
Hi Guys, I have to import multiple table from different servers and once I import it should load to my target table but first my package should create a staging table for all those target tables and then load into target table from staging. Now when I ru

asked 6/24/2015 6:35:25 AM
by Rajeev Kumar
1 answers

agregar observaciones/comentarios en tablas de sql server 2008
Buena tarde, se me ocurrio agregar comentarios u observaciones en algunas tablas de sql existe una forma de agregar mis comentarios en algunas tablas 

asked 6/23/2015 5:45:00 PM
by fernando
0 answers

Want to hide the Database Structure, Schema & Objects In SQL Server & SQL Azure
Hello All,  I have a secnario in my project, we are in process of developing a tool & sell to customers , in this i want to hide the database schema & structure to the client & Clients DBA is there any solution in it from the database en

asked 6/23/2015 1:47:51 AM
by Chandru Shekar
0 answers

Divide Total Rate by Number of Records
my table includes detailed records with total Rate repeated in each record:   CREATE TABLE Table1 ( Providerid varchar (6) NOT NULL, Providername char (30) NOT NULL, Clientid varchar (15) NOT NULL, Rate            

asked 6/22/2015 3:23:07 PM
by helal
0 answers

Error event id : 17066 and 3624 while restoring Diff backup.
Hi Friends,   I am getting the following error while restoring the Diff back up after restoring the Full backup in Norecovery mode.   I am unable use dbcc checkdb as the database in restoring db.   Issues happens only in three instanc

asked 6/21/2015 9:02:19 AM
by Swami
0 answers


 
Sponsor Information






 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

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