To flip 0/1 and vice versa:

UPDATE dbo.table_name SET column = ABS(column - 1)

and how will the OP create a non clustered...

• This reply was modified 3 years, 1 month ago by ScottPletcher.

Create a unique clustered index on ( TNR_DATE, GSN_ID ).  You can still have a nonclustered PK on GSN_ID alone.

If you prefer, just point the old name to the new table; you can, and definitely should, still continue to clean up the old name after that, but it should...

DECLARE @email_min_date_to_keep datetime;

/* only delete email older than 7 days; change the -7 to whatever number of days you prefer before running */

SET @email_min_date_to_keep = DATEADD(DAY, -7, CAST(GETDATE() AS date))

EXEC...

Review sysmail_event_log to get additional info on the error(s) that occurred in mail.

Sometimes you also want to look at sysmail_faileditems but that likely won't be helpful for the type of...

Drop the existing index.

Assuming that the column is datetime and not just time, create a clustered index on the datetime column.

It would be better to use datetime2 type to reduce...

Maybe try:

EXEC msdb.dbo.sysmail_delete_mailitems_sp

No problem.  Let me know if you need help on getting the correct job_id to add to the sysjobhistory table.

You can't restore an older version msdb over another msdb anyway, no matter what.

You could, however, restore the msdb db to a different db name (e.g. msdb_old).

I think you could...

It doesn't.  You're wayyyy over-analyzing this.  Again, it's a simple q with a simple answer.  Save the big analysis for a more significant q.

select T.*, T2.VAL

from @T T

outer apply (

select top (1) t2.*

from @T t2

where t2.ID <= T.ID and

t2.VAL is not null

order by t2.ID desc

) as T2

2.  If the value is a date only, use a date data type, period.

The OP said:

you want to search for all users who have an email "@gmail"'

The...

SELECT [FIRST_THREE_WORDS] = LEFT(ADDRESS + ' ', CHARINDEX(' ', ADDRESS + ' ', CHARINDEX(' ', ADDRESS, CHARINDEX(' ', ADDRESS + ' ', 0)+1)+1))

FROM ( SELECT '123 Main Street' ) AS...