Viewing 15 posts - 7,051 through 7,065 (of 9,720 total)
Odd. When I do a "SELECT current_timestamp, GetDate()", I get the exact same values. So I'm not getting the point about readability.
October 28, 2010 at 4:14 am
Jeff Moden (10/27/2010)
But, my recommendation is to avoid them like the plague.... they're comparatively slow.
How much of a performance hit do styles put on the server?
October 27, 2010 at 11:23 am
Dynamic name can be done either via script or via a Variable set as "Evaluate as Expression".
Using the File Connection (not the Flat File Connection), you can dynamically create...
October 27, 2010 at 11:19 am
WayneS (10/27/2010)
Questions about this in general:1. How do we "submit" these "articles"?
Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to click through...
October 27, 2010 at 11:16 am
Steve Jones - SSC Editor (10/27/2010)
October 27, 2010 at 11:13 am
Steve Jones - SSC Editor (10/27/2010)
Whew, for a second I thought I was going to learn something on The Thread.
OMG, someone grab the paramedics. Steve's going into shock because he...
October 27, 2010 at 11:11 am
Read my edit. Your punctuation use (. instead of ?) at the end made it sound like a statement, not a question. I thought you were telling us there were...
October 27, 2010 at 9:06 am
Ivan,
Your post is almost incomprehensible to me. Could you edit out the abbreviations and put real words in their place so I can understand what you're trying to say?
October 27, 2010 at 8:27 am
parthi-1705 (10/27/2010)
Any other 3rd party tool can solve this.
Really? I haven't seen one that doesn't use traces or triggers. Please, tell us what those tools are. I'd like to test...
October 27, 2010 at 8:24 am
Maina-456685, Could you provide sample data so Chris and I can verify solutions before we post them?
October 27, 2010 at 7:44 am
I'm fairly certain you don't need the GROUP BY and HAVING on the Contract insert. Test it to verify, but everything after the c.CellphoneNo IS NULL should be able to...
October 27, 2010 at 7:42 am
Stefan Krzywicki (10/27/2010)
Interesting, I'll have to look into what the formatting numbers at the end do to the dates. Thanks
Look up Convert, the Transact-SQL reference, in Books Online. Halfway down...
October 27, 2010 at 7:28 am
Grant Fritchey (10/27/2010)
To the Threadizens/Threadites/Threadoids/Threadopians:
Wow, Grant. What a way to make the Threadophiles feel unwanted...
@=)
October 27, 2010 at 6:40 am
Viewing 15 posts - 7,051 through 7,065 (of 9,720 total)