Viewing 15 posts - 10,456 through 10,470 (of 11,676 total)
Dinculescu Mihai (1/15/2011)
It was generated for migrating data over.
Migrating data from what to where?
In the same DB? In the same server? Or across different servers?
January 15, 2011 at 6:19 am
What is EMPTY? Is it an empty string? A single space? Multiple spaces?
In the case it is an empty string, you better trim the column first and then check if...
January 15, 2011 at 6:06 am
It works with me on SQL Server 2008 R2.
Are you sure there is not a typo in the name of ServerB?
January 15, 2011 at 5:58 am
Can you give a little more information?
What version of SQL Server are you using? What service pack level?
What do the queries look like? Are you using a linked server?
Are you...
January 15, 2011 at 5:49 am
If you are on your own, selling it will be tough. Companies usually don't just install everything on their computers. You have to convince them. And you have multiple people...
January 15, 2011 at 5:45 am
Dave Ballantyne (1/14/2011)
A fairly cool (IMO) change ,superseding old articles, could be happening to SSC in the future.Comments ??
http://www.sqlservercentral.com/Forums/Topic1047170-433-1.aspx
I think it is a great suggestion.
But as mentioned in the...
January 14, 2011 at 12:07 pm
Alvin Ramard (1/14/2011)
If so many of you dislike a certain poster so much then why do you have to keep on talking about him?
It is like watching a horror movie....
January 14, 2011 at 12:01 pm
GSquared (1/14/2011)
Jeff Moden (1/13/2011)
Stefan Krzywicki (1/13/2011)
If they see a penny on the ground, they leave it there.
Maybe other folks will leave it, but I'll stop and pick it up. ...
January 14, 2011 at 7:24 am
Ray K (1/14/2011)
Just because of his attitude, not only will I never recommend his books
Come on come on. Don't exaggerate. I hear they are just fine for starting a nice...
January 14, 2011 at 7:21 am
munawargani2001 (1/14/2011)
Check out this link. It is just one step quick way.
This will work if the data comes out of a flat file.
However, no one in this thread has mentioned...
January 14, 2011 at 7:04 am
Isn't it possible it was a self restart?
January 14, 2011 at 6:54 am
Another solution, but harder to maintain and probably not so good for performance - is to set up triggers on tables that contain critical data. If a delete is performed,...
January 14, 2011 at 6:47 am
The second code will surely be much faster, but you've hard coded the condition into your statement.
Are you sure there will always be one row in table2 with col2 =...
January 14, 2011 at 6:44 am
irobertson (1/14/2011)
Hi,Another way is to use a table variable to limit your values:
...
Just because I find it a bit easier to read than dynamic SQL...
You are right, that is a...
January 14, 2011 at 3:45 am
Niteen.gavhane (1/14/2011)
CREATE PROCEDURE testbizclose_remove
(
@Par int
)
AS
SELECT DAY FROM BIZ_CLOSING WHERE BIZ_ID = 802 and (case @Par when 1 then shift in( 1,4,6,7) when 2...
January 14, 2011 at 3:14 am
Viewing 15 posts - 10,456 through 10,470 (of 11,676 total)