Viewing 15 posts - 20,131 through 20,145 (of 26,490 total)
rsheppick (6/30/2009)
Lynn Pettis (6/30/2009)
Curious, what permissions were the developers using while building the app?We had full god mode rights ha ha, so it never came up.
And that is probably your...
June 30, 2009 at 11:25 am
First, no reason to convert to mm/dd/yyyy when comparing to a datetime column as SQL Server will just convert the character representation back to a datetime value.
Second, this will probably...
June 30, 2009 at 11:20 am
Why? What is the data type of the column you will be comparing the value with?
June 30, 2009 at 11:13 am
Curious, what permissions were the developers using while building the app?
June 30, 2009 at 11:11 am
Amedeo Feroce (6/30/2009)
June 30, 2009 at 11:06 am
Give this a try: select dateadd(mm, datediff(mm, 0, getdate()), -1)
June 30, 2009 at 11:02 am
Now that you eliminated the cross join, and the fact that you want all the records from the source table, it should work. Have you run it in a...
June 30, 2009 at 10:52 am
Could you provide the DDL for the tables and some sample data? It can be abbreviated to those columns you need and required for joining the tables together. ...
June 30, 2009 at 10:42 am
select
*
from
TableA ta
inner join TableB tb
on (ta.Col1 = tb.Col1
...
June 30, 2009 at 10:21 am
nscott (6/30/2009)
June 30, 2009 at 10:14 am
Could be. Problem is, we haven't seen your code.
June 30, 2009 at 10:06 am
Take a look at the code attached. I tried posting it in this thread, but once again I seem to be having issues again.
June 30, 2009 at 10:00 am
jcrawf02 (6/30/2009)
Paul White (6/30/2009)
WayneS (6/29/2009)
Hey gang... I'm looking to take "She who must be obeyed" (in this case, both my wife and mother... )
When I first read that, it sounded...
June 30, 2009 at 9:52 am
Paul White (6/30/2009)
As tempting as the AWE 2K topic is, and as much as I dislike the /3GB switch, I must get some sleep!Night all. 🙂
Good Night Paul! 😉
June 30, 2009 at 9:50 am
Well, thank you for the link, but it really isn't the same as showing us your actual code.
June 30, 2009 at 9:39 am
Viewing 15 posts - 20,131 through 20,145 (of 26,490 total)