Here is a suggestion towards a solution

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

CREATE TABLE [dbo].[Table_1](

[Col1] [nchar](10) NULL,

[Col2] [nchar](10) NULL,

[Col3] [nchar](10) NULL,

[Col4] [nchar](10) NULL,

[Col5] [nchar](10) NULL

) ON...

Good question and a good case for using WITH SCHEMABINDING when creating a view.

😎

info 58414 (11/14/2016)

---

Hi,

How can I find all the rows of a database that have a particular pattern: for example: (INC000007615432) or with other words:

Find all columns in a Database, where...

wikus (11/14/2016)

---

Hi,

I would appreciate some help please.

I want to do a select distinct only on Col2 and add rows for those.

INSERT INTO Table_1(Col1, Col2, Col3,Col4, Col5)

SELECT DISTINCT Col1, Col2, 'ZZZ',...

IT researcher (11/14/2016)

---

I need to use SQL server 2008 because it' the latest SQL server which is supported in XP, there are many customers present who still uses the...

At the first glance, it looks like you are missing the second join specification for the ResourceGroupEnvironment table as the duplication is coming from that table (different VIP values), see...

Can you elaborate...

The first thing I suggest is to rewrite the WHERE clause to eliminate the conversion and concatenation, either change to an EXIST or JOIN clause.

😎

INSERT INTO [addb20].[Target_MergeAMD4_WithData].[dbo].[ConfigOption]

(

...

Can you post the DDL (create table) scripts for MAP, MAP_DAY and MAP_MONTH please?

😎

The document you are referring to is an...

gunadi.arunanto (11/13/2016)

---

Hi all,

Need advise for my error

Executed as user: NT AUTHORITY\NETWORK SERVICE. Arithmetic overflow error converting IDENTITY to data type int. [SQLSTATE 22003] (Error 8115) Arithmetic overflow occurred. [SQLSTATE...

s0da9 (11/13/2016)

---

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT...

xsevensinzx (11/13/2016)

---

Jeff Moden (11/12/2016)

---

To wit, I frequently go with the "no data warehouse" option in favor of just writing some streamlined code to solve actual problems instead of a system...

Ed Wagner (11/12/2016)

---

Eirikur Eiriksson (11/12/2016)

---

To me it looks like a Maintenance Plan related error, strongly suggest to switch to Ola Hallengren's SQL Server Maintenance Solution[/url], much more robust.

😎

Question, what if...

Jeff Moden (11/12/2016)

---

Indeed it has been. I've personally hidden about 100 spam posts in the last 4 to 5 hours. The bots...