Can anybody provide the script for getting the sequence

Here is the code, hope this will be helpful

SELECT convert(varchar,convert(Money, colName),1)FROM tableName

Does the sequence not have any zero's in the rightmost position? for example, is 000010 in your sequence or is that skipped, like A00000?

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

the sequence has 000010.....999999

SELECT TimesheetKey, SiteKey, [Date],

SUMDuration = SUM(Duration) OVER(PARTITION BY GroupRule), GroupRule

FROM #TIMESHEET

Hi Judo,

Execute the below query, you will be getting the result as you said

CREATE TABLE #TIMESHEET(TimesheetKey INT, SiteKey INT, Date VARCHAR(10), Duration INT, GroupRule INT)

INSERT INTO #TIMESHEET...

The best practice is to create a Domain account for each service and use this account as a service account and run the services with these accounts.

Also for getting the...

Make sure that the server is in started state, also make sure that you have entered the correct server name on the server.