Crystal Reports has a crosstab object that was specifically designed for this type of operation. It's MUCH, MUCH easier to do this Crystal than in T-SQL.

Drew

Here are two different ways to do it.

DECLARE @dateString DATETIME

SET @dateString = '2012-04-05'

SELECT @dateString,

CASE WHEN DATEPART(DAY, @dateString) < 10

THEN STUFF(CONVERT(varchar(10), @dateString, 103), 1, 1, '')

ELSE CONVERT(varchar(10), @datestring, 103)

END

,RIGHT(CONVERT(varchar(10), @dateString,...

While it's possible to do this in T-SQL, it's not the best tool for the job. Without knowing how you are planning to use these results, it's difficult to...

It sounds like you just want a count of the attributes. If that is the case, you don't need the string splitter.

SELECT SUM(LEN(SelectedAttributes) + 1 - LEN(REPLACE(SelectedAttributes, '|', ''))

FROM...

Your design is fundamentally flawed. You're trying to use your stored procedure like a function. Here is what Microsoft has to say on the issue.

Stored Procedure Basics

---

Stored procedures...

You're essentially doing a pivot or crosstab and using any kind of join is an inefficient way of doing that. The following should get you what you need. ...

I've come to the conclusion that he's not really interested in answers. He's only interested in monopolizing...

That's not quite accurate. The foreign key only needs to reference a unique key, it does not need to be the primary...

You already have another thread on this same topic. http://www.sqlservercentral.com/Forums/Topic1281058-392-1.aspx You didn't get the answer you wanted there, because you didn't provide the requested information. Starting a new thread...

pathankhan (4/12/2012)

---

I can create only one foreign key constraint from Lookup_Country to Person_Information table but I have three columns that I need to setup referential integrity for... Is there any...

xenophilia (4/11/2012)

---

when i run this:

SELECT Distinct Outcome

, TestNo

, SUBSTRING(RIGHT('SuitePath',DATALENGTH('SuitePath') - 1),1,PATINDEX('%\%',RIGHT('SuitePath',DATALENGTH('SuitePath') - 1)) - 1)

from testsuite

i get this error

Msg 536, Level 16, State 1, Line 1

Invalid length parameter passed to...

Since the PATINDEX presumably includes a LIKE, it's bound to be less efficient. This is borne out by a comparison of the stats.

LIKE

(8 row(s) affected)

Table 'XXXXXXXX'. Scan count 1,...

SELECT *

FROM YourTable

WHERE YourField LIKE '%[^A-Z0-9]%'

Drew

In that case, the answer you are looking for is here.

Drew

No, @ stands for the beginning of a variable/parameter definition. '@' may stand for group, but not @.

i have group name item3 ,which i am...