this happened because I had an instance of SS 2008 installed on my machine and then I installed visual studio express with ss express. I needed to set the properties of the instance to allow both windows and sql server authentication.
begin transaction update v set v.domainacct = a.login from [otherdbname].dbo.ADUserList a inner join dbo.Vacation2011 v on (v.lastname = a.lastname COLLATE SQL_Latin1_General_CP1_CI_AS and v.firstname = a.firstname COLLATE SQL_Latin1_General_CP1_CI_AS) commit transaction
select v.domainacct, a.login, a.firstname afirst, v.firstname vfirst, a.lastname alast, v.lastname vlast –into ##temp from dbo.Vacation2011 v left outer join dbo.ADUserList a on (v.lastname = a.lastname COLLATE SQL_Latin1_General_CP1_CI_AS and v.firstname = a.firstname COLLATE SQL_Latin1_General_CP1_CI_AS)
also can do for INSERT CREATE TRIGGER trig_vacReq ON dbo._vac FOR DELETE AS BEGIN INSERT INTO dbo._vacLog (vacRequestID, firstname, lastname, startdate, enddate, date_entered, LogDate, logevent) SELECT vacRequestID, firstname, lastname, startdate, enddate, date_entered, GETDATE() as LogDate, ‘Deleted’ as LogEvent FROM Deleted END
update query like this: WHERE a.lastname COLLATE Latin1_General_CI_AS = k.lastname
Select cells Select the menu choice Data Select the menu choice Text to Columns
SELECT tID , [Country] , [Day] , [Month] FROM ( SELECT t2.tID , t1.ColName , t2.Txt FROM Table1 AS t1 JOIN Table2 AS t2 ON t1.ColId = t2.ColID ) p PIVOT ( MAX([Txt]) FOR ColName IN ( [Country], [Day], [Month] ) ) AS pvt ORDER BY tID ;
select SPECIFIC_NAME from msdb.information_schema.routines where routine_type = ‘PROCEDURE’ order by SPECIFIC_NAME