I just ran your code, it is displaying "SQL Server"

what do you want in your output?

Yes, Check with enabling Integrated Windows Authentication and Anonymous access also try Inherting Security Settings from parent thru Permissions wizard

use

DayField < CONVERT(VARCHAR(10),GETDATE(),101)for correct results

Use EXECUTE sp_executesql @sql

Instead of sp_executesql @sql

Most of the times, problem is with not configuring IIS Security settings properly.

First of all check those settings in IIS

Thank you:-)

Could you please provide the solution

Try this

WITH RecCTE AS

(

SELECT Convert(VarChar(30),i) i FROM T

UNION ALL

SELECT Convert(Varchar(30),t2.i+','+t3.i) as i FROM T T2

CROSS JOIN RecCTE T3

WHERE t2.i<>t3.i AND t2.i<LEFT(t3.i,1)

)

SELECT * FROM RecCTE

ORDER BY LEN(I),i

Check this

I would like to present a different solution for this kind of problem

Requirements:

1. Set of "ALTER VIEW" scripts for all views exising in each database placed in different folders

2....

Agreed..

There is no need to use REVERSE in LEN function.. its silly

may be just ignored it.. honestly never thought about performance:hehe:

use a DATEPART function to determine the dayofweek and use CASE statement to act accordingly

something like this

(EXPC_SHIP_DATE =CASE DATEPART (dw, GETDATE())

WHEN 7

THENCAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME) + 2

WHEN 6

THENCAST(FLOOR(CAST(GETDATE() AS...

Another version, assumes that data should be removed after last delimiter

CREATE TABLE TTT

(

ID INT IDENTITY (1,1) NOT NULL,

...

I dont know about your requirement, In case If you are OK with ignoring the data which exceeds the TypeCode length.

Here is your update statement

DECLARE @tblDrawings TABLE ( SheetNumber VARCHAR(50),...

Solution using Cursors

------------------------------

CREATE FUNCTION dbo.ParseList

(

@ValueList VARCHAR(8000)

, @Delimiter VARCHAR(1)

)

RETURNS @ParsedListValues TABLE ...