You can use a Look up table for the same

DECLARE @tblDays TABLE

(

DayName VARCHAR(20),

DisplayName VARCHAR(20)

)

DECLARE @tbl_Data_Table TABLE

(

...

Victor Shahar (10/20/2010)

---

Hi,

Assuming that you use the auto statistics create & open and have all the statistics updated well, i think that it will be better to read from the...

skcadavre (10/6/2010)

---

Kingston Dhasian (10/6/2010)

---

Normally formatting such as these is done in the front end. Anyways this should help you out

SELECT CONVERT(varchar(12), WDate, 103) + ' ' + CONVERT(varchar(28), WDate,...

Removed as the solution was incorrect..

Please provide the complete code of the function and the syntax error you are getting.

Meanwhile the BEGIN...END in the below part of your function looks suspiscious

IF (@param1 null and @param2...

The OUTPUT parameter will allow you to use...

You can use sp_executeSQL for the same

DECLARE

@Count int,

@Query nvarchar(300),

...

UMG Developer (9/29/2010)

---

I think you need to check the answer key for this question. It lists "Column references can pull data from multiple rows." as one of the options you...

You probably have some data in your column clean_name1 which is like say 'John is a DBA '. In this case you will get the value for len(clean_name1)-(PATINDEX('% DBA %',...

Ali Tailor (9/17/2010)

---

Hi

Joe

If U find the things in Ur Pocket, why ask to another? First check Ur pocket (SQL BOL) please, the forum's expert not free for answer a silly...

Please provide the query you are running. What was the result you got from the query i gave you?

DECLARE @tbl_Tutor TABLE

(

TutorID INT,

TutorName VARCHAR(100)

)

DECLARE @tbl_Subject TABLE

(

SubjectID INT,

SubjectName VARCHAR(100)

)

DECLARE @tbl_TutorSubject TABLE

(

...

subbusa2050 (9/6/2010)

---

Ya ofcourse, as i said i need to fire the trigger wthen the opportunitybase table is inserted. So wats ur point ? ?

I need to get the INSERTED...

You have defined a trigger on table OpportunityBase for...

Since you are doing only an INSERT, there will be values only in the inserted table and there will be no values in the deleted table. deleted table will have...