Geeks With Blogs
[dbr] February 2011 Entries
number of months since
select datediff(month, cast('2008-09-01 10:31:05.910' as datetime),getdate()) ......

Posted On Tuesday, February 1, 2011 11:31 AM

update sql table with join
UPDATE [Group] SET [Group].[CoordLeft] = [CopyGroup].[CoordLeft] FROM [Group] INNER JOIN [CopyGroup] ON [Group].[Name] = [CopyGroup].[Name] ......

Posted On Tuesday, February 1, 2011 11:25 AM

Copyright © dbr | Powered by: GeeksWithBlogs.net