John Mitchell-245523 (11/14/2016)

---

Eirikur Eiriksson (11/14/2016)

---

John Mitchell-245523 (11/14/2016)

---

OK, this query will look at all columns with data length of 15 or more and show the number of values with the requested...

Here is a query I often use, adjusted to this requirements

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @PATTERN NVARCHAR(MAX) = N'INC[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]';

DECLARE @SEARCH_TEMPLATE NVARCHAR(MAX) = N'

UNION...

John Mitchell-245523 (11/14/2016)

---

OK, this query will look at all columns with data length of 15 or more and show the number of values with the requested pattern. Beware that...

You are very welcome.

😎

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