Viewing 15 posts - 1,756 through 1,770 (of 5,590 total)
Craig Farrell (2/28/2011)
Some days I think I know exactly how that dog is feeling at that moment...
Heck, when I saw Lowell's avatar, I said to myself "Craig should be using...
February 28, 2011 at 1:41 pm
Can you verify what version of SQL you're using?
This will work with SQL 2005+ (I changed the tables to be table variables...). If you're on 7/2000, we'll have to change...
February 28, 2011 at 1:31 pm
ramyours2003 (2/28/2011)
February 28, 2011 at 11:42 am
Patrick Trongo (2/28/2011)
We have our SQL Servers running on a virtual cluster with fail-over everything.
I've been baby sitting this data for quite a few years, and have always...
February 28, 2011 at 11:23 am
How does this work? (Also... please read the article in the first link in my signature for better ways to post to help us help you - it also makes...
February 28, 2011 at 9:45 am
Michael Valentine Jones (2/28/2011)
Mastering skills that may be worthless in five years seems pointless.
I don't really agree with this. While it is true that SQL will continue to evolve and...
February 28, 2011 at 9:36 am
amenjonathan (2/28/2011)
February 28, 2011 at 9:11 am
Frequent problem, and you've corrected pegged it to others posting to the same thread while you were reading it. Just refresh the browser page before clicking the quote button.
February 28, 2011 at 8:18 am
SQL_Student (2/27/2011)
http://databaseanswers.org/modelling_tools.htmI did some research online and found a good site. Here's a great place to try all kinds of data modeling products.
Now that is a very good link...
February 28, 2011 at 8:09 am
This takes a little bit of:
1. Splitting the string apart into it's delimited parts, and
2. Utilizing some dynamic sql.
For the first part, we'll utilize the DelimitedSplit8K function. Since there are...
February 28, 2011 at 7:53 am
Craig - you missed one key thing.
Each table had the required constraint
This probably should have specified that each table had the required CHECK constraint to ensure that data within only...
February 27, 2011 at 7:49 pm
Three things to point out:
1. In SQL 2008 (I see you posted in 2005, so this is just for FYI purposes), you could use the MERGE statement to do this...
February 27, 2011 at 7:38 pm
daveriya (2/25/2011)
But i am getting result,whats wrong in this?tell me
How can you tell which row is for registered, and which is not registered?
daveriya (2/27/2011)
group by o f what?registered
Yes.
February 27, 2011 at 8:58 am
Are you sure? When I run this code:
DECLARE @test-2 TABLE (Num CHAR(7), Code VARCHAR(50), [Start Date] DATETIME,...
February 25, 2011 at 6:56 pm
daveriya (2/25/2011)
February 25, 2011 at 6:48 pm
Viewing 15 posts - 1,756 through 1,770 (of 5,590 total)