Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,131 through 47,145 (of 59,064 total)

RE: Help writing function to get decimal from string

BWAA-HAA! I guess it's because I need more coffee, as well! Maybe that qualifies. 😛

November 18, 2008 at 6:09 am

#899854
RE: Find out which table columns were inserted from within a trigger

Just remember that you will get an advisory about total row length exceeding 8060 bytes if you use more than a very small handful of columns in the same table...

November 18, 2008 at 6:07 am

#899853
RE: Help writing function to get decimal from string

Garadin (11/18/2008)
Jeff Moden (11/18/2008)
The really good part about it all is that no matter what goes wrong, I always learn something new even if it's only how to "read minds"...

November 18, 2008 at 6:02 am

#899847
RE: Select based on Date- How to?

mpdillon (11/18/2008)
But this time I wanted to find a more intuitive method. Some(OK most) of my queries are difficult to read. Having to interpret dates makes them even more so...

November 18, 2008 at 5:58 am

#899842
RE: Recursive is query is slow

vkundar (11/18/2008)
Jeff thanks for the links.
gborasaniya you are right as this in data warehousing environment mainly in ETL we have constraints on using or creating indexes. we need to deal...

November 18, 2008 at 5:35 am

#899824
RE: Help writing function to get decimal from string

Chris Morris (11/18/2008)
How often have you spent hours, even days, on a solution for a desperate punter only to find they've not bothered to post all the details of the...

November 18, 2008 at 5:30 am

#899818
RE: Help writing function to get decimal from string

Dooza (11/18/2008)
... and was setup like this by the developers.
Heh... of that, I have no doubt. Thanks for the feedback, Steve. 🙂

November 18, 2008 at 5:27 am

#899817
RE: Find out which table columns were inserted from within a trigger

Grant Scanlen (11/18/2008)
It will never be the case that the values in any of these columns will exceed 900 bytes, as the underlying data type is numeric(28,14).
Grant
I guess SQL_Variant will...

November 18, 2008 at 5:24 am

#899813
RE: Best way to convert a datetime field into a char(8) '20081117' in dataflow

aaa (11/18/2008)
It does have a datetime field but this contains 2008-11-01 00:00:00.000 and so on. So if we have a datetime field with 2008-11-01 12:58:21.000 we cannot use this field...

November 18, 2008 at 5:19 am

#899809
RE: Help writing function to get decimal from string

Dooza (11/18/2008)
am so glad my server ain't screwed!
Steve
Man, me too! Thanks Chris. Sorry I forgot about the server maybe being case sensitive... that's the good thing about...

November 18, 2008 at 5:08 am

#899800
RE: Help writing function to get decimal from string

Chris Morris (11/18/2008)
Jeff Moden (11/17/2008)
Chris Morris (11/17/2008)
Jeff, perfick solution as always!
Serious or sarcasm? Can't tell from here.
Aw Jeff you should know me better than that!
This...
WHERE t.N BETWEEN CHARINDEX('(',@String)...

November 18, 2008 at 5:05 am

#899796
RE: Adding a Total Column with a Pivot Table

Heh... thanks Jason. Maybe I should change my avatar to [font="Arial Black"]þ[/font], huh? 😛

November 18, 2008 at 4:58 am

#899789
RE: Searching for UDF on this site

Dunno which one you're looking for, but the following article has one of the better ways of doing it...
http://www.sqlservercentral.com/articles/T-SQL/63003/

November 17, 2008 at 9:37 pm

#899673
RE: Best way to convert a datetime field into a char(8) '20081117' in dataflow

Why does the dimension table have dates that have been converted to varchar to begin with?

November 17, 2008 at 9:34 pm

#899671
RE: Could I get the xp_ source code please

There are many XP_ extended stored procs that point to a DLL... and the source code for those DLL's isn't part of the SQL Server installation code...
So, the answer...

November 17, 2008 at 9:32 pm

#899670

Viewing 15 posts - 47,131 through 47,145 (of 59,064 total)