Viewing 15 posts - 10,996 through 11,010 (of 15,381 total)
Rainmaker097 (8/20/2012)
Hi,if it is only going to display 8000 chars, what is the point of using a column that can have more than 8000 chars?
Am I "select"ing it wrong?
RM
The data...
August 20, 2012 at 1:43 pm
Luis Cazares (8/17/2012)
I believe that most problems like this should be solved with other administration options and not triggers. I wouldn't...
August 17, 2012 at 2:16 pm
Luis Cazares (8/17/2012)
Sean Lange (8/17/2012)
August 17, 2012 at 1:14 pm
DBA_SQL (8/17/2012)
August 17, 2012 at 12:46 pm
Lynn Pettis (8/17/2012)
Stylez (8/17/2012)
August 17, 2012 at 9:45 am
Can you post ddl and sample along with desired output? Take a look at the first link in my signature for best practices when posting questions.
August 17, 2012 at 9:40 am
anushamsbi (8/17/2012)
Hi,It is not working.. can u pls eloborate that one..
Can you elaborate on "It is not working"? What does that mean? Did you get an error message? Did it...
August 17, 2012 at 7:18 am
dwain.c (8/17/2012)
ChrisM@Work (8/17/2012)
dwain.c (8/16/2012)
Lynn Pettis (8/16/2012)
Here is one for the do not hire list.Or it could be the needs much training list.
The quality of the hires will be roughly proportional...
August 17, 2012 at 7:04 am
Lynn Pettis (8/16/2012)
Sean Lange (8/16/2012)
I was just about to suggest using SSIS instead but it looks like Lynn beat me to it. 😀
Something about using the right tool for the...
August 16, 2012 at 12:57 pm
I was just about to suggest using SSIS instead but it looks like Lynn beat me to it. 😀
August 16, 2012 at 12:53 pm
Ken Davis (8/16/2012)
August 16, 2012 at 12:52 pm
Quite an odd requirement but it is going to take some work on your end.
Something like this should work.
select 'Col_1' as Col_1, 'Col_2' as Col_2, 'Col_3' as Col_3, 0 as...
August 16, 2012 at 12:35 pm
Pretty sparse on details but I think you want to use a left join instead of a union.
August 16, 2012 at 8:38 am
So if you totally remove the date check then it runs fast again? That sounds like indexing to me.
August 16, 2012 at 8:19 am
ChrisM@Work (8/16/2012)
pwalter83 (8/16/2012)
The query I am working on runs very slow due to a piece of code -
CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1
Could someone please suggest...
August 16, 2012 at 7:50 am
Viewing 15 posts - 10,996 through 11,010 (of 15,381 total)