Using the example provided previously something like this would work too.

CREATE TABLE #tmp

(ID int primary key)

INSERT INTO #tmp

VALUES

(1)

INSERT INTO #tmp

VALUES

(2)

INSERT INTO #tmp

VALUES

(3)

INSERT INTO #tmp

VALUES

(5)

INSERT INTO #tmp

VALUES

(9)

INSERT INTO #tmp

VALUES

(10)

INSERT INTO #tmp

VALUES

(11)

INSERT...

tburk 5368 (5/14/2012)

---

I tried the loop and it cleared out the whole field and not just the ascii characters. i wrote it into a function

CREATE FUNCTION [dbo].[ReplaceCharacters] ( @InputString...

tburk 5368 (5/14/2012)

---

I tried the loop and it cleared out the whole field and not just the ascii characters. i wrote it into a function

CREATE FUNCTION [dbo].[ReplaceCharacters] ( @InputString...

Hollyz (5/14/2012)

---

How do i alias a Exists subquery?

select TOP 1000

E.[Last Name]

, E.[First Name]

, E.[Department]

, Support.[SupportLvl]

FROM Employee E

Where exists (select * from Support

...

Can you try to explain more clearly what you are trying to do?

Start with reading the first link in my signature. It explains how to best post questions in order to receive an answer.

hhmmmm I suspect this is not really what your view definition looks like. I have a feeling this is pseudocode for what they are doing. If you really want help...

themangoagent (5/11/2012)

---

Jeff Moden (5/10/2012)

---

Didn't look to see if it was mentioned before but one sure fire way to increase the performance here would be to use UNION ALL instead of...

Yeah this certainly does have the feeling of fixing the symptom instead of the problem.

annastassia1935 (5/11/2012)

---

Thank you Sean. It is a nightmare. I posted to get a replies from reputable professionals to show my client. The client has data modeling training...

The [lab_seq] column is updated within the code using the array index. A decision was made years ago to DELETE and INSERT as a way to update the data from...

komal145 (5/11/2012)

---

hi ,

Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)

values ( 91,5, 'Indexing',2012-04-23 15:51:53.177,asdf,asdf,2012-04-23 15:51:53.177)

Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)

values ( 91,4, 'Intake',2012-04-23 15:51:53.177,asdf,asdf,2012-04-23 15:51:53.177)

Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)

values ( 298,5, 'Indexing',2012-05-05 23:31:22.660,asdf,asdf,2012-04-23 15:51:53.177)

Insert...

Lynn Pettis (5/11/2012)

---

Sean Lange (5/11/2012)

---

This pretty simple but I am rather swamped at the moment. If you post ddl and insert statements I can knock this out in a couple...

Lynn Pettis (5/11/2012)

---

Sean Lange (5/11/2012)

---

Lynn if you keep providing answers there is no incentive for the posters to provide the details for you. They will just learn that you will...

This pretty simple but I am rather swamped at the moment. If you post ddl and insert statements I can knock this out in a couple minutes. I just don't...