you can also use the dateadd/datediff functions to strip to the hour, and still keep the value as a datetime instead of a varchar.

select DATEADD(hh, DATEDIFF(hh,0,getdate()), 0) --2015-09-04 10:00:00.000

i just built this example from my notes about adding align in xml.

this quick example seems to generate valid xml/html snippets, using inline styles.

i would do as suggested and use...

this is working for me:

Import-Module ActiveDirectory

Get-ADGroup -Filter {Name -like '*SQL*'} -Properties * | select -property SamAccountName,Name,Description,DistinguishedName,CanonicalName,GroupCategory,GroupScope,whenCreated

i just checked the wayback machine over at archive.org, which only had part two of the three part series,a nd pointed to SQL Saturday #234, since it was a presentation...

no, it's a classic question on the...

this looks right to me, and is sytactically correct, but you didn't mentione what the new value was.

i would use the ansi 92 syntax to make it clear to my...

assuming your text editor is SQL Server Management Studio, SSMS itself is not case sensitive; however,...

have your dba create a procedure that features EXECUTE AS OWNER that adds missing permissions.

have the procedure loop through each database on the dev server, and do a classic if...

bumping this for the morning, hopefully someone may remember what counts as a transaction per second.

you altered the table and added a new column [date1]

the table [Metrics].[dbo].[x64_Restore_Metrics_All_Temp] now has four columns, but your insert has only three.

if you do insert into table without a column...

i think it's just a select of three queries, which inserts into the new table.

INSERT INTO NEWTABLE(ColumnList)

SELECT RecordID,ManagerID,ManagerApprovedDate,'ManagerApproved'

From OriginalTable WHERE ManagerID IS NOT NULL UNION ALL

SELECT RecordID,ClerkID ,ClerkApprovedDate,'ClerkApproved' ...

i built this proc from some examples i found here on SQLServerCentral:

IF OBJECT_ID('[dbo].[sp_dbspaceused]') IS NOT NULL

DROP PROCEDURE [dbo].[sp_dbspaceused]

GO

--#################################################################################################

--developer utility function added by Lowell, used in SQL Server...

mar.ko (8/28/2015)

---

Ed Wagner (8/28/2015)

---

The statement that contains the CTE needs to end with a query that uses the CTE. Like Luis said, please post the code; that should clear...

looks to me like the issue is in the complicated select that you left out of the post...

you not getting the data you expect, so it's gotta be in the...

the command prior to WITH MyCTE AS(...

must be terminated with a semicolon. that's probably where the issue likes.

that issue makes a lot of people precede their [WITH] to feature...