neliii (5/7/2010)

---

column1

\\xyz.se.df.a.b\fgd

colum2

\\xyz\fgd

now i want to join both the coulmns by elimating the highlighted part. i mean .se.df.a.b

or else just give me the query which can elimante that part from that...

AND ASV.booking_date > DATEADD(Day, DATEDIFF(Day, 0, GETDATE()), 0)) --...

@subject = N'Hot Items out of Stock',

DECLARE @query varchar;

should be

@subject = N'Hot Items out of Stock'--, <== Remove this comma

DECLARE @query varchar;

show what you have so far, and the actual error.

Case <column> when <value> then <value> else <value> end as <Alias>

I found this searching SSC

WO.PART_ID LIKE '% RTN' AND

Is the space always before the RTN?

I certainly would not WANT to do it that way, however, it seems to fit the rules. being it was an interview, I would not expect they run into...

Perhaps I do not understand fully the situation, but, you can make no changes, but must add the constraint...

WITH NOCHECK ?

what is the error you are getting? "its not working" seems a bit vague.

just a hunch, stop the service (ctl break if the window is still up, or...

good catch, I missed the "instance" key word. 😀

USE [master]

GO

ALTER DATABASE [<Your DB Name>] SET READ_WRITE WITH NO_WAIT

Is that what you are looking for?

it may be time to read your text book. These are classic examples from class.

If you really want help, provide the table structure, some sample data, and expected...

CREATE TABLE #temp

(id int, sal int)

INSERT INTO #temp VALUES (1,20000)

INSERT INTO #temp VALUES (2,40000)

INSERT INTO #temp VALUES (3,60000)

INSERT INTO #temp VALUES (4,70000)

INSERT INTO #temp VALUES (5,80000)

INSERT INTO #temp VALUES (6,90000)

UPDATE...

check out DB_NAME())