imba (1/13/2016)

---

Hello,

I am in need of some assistance. I have a column that have values that look like this:

111#222#33333#44#555#66

The length of the values can change. I...

sushantkatte (1/13/2016)

---

I want to select getdate() in the format yyyy/M. i tried to write a query as SELECT FORMAT(GETDATE(),'yyyy/M') but it is giving me error.I am a beginner in sql....

Eric M Russell (1/13/2016)

---

But an INSTEAD OF DELETE trigger will prevent anything (users, stored procedures, the DBA) from completing delete operations on the table. Is that what you really want?

If...

Don't do this, the rollback is neither needs...

Quick example

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_TEST_DELETE_TRIGGER

(

TDT_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_DBO_TBL_TEST_DELETE_TRIGGER_TDT_ID PRIMARY...

Hugo Kornelis (1/13/2016)

---

You probably have users that have dbo rights. Those bypass all security checks. (Or users do the deletes through stored procedures that are owned by the table owner,...

Quick untested guess

😎

SELECT DISTINCT t1.ProjectUID,t1.BWF , t1.Deliverable ,

--Supressed data columns

STUFF(

(SELECT DISTINCT ', ' + (t2.[GeoMarket])

FROM #deploys t2

where t1.ProjectUID = t2.ProjectUID AND t1.BWF = t2.BWF AND t1.Deliverable = t2.Deliverable

FOR...

monilps (1/13/2016)

---

I am sorry about that, later on I just realized it. I will be careful next time.

Didn't meant to waste anyone time.

No, this is similar but not the same....

monilps (1/13/2016)

---

Hi,

I have updated below table:

Col1Col2 Col3 Col4 RowNumber

123AX ...

monilps (1/13/2016)

---

Hi,

I have below table:

Col1Col2 Col3 RowNumber

123AXC 12/1/2015 1

123AXCVV 12/1/20152

345XSW 12/5/20151

345XSW-SE12/5/20152

567ERW ...

Fáfnir

SQLRNNR (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time....

Jeff Moden (1/13/2016)

---

Even with this, you still have a bit of the "mouse guarding the cheese". The only true method of knowing how many rows should be in a...

Steve Jones - SSC Editor (1/13/2016)

---

I think you'd need a separate process that counts rows, knowing what a "row" is in the file format as a

delimiter.

You can look for...

How big are these files? One option is to load the file into a variable using t-sql and openrowset, then count the lines by comparing the length against the length...