This might come in handy then, SQL Server Data Tools 16.4[/url]

😎

This is well within the limits of using a script file, assuming that the actual data isn't too large and that the end customer can unzip the script file;-)

😎

Additions and...

Close all connections to the server and do the changes via sqlcmd, don't use SSMS

😎

The command is

EXEC sp_configure 'user connections', 32767;

Minnu (11/9/2016)

---

I have two tables

Dept table with 8 records

Logins table with 23 records

below query should display 31 records, but it is displaying 184 records (8*23=184).

i want below query to display...

If the database is small then my choice would be to provide scripts to create and populate the database.

😎

Question, will you at any stage have to update or refresh the...

sqlenthu 89358 (11/9/2016)

---

Hi Guys, I am working on an email alert to be sent to customers along with some information on monthly basis. The format of this mail should be...

You will have to use dynamic SQL, here is a quick example

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @COL01 NVARCHAR(MAX) = N'COLUMN_01';

DECLARE @COL02 ...

You can use sp_changedbowner...

Sometimes I use this ad hoc method which is very simple but works like a charm

😎

First a staging table

IF OBJECT_ID(N'dbo.TBL_FLAT_FILE_IMPORT_STAGING') IS NULL

BEGIN

CREATE TABLE dbo.TBL_FLAT_FILE_IMPORT_STAGING

(

FFIS_ID ...

You are very welcome.

😎

Here is a brilliant article on the subject,...

Quick suggestion, unpivot the rows and apply the row_number with a partition on the ID

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.tblHierarchy') IS NOT NULL DROP TABLE dbo.tblHierarchy;

CREATE TABLE [dbo].[tblHierarchy](

[ID] [int] IDENTITY(1,1) NOT...

There can be more than one reason for this error, ie. wrong path specified, insufficient permissions, destination marked read only or not enough space at the destination.

😎

abhas (11/7/2016)

---

Hi,

Thank you so much Eirikur and David.

Really appreciate your efforts. Its working as per requirement.

Only one issue - when same firstName and LastName comes then creating only one...

You are very welcome.

😎

Does the query use DISTINCT?

😎