It can be done but I agree with Lynn, kind of awkward doing this in SQL.

😎

DECLARE @IDMainCompany int = 100;

DECLARE @Process_Date datetime = '2014-01-01';

;With SalaryReport as (

Select...

Mail every minute and if it goes down then one can tell as the emails will stop:-D

😎

Sapen (8/22/2014)

---

Hello,

I have implemented transactional replication in sql 2012 with replicate schema changes. Now if I drop few indexes and add columns and re add indexes on articles in publisher...

Here is another suggestion on how to establish the grouping, the rest should be straight forward, select the last desired value from each group.

😎

CREATE TABLE #TEMP (T_ID INT IDENTITY(1,1),UserName varchar(20),Drink...

er.mayankshukla (8/23/2014)

---

I would not suggest you to use DBCC ShrinkDatabase, but should see the query which is creating this.

In one of my projects I observed such a behaviour when I...

Quick analysis

😎

First a simplified ERD

+--------------+ +--------------+ +-----------------+

|...

JeeTee (8/22/2014)

---

Wow, that works quite well. Given that I discovered some flaws in my post where I thought I had it with the quirky update, I'll try using this against...

Nita Reddy (8/18/2014)

---

I want to export one table but text contains ',' so can I use double " ? I don't see option when I select delimiter how should I...

Looks to me that it does what it says on the tin.

😎

Inspecting the filter, we find:

WHERE dp.class < 4

Listing permissions for

0 = Database

1 = Object...

Quick suggestion, look...

Here is a quick solution using CHARINDEX

😎

USE tempdb;

GO

CREATE TABLE [dbo].[x_JobMatching](

[CVID] [int] NULL,

[JobNoticeID] [int] NULL,

[isMatch] [bit] NULL,

CONSTRAINT [x_JobMatching_UQ1] UNIQUE NONCLUSTERED

(

[CVID] ASC,

[JobNoticeID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE =...

Luis Cazares (8/22/2014)

---

Note that you might replace strings you don't want them to be replaced.

INSERT INTO @test-2(TEST_STRING)

VALUES

('I am a bad Gal')

,('I am a good Gal')

,('Oh my goodness! There''s no...

Are indexes not ANSI compliant?

😎

Lynn Pettis (8/22/2014)

---

Eirikur Eiriksson (8/22/2014)

---

Nice to see that you are having a friendly chat...

Nice to see that you are having a friendly chat with your best pal:w00t:

😎