the above solution is correct if you want to go with and maintain data integrity with normal forms.

but there are scenerios where in due to some constarints you are unable...

really a nice solution:-)

something like this:-

SELECT SUM(UnitPrice)

FROM

(SELECT TOP 3 UnitPrice FROM Sales.SalesOrderDetail

ORDER BY ModifiedDate DESC )t

wat wa sthe solution to overcome the problem?

Please share.

alright.. so here you go..

I gotthe solution though while I was creating this test data. but this is just for the refrence for everybody who visited the post and merely...

well i tried that also it didnt work

what i noticed after an hr of R&D is

select * from email_history_log ehl (nolock)

join email_history ehe (nolock) on ehe.message_stub = ehl.message_stub

join survey_email_history ehs...

Why the use of variables explicitly?

whats the benifit of using variables?are the two different in performance?

The one which u are using is a global temp table Global temporary tables are visible to any user after they are created; and they are deleted when all users...

genarally the dbcc shrinkfile command is use only to shrink the files when desried... say suppose the file length > 1GB(eg)

thanks all this has been done.

I used xp_cmdshell 'del....' command

🙂

Because thats the approach I have been asked to work,

Earlier we used Maintenance Plan but now we have our own script and to delete old backups also I need...

No I m not using Maintainence Plan I have a generic SP that creates backup so I need another SP to delete the old files which are of no longer...

thnksss for the help 🙂

well actlly sorry for not explaining that properly i mean # of characters like fro instance the string is :--

SQLSERVER

result sholuld be like :--

S-2

Q-1

L-1

E-2

R-2

V-1

string is nvarchar..

well thats a pretty long SP for this....

it basically processes the stuck elements in the queue.

confidential types soorrryyyyy 🙁