Viewing 15 posts - 17,491 through 17,505 (of 26,489 total)
update dbo.TheTable set
TheColumn = 2009 + (TheColumn / 100.00)
How about this?
January 12, 2010 at 12:10 pm
Tara-1044200 (1/12/2010)
I gave my expected result above.I have a column which has week number like 1 to 52 but i want to update them with prefix year like 2009.1,2009.2......2009.52
What is...
January 12, 2010 at 11:45 am
Can you provide a simplified version of what you are attempting to accomplish including table definitions (CREATE TABLE stements), smaple data (INSERT INTO statements for each table), and expected results...
January 12, 2010 at 10:19 am
Simple answer, by design. If you find yourself in a position of having to restore the master database, I am guessing it needs to be operational upon completion of...
January 12, 2010 at 9:56 am
Are talking about stripping the { and } from the data and replacing it in the same place?
January 12, 2010 at 9:52 am
J-F Bergeron (1/12/2010)
J-F Bergeron (1/12/2010)
GilaMonster (1/12/2010)
Yes, we have electricity and internet (most...
January 12, 2010 at 9:45 am
J-F Bergeron (1/12/2010)
GilaMonster (1/12/2010)
Yes, we have electricity and internet (most of the...
January 12, 2010 at 9:38 am
GilaMonster (1/12/2010)
Yes, we have electricity and internet (most of the time), we...
January 12, 2010 at 9:37 am
Colorado Springs, Colorado (A born and raised Colorado Native).
January 12, 2010 at 8:49 am
Duplicate post. Please respond here.
January 12, 2010 at 8:28 am
Looks like a trees and forest issue. Glad to be able to help.
January 12, 2010 at 8:09 am
UNION
SELECT
dbo.Staff.Firm, --dbo.Staff is aliased Staff_3, this should be Staff_3.Firm
Person_3.FullName AS Name, CAST('NONE' AS varchar(5)) AS Department, Address_2.City, Address_2.StateCode AS State,
Company_3.Name AS...
January 11, 2010 at 4:07 pm
A good place to start would be with the last article I reference in my signature block regarding Managing Transaction Logs.
January 11, 2010 at 2:44 pm
Okay, twenty four hours and no response. Yep, definitely NOT a discussion on the OP's problem. Can't have a one way discussion, that is just a lecture or...
January 11, 2010 at 1:33 pm
crookj (1/11/2010)
We do have an IMAX here in town so I guess my Wife and I are heading out to use the Cinemark gift card my...
January 11, 2010 at 1:17 pm
Viewing 15 posts - 17,491 through 17,505 (of 26,489 total)