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



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?




User Groups

Author of the Year

More Info








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