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

Reallocation the rows
I need to change data in picture 1 to be like picture 2   (1)     (2)    

asked 7/4/2015 12:14:58 PM
by Ikrami Sami
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

*** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotghjkePad before copying the code below to remove the SSMS formatting.

asked 7/3/2015 6:11:08 AM
by dcfvgb
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
0 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
0 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
0 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

How to allow three types of parameter input (blank, one, multiple comma separated)
Hi I am having some trouble with my Microsoft SQL Server Report Builder. It is a simple matrix report with one dataset for the output and one parameter for the input. I’m trying to allow three different types of data input into my parameter: 1. 

asked 6/18/2015 7:19:04 PM
by Ryan
0 answers

Insert records performance to SQL server table
If I have a tabel with millions of records and another table has empty records I like to insert 3000 records into both table which one will be faster insertion ?and why will be faster ? I am confuse about that please answer me .Thanks

asked 6/17/2015 3:04:31 PM
by Ziaul
1 answers

Take a backup of sql jobs (Scheduled Jobs) through TSQL
I have 5 servers, i am creating a scenario if one of the server is down then I can restore the database and run the jobs in another server. Through scripts I am taking the database structure(table, views and storedprocedure) of all server and maintaining

asked 6/17/2015 8:35:50 AM
by mahesh
1 answers

Sponsor Information