Quick solution using FOR XML PATH and a nested query

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

create table dbo.Candidates(eno int,ResumeText varchar(30), Email varchar(30),Active varchar(30),postalcode varchar(30),country int)

;

insert into...

Go with Sean's method, no need to "materialize" the set and better chances of benefiting from the cache.

😎

You have a Windows 2000 Advanced Edition Server...

....and you have a serious problem:blush:

😎

PS this question looks to me like a Y2000 bug:-D

shreekanth.kavali (2/22/2015)

---

you received an alert "disk drive is almost full " for c drive "abc" server .what action will take and what all information you will provide for further action...

sk88 (2/22/2015)

---

Thank you so much. However, the declare function is giving me an error message

ORA-06550: line 1, column 9:

PLS-00103: Encountered the symbol "@" when expecting one of the following:

...

Further on Grant's, post the full and unedited output of "DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS"

😎

Quick note, this seemingly simple task may be slightly more complex than it appears to be at first. 😉 , i.e. in your data sample there are no updates to...

Jeff Moden (2/21/2015)

---

I guess my point is that while there is the difference in Nullability, an NC-PK isn't really going to have any I/O advantage over a Unique NCI as...

Quick trigger example, should be sufficient to get you passed this hurdle.

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

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

Quick suggestion (if I got the question right 😉 )

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE [dbo].[TBL_Group](

[Id] [int] NULL,

[Title] [varchar](100) NULL

);

IF OBJECT_ID(N'dbo.TBL_GroupProd') IS NOT...

Quick LAG window function solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_LOG

(

InfoDate DATE ...

TomThomson (2/20/2015)

---

Steve Jones - SSC Editor (2/20/2015)

---

I think that there shouldn't be any difference between a PK and unique index, whether CI or NCI, but perhaps there's some misunderstanding out...

Lynn Pettis (2/20/2015)

---

Ed Wagner (2/20/2015)

---

Lynn Pettis (2/20/2015)

---

SQLRNNR (2/20/2015)

---

Ed Wagner (2/20/2015)

---

Eirikur Eiriksson (2/20/2015)

---

SQLRNNR (2/20/2015)

---

Lynn Pettis (2/20/2015)

---

Couldn't post this morning, Internet was down for a long time due to a cut cable.

......

SQLRNNR (2/20/2015)

---

Lynn Pettis (2/20/2015)

---

Couldn't post this morning, Internet was down for a long time due to a cut cable.

... Mark one off, 8 days on the calendar to go. 8...

Quick thought, if the code is called very frequently then there will be a huge...