Viewing 15 posts - 18,016 through 18,030 (of 26,489 total)
Krasavita (12/10/2009)
Are there other apps on the server that SQL has to share the box with.
How Can I check other apps on the server that SQL has to share...
December 10, 2009 at 11:48 am
David Burrows (12/10/2009)
Lynn Pettis (12/10/2009)
December 10, 2009 at 10:27 am
I was stationed in England for 2.5 years. You know how we knew we were having a heat wave? The old people started dying of heat stroke. ...
December 10, 2009 at 10:00 am
TSQLExplorer (12/10/2009)
That is exactly what I need...THANKS!!!
Okay, that helps but then how do you get a count of 1 from this, I'd assume it would be 2:
select '92232','eex','10/21/2008 12:00am' union...
December 10, 2009 at 9:29 am
Gus,
Here is my take on this, since it is on a SQL Server 7, 2000 forum and based on the original post. The OP has the SQL Server 2005...
December 10, 2009 at 9:24 am
Jeff Moden (12/9/2009)
Lynn Pettis (12/9/2009)
Jeff Moden (12/9/2009)
Lynn Pettis (12/9/2009)
December 10, 2009 at 8:19 am
The only problem I have the Colorado Springs SQL Server Users Group is the day they have chosen to meet, I'm sorry but Wednesday night is not a good night...
December 10, 2009 at 8:07 am
Just ran a quick test, you probably have null values as an empty string does not return an error.
December 10, 2009 at 7:59 am
Rob-350472 (12/10/2009)
Msg 1014, Level 15, State...
December 10, 2009 at 7:57 am
Bru Medishetty (12/10/2009)
ray 78019 (12/10/2009)
If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different name, it'll still be...
December 10, 2009 at 7:36 am
Rob-350472 (12/10/2009)
It's...
December 10, 2009 at 7:16 am
Agreed, the cursor solution, though workable, is not scalable. Of the three alternatives presented here at this time, IMHO, the tally version is actually the most scalable solution. ...
December 10, 2009 at 7:13 am
Here is the fun part of living in Colorado. This past week we have had tempatures down to -13F (not including wind chill factor) and during the day between...
December 10, 2009 at 7:03 am
Here is another alternative. The following code is a how I would accomplish this task followed by the code for my function.
create table dbo.TestData (
ID...
December 10, 2009 at 6:58 am
At this point all we can do is guess at what you are trying to accomplish. Help us help you, read the first article I reference below in my...
December 10, 2009 at 6:40 am
Viewing 15 posts - 18,016 through 18,030 (of 26,489 total)