abhas (11/10/2016)

---

Hi Friends,

Thanks for your suggestion mhtanner and MMartin1 but client want this implementation only.Explained issue but they want like that only. 🙁

Thanks again Eirikur for your help....

andy.plumb (11/10/2016)

---

Hi all

This is my first post here, so hello to you all!

I have a SQL 2008R2 server, which I have created various DTS packages to import data for an...

GilaMonster (11/10/2016)

---

Eirikur Eiriksson (11/10/2016)

---

Yes you can....

Yes you can. Run this command...

Sangeeth878787 (11/10/2016)

---

Hi,

I have a table with date column and primary key column with auto increment, but few times we have been come across these tables not populated with new data...

What is the fill factor for the index?

😎

Henk Schreij (11/10/2016)

---

I wish 🙂

I get the parameters from a outsite source: the people who build the website.

I have some influence...

21.naved (11/9/2016)

---

Executed as user: DAQMSDBS01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started:...

Here is a very simple method that first tries to truncate the table and if that fails, then it deletes all rows from the table.

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.AllTables') IS...

Benki Chendu (11/9/2016)

---

He he. I know they are very vast.

But my question is very vague 🙁

If I want to provide some visualizations or dashboards to my customers and want to...

whitesql (11/9/2016)

---

Hi!

I need to delete all tables listed in a table named dbo.tblSum. There are 500 tables that I need to delete.

I am not sure on how to do that...

quinn.jay (11/9/2016)

---

Hello, I have a cube that been deployed to production, but only processes and loads jan16 - jun16 data, even though jan16 - nov16 data is available. I have...

Jeff Moden (11/8/2016)

---

drew.allen (11/8/2016)

---

The files are processed in alphabetical order. If you follow the naming convention of having a fixed filename prefix with a timestamp suffix in YYYYMMDDHHMMSS order...

Newbi (11/9/2016)

---

I am not familiar using function and the parameter is already inside the function.When I call the data inside my C#, it is throwing error and unable to run....

A CASE statements needs to be terminated with the END keyword

😎

-- Syntax for SQL Server and Azure SQL Database

Simple CASE expression:

CASE input_expression ...