currently this row has three columns, one of the column could or could not have the value with comma delimited value, so i would like to parse this column, then...

thanks all

Incorrect syntax near '.'

when i do select dbo.GetEvdate ('xxxxx'), it return value correctly.

but when i do exec test '1111', dbo.GetEvdate ('xxxxx'), get syntax error.

thanks

the SP doesn't return value, i try to create a table inside the SP and insert value, the function return a date, and i want to pass this to the...

thank you both

sorry for the confusion.

Management Studio provided the overall server info, we don't want anyone be able to access it. Some persons just need to know the database structure, and...

Hi,

I have the same warning. The package i try to create is export data to excel sheet. one of the column is sql_variant. Failed.

Can someone help?

thanks

I tried this but it gives me error Number is invalid table

no, it varies with the length

so how to retrieve the middle value, e.g. A104 and A101

thanks

can you tell me what tally table is? thanks

some other option

DECLARE @string varchar(200)

SET @string = ',B110,A104,AUSL,'

SELECT

REVERSE(SUBSTRING(REVERSE(@string),2,CHARINDEX(',',REVERSE(@string),2)-2))

SET @string = ',L101,A101,01,'

SELECT

REVERSE(SUBSTRING(REVERSE(@string),2,CHARINDEX(',',REVERSE(@string),2)-2))

yes,

here is the pattern we have, i need to retrieve the right most field

,,,01,

,,,01,

,B110,A104,AUSL,

,B135,,DEN,

,,,03,

,,,AZ,

,,,MALA,

,,,BUR,

thanks

i did "restore verifyonly ", return "the backup is valid", does that enough to tell the backup is good to restore?

if the error has been ongoing for a while, will the backup still valid? how to verify that? thanks