Sharon

Have you read 'Robyn Page's SQL Server Cursor Workbench' on Simple Talk? http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-cursor-workbench/

It gives a pretty similar example, the 'running Total' problem. The 'Quirky update' approach seems to work...

I expect there is some VBscript code somewhere that shows how to do it, but I don't know of any existing TSQL that does it

There should be enough examples in...

It should be possible. You don't quite explain why you can't do it. You'll need to tell us because otherwise we have to guess. Have you looked at...

If you simply want to add a role to 200 (or so) servers using sp_addRoleMember, then you'll find that SQLCMD will do this very easily for you. It will also...

I tried the two techniques on a table of a million rows. Michael and Jeff are correct in that the DateAdd/DateDiff routine is a lot faster, but even on my...

Michael

Your code produces correct results, but I have found in testing that doing this by converting to strings and back to datetime is a much slower method that using the...

[font="Courier New"]--1) How to find out the current month's first Date ?

SELECT CONVERT(DATETIME,'01 '+RIGHT(CONVERT(CHAR(11),GETDATE(),113),8))

--2) How to find out the current month's Last Date ?

SELECT DATEADD(DAY,-1,'01 '+RIGHT(CONVERT(CHAR(11),DATEADD(MONTH,1,GETDATE()),113),8))

--3) How to find out...

Yes, this is really too broad a subject for a forum, but here are a few thoughts....

I'm an old fogey who finds the many development and debugging aids for SQL...

Your friend should have read Robyn Page's Date/time workbench[/url] before the interview

A typical problem I've had to face in the past might be that I've got a million or so rows of data from a switch that have to be imported....

I really enjoy these XML workshops.

Of course, the parsing of delimited data is an important issue for data feeds. If data can be converted into XML first, using AWK...

I couldn't agree more with Jeff. I really enjoy solving problems if they are well presented, and loathe doing so if the problem is badly expressed. What irritates me is...

OK except for a daft problem, which is that the B***ding forum software sees the & # 1 6 0 ; & # 1 6 0 ; ) (without the...

This solution assumes a big table lots of new data coming in. It also assumes that all have got the MSD prefix which I could be wrong about. if it...

[font="Courier New"]USE MyDB

SELECT name, filename FROM dbo.sysfiles[/font]