Viewing 15 posts - 2,416 through 2,430 (of 3,221 total)
david.wright-948385
Having said that, writing a QOD is difficult, and praise is due to all those who take the time to do so. The questions always help in some way, even...
October 1, 2009 at 1:37 pm
rjv_rnjn
Was the question modified based on discussions here?
No it was not ... the question was designed to bring attention to the subtle changes made between 2005 and 2008. Too...
October 1, 2009 at 11:43 am
trudye10
Another potential gotcha .. if the column you are checking (Card_Num) is defined as CHAR or VARCHAR then the LEN function will do the job for you. If...
September 26, 2009 at 8:54 pm
Corrected in next post - was too quick with the mouse click
September 26, 2009 at 8:44 pm
Bob Hovious
There always seems to be a rash around the end of the fall and spring semesters.
End of semester - final exams -- of the take home variety -...
September 26, 2009 at 2:58 pm
raaz66
Read this post -- admittedly it does not change into Indian currency, but believe you can modify the posted code easily to obtain what you need
http://www.sqlservercentral.com/Forums/FindPost794177.aspx
It will take a...
September 26, 2009 at 2:29 pm
trudye10
Rather skimpy amount of information for someone to assist you. Can you please post the table definition, identify the specific column and its data type. Some sample...
September 26, 2009 at 1:08 pm
I have not had the opportunity to test these, all of which were posted by individuals to the SQL Server Central site. Review them, test them and say a...
September 26, 2009 at 8:45 am
saidwarak01
Go the the following link. Great discussion and a vast amount of sample code for exporting / importing data to / from Excel. It may have what...
September 22, 2009 at 9:54 am
Damn... Thats pretty good. So the standard will be pretty high... Then my article is probably going to be rejected...
-Roy
Have confidence Roy, have confidence, and remember the down...
September 21, 2009 at 5:39 pm
Jcrawf02
Bit, you're a Buckeye?
Heck no ...Born and raised in the borough of Brooklyn in the city of New York .. U.S.A. and as soon as of legal age moved...
September 21, 2009 at 10:55 am
Use thisTechnet link:
http://technet.microsoft.com/en-us/library/ms170363(SQL.90).aspx
September 20, 2009 at 6:38 am
Completely off the THREADs normal discussions but I thought might be of interest to those who frequent the THREAD.
I decided to revisit Steve's editorial Moore's' Law
http://www.sqlservercentral.com/articles/Editorial/68112/
And then thought about the...
September 19, 2009 at 8:35 am
Refer to Books On Line (BOL)
IF...ELSE (Transact-SQL)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/676c881f-dee1-417a-bc51-55da62398e81.htm
September 19, 2009 at 7:25 am
Sergey Vavinskiy
The "days" is DATEDIFF(day, [prew.month], [month])
Be careful using the above for example using the first row of your data
1 2009/01/30 200 2008/12/29 190 30 0.33
SELECT DATEDIFF(day,'2009/01/30','2008/12/29')
results in...
September 18, 2009 at 8:17 am
Viewing 15 posts - 2,416 through 2,430 (of 3,221 total)