Viewing 15 posts - 46,906 through 46,920 (of 59,062 total)
Dang... some of the things I forget... thanks Barry.
November 28, 2008 at 7:31 pm
BWAA-HAA! And then, you double post the same question...
http://www.sqlservercentral.com/Forums/Topic610096-146-1.aspx
... you're not making a lot of friends here.
November 28, 2008 at 6:41 pm
khushbu.kumar (11/28/2008)
GilaMonster (11/28/2008)
I'm not sure there's a good way in SQL 2005.Why can't you make the combination of the two columns unique?
I cant make combination as unique coz 1. abc...
November 28, 2008 at 6:39 pm
tkoletsis (11/28/2008)
I think it's a very common case to import data from an excel file to sql server 2005 thru a stored procedure. There are many solutions solutions such as...
November 28, 2008 at 6:34 pm
BWAAA-HAAA! New candidate for the Pork Chop Award... look at the question and then look at the certs this guy boasts in his signature...
http://www.sqlservercentral.com/Forums/Topic608903-360-1.aspx
... heh... guess all those certs...
November 28, 2008 at 6:30 pm
Chris, I've created a Numbers table with the same column name as you (Number), and I cannot get the code to fail the same way as you have with the...
November 28, 2008 at 6:22 pm
Dang... I missed that... was looking at the wrong column for "dupes".
November 28, 2008 at 5:53 pm
CrazyMan (11/28/2008)
CREATE VIEW VTEST AS
SELECT A,B FROM TABLE1
UNION
SELECT A,B FROM TABLE2
This view cant do update :D, it is read only 🙂
Ummm... not if it's a partitioned view which IS...
November 28, 2008 at 5:22 pm
homebrew01 (11/28/2008)
However, if I replace @list_Id with an actual value, then it shows an index seek.
Trick it...
WHERE l.List_ID > 0
AND l.List_ID = @list_id
AND...
November 28, 2008 at 5:11 pm
Sorry... didn't see Gail's post on 1222...
I also share her concern on setting a deadlock priority... it's like asking a Mother which baby someone can kill. The best...
November 28, 2008 at 4:48 pm
TNV (11/26/2008)
Basically I am new to this SQL Server stuff...
I am using MSSQL Server 2005 Express. I turned on trace by using DBCC TRACEON (1024). But in the errorlog,...
November 28, 2008 at 4:46 pm
I tend to steer clear of using Table Variables... there's a whole lot of reasons for that but the biggest reason is that when in Query Analyzer or SMS for...
November 28, 2008 at 4:44 pm
Jeff Moden (11/28/2008)
Jack Corbett (11/28/2008)
If it has to be a view change the CTE to a derived table in the FROM clause.
Strangely enough, I've not tried using a CTE...
November 28, 2008 at 4:37 pm
Jack Corbett (11/28/2008)
If it has to be a view change the CTE to a derived table in the FROM clause.
Strangely enough, I've not tried using a CTE in a...
November 28, 2008 at 4:36 pm
Mike C (11/28/2008)
TheSQLGuru (10/14/2008)
And I too think this is a presentation layer item. Or perhaps a CLR...
November 28, 2008 at 4:34 pm
Viewing 15 posts - 46,906 through 46,920 (of 59,062 total)