Viewing 15 posts - 1,651 through 1,665 (of 3,221 total)
Can you post the table definition, some sample data (click on the first link in my signature block for a quick means of doing just this), expected results, and what...
October 29, 2010 at 1:43 pm
CELKO (10/28/2010)
Look up the COALESCE() function. Do not use the old Sybase museum ISNULL(). They are not quite the same and you can get screwed.
Care to give an example and...
October 28, 2010 at 4:43 pm
Roy Ernest (10/28/2010)
Grant Fritchey (10/28/2010)
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!
Oh, that was you? Sorry I didn't wave back. Man, I...
October 28, 2010 at 4:29 pm
Jeff Moden (10/28/2010)
October 28, 2010 at 9:19 am
Look at this, and with slight modification you should be able to do what you require
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
October 26, 2010 at 10:47 am
Here is a snippet of code (copied from a post long ago, by Jeff Moden)
It works for me
/*Import Excel OpenRowsetSelect data from excel
note Sheet1$a4:C start at row 4 using...
October 26, 2010 at 8:58 am
I am referencing the #mytable to update other tables fields’ date.
Thie above is from your first posting and does NOT agree with the sample code you posted. My...
October 25, 2010 at 6:32 pm
If your data were being imported into a staging table, then the datetime values, could be converted to time only as a VARCHAR and then inserted into the proper...
October 25, 2010 at 2:57 pm
To receive tested help, please post the table, view definition, some test data and expected results and what code you have used.
In order to do that easily please...
October 25, 2010 at 1:34 pm
In the manner of a general reply, assuming you may wish to have a "bag of date tips and all, try this link, and you can add the T-SQL to...
October 25, 2010 at 12:57 pm
You might receive some assistances if you defined your table(s), provided some sample data and desired results. Please refer to the fist link in my signature block for what...
October 22, 2010 at 7:17 pm
Not one of those guys .. that is straight out of college, but have been around long enough to know, that if you are not learning new technologies, you are...
October 22, 2010 at 7:01 pm
I passed your thanks onto the Author Gianluca Sartori (as noted in the code posted) and requested that he look at this forum and just maybe he can come up...
October 22, 2010 at 9:47 am
First of all without the table structuresand some sample data it is impossible to give you a tested answer.
All I can suggest is that you use Books On Line...
October 21, 2010 at 2:00 pm
Gail,
at first I thought those answers / explanations were jokes, but then realized they were not. May the Gods save us from the stupidies of those who think...
October 21, 2010 at 1:44 pm
Viewing 15 posts - 1,651 through 1,665 (of 3,221 total)