Paul

Please will you show us the results of this query?

SELECT
    name
,    size/128 AS SizeMb
,    growth/128 AS GrowthMB
,    is_percent_growth
FROM MyDB.sys.database_files

John

Have you tried this?

John

WITH ConverttoNumber AS (
    SELECT
        ID
    ,    CAST(LEFT(ID + '000',4) AS int) AS Nbr
    FROM StgTemp
    )
SELECT DISTINCT ID
FROM ConverttoNumber
WHERE Nbr BETWEEN 3500 and 3999
OR...

Cast to int and then it's simple to find values that fall in a certain range.

John

Phil is right - it would be a lot easier you you could change to a normalised table design.  If you're stuck with what you have, though, you can do...

Cast as something like decimal(7,2).  Don't take my word for that, though - make sure you read and understand the documentation about the decimal data type.

John

There are scripts out there that will help you with stuff like this.  Search for something like "query for tables in dependency order".

John

Yes, it's very confusing!  How does that stored procedure get invoked?  It won't just run by magic when something changes,  And don't forget - it's not the view that changes,...

Do you have any control over the structure of the ssf_widget_history table?  If so, why not just put an identity property on the checkpoint_id column, and let the table do...

Stephen

The only other thing I would say is that you need to explain to whoever owns the server that if they want you to manage it, you need...

UPDATE Timesheets
SET Timesheet_Number = STUFF(Timesheet_number,1,4,'HPCD')
WHERE Timesheet_Number LIKE 'EPCB%'
Make sure you understand what the STUFF function does before you use this in production.  You're the one...

Stephen

Yes, the advice from the previous DBA is good.  What I would do is speak to users to find our excatly what they're doing when the application is...

Also, syscomments.text is confined to 4000 characters, so large stored procedures and functions will get cut off. If the database name reference is past character 4000, you’re out...