Post the error message that you are receiving

Also it would be better if you post some sample data along with the DDL and the expected results

This will help us in...

I think what you need is a string splitter

Please check the article below for reference

http://www.sqlservercentral.com/articles/Tally+Table/72993/

In the final output of the query, I see that an entry has been deleted for employee no as 3 well

Can you explain the logic behind that deletion?

AIRWALKER-375999 (4/26/2012)

---

Thank you all for you're assistance, I think I'll need to redesign the query as what I want do I dont think is possible within a case statement, I...

We normally assume it to be SQL Server 2005 as you are posting it in the 2005 forum

Please provide the DDl, sample...

The DDL along with some sample data will immensely help us in providing a tested solution

Please check the link in my signature on how to do it

m.eissa85 (4/25/2012)

---

I don't think that case work in where clause, But I didn't check it. You can rewrite the condition as following:

My query is

DECLARE @var AS VARCHAR(4)

SET @var =...

My brain cells didn't have much work today in office. Hence, its still fresh 😀

Glad to help you out 🙂

You will have to handle these dates separately

You can't convert them to "2011-02-29" or "2010-02-29"

Just a shot in the dark

Check if you have any date like 29th February in your table

SELECT * FROM dbo.Test_Data WHERE DAY( service_date ) = 29 AND MONTH( service_date )...

This should help..

DECLARE @var AS VARCHAR(4)

SET@var = 'TST2'

SELECTCol5, Col6, Col7

FROMTableName -- You missed the TableName

WHERECol7 = 'A'

ANDCol6 = 'S'

AND1 = CASE

WHEN @var = 'TST1' AND Col1 = 0 THEN 1

WHEN...

vinu512 (4/25/2012)

---

Suppose, I have this DDL and Sample Data:

--DDL

Create Table Ex(Name varchar(30) )

--Sample Data

Insert Into Ex

Select 'Jack'

Union all

Select 'Vinu'

Union all

Select 'Jim'

Union all

Select 'Stan'

Union all

Select 'Ash'

I want to loop through the...

manoj_lanser (4/25/2012)

---

I want to see the insert script used along with the data that is used in the creation of that table.Can you please

write any query or procedure for...

vinu512 (4/25/2012)

---

I am a big fan of Dwain's Signature - No Cursors! No Loops........

I definitely know that Cursors are poor performers and should be avoided.

But, what if there is a...

Please post the complete query and the exact error message that you are receiving

The query you have provided is not enough.

You are declaring "@MyColumn" and using "@AddItemVal" and "@Myval" which...