Viewing 15 posts - 14,806 through 14,820 (of 15,381 total)
I agree with Lowell. What good would it do making sql get the image for you? You still have to present it somewhere and that is obviously front end stuff....
April 14, 2011 at 12:15 pm
What is the timeout on the command object? How long does this query/proc take to run in SSMS? Basically what is happening is that the execution takes longer than the...
April 14, 2011 at 7:38 am
Much like all the other threads you have posted over the last several days you continue to miss to most important piece of getting help. You have to help us...
April 14, 2011 at 7:35 am
Since you are just capturing IP location and looking up the gps location you could probably do that faster and more efficiently directly in your c#. Capturing the IP is...
April 13, 2011 at 2:48 pm
Great question. Not sure how some people can argue the clarity. Waterford crystal isn't any clearer than this question. Keep 'em coming Duncan.
April 13, 2011 at 7:37 am
Brandie Tarvin (4/12/2011)
RE: datatypes discussion
April 12, 2011 at 12:21 pm
Why do you need a second alias for the same thing?
April 12, 2011 at 10:56 am
Yes I understand that is what business wants. School was so long ago I can scarcely remember it. There is no need to be hostile. We are all here offering...
April 12, 2011 at 9:53 am
pdonley (4/12/2011)
April 12, 2011 at 9:41 am
pdonley (4/12/2011)
April 12, 2011 at 9:19 am
jaya53 (4/8/2011)
Try this :select *
from blah
where
blah = blah
and blah = blah
and (
(@ActivityStatusID=1 and ACS.[Description] = 'Completed')
or
(@ActivityStatusID<>1 and ACS.[Description] <> 'Completed')
)
I knew...
April 8, 2011 at 8:02 pm
Now I see what you are asking. I don't know of any way to list tables like that but it does seem like it could be a good thing in...
April 8, 2011 at 3:19 pm
Ahh I see. I don't know that you want a view for every table in the system. Most queries need to be more complex than that so the view would...
April 8, 2011 at 2:34 pm
No kidding. On both counts it is a definite improvement. I already added that snippet to my snippet box. I had to modify the credit comment slight of course. 😎
April 8, 2011 at 2:32 pm
That's a pretty slick technique. Thanks for the idea.
April 8, 2011 at 2:22 pm
Viewing 15 posts - 14,806 through 14,820 (of 15,381 total)