From Steve's editorial:

We recently had a question of the day that asked if times were equivalent, given different numerical times across time zones, and there was quite a debate as...

ssc-574207

A little off the wall thinking here.

Never have attempted this, an only presented to get your thinking moving a different way.

1. Use TABLESAMPLE on table "A" to SELECT...

Sorry do not understand your question ... why not reverse the calling order of your 2 procedures. That is call procedure "B" first to insert the data into...

kazim.raza

From the extremely limited amount of information you have posted, have you thought of using your first...

Are you concerned about the "big...

Would suggest going to:

http://technet.microsoft.com/en-us/default.aspx

input in the search box "sql server 2008 upgrade"

It will return 402,00 entries - which am I sure more than one of which will assist you.

Look at the ISNULL function.

ISNULL ( check_expression , replacement_value )

check_expression

Is the expression to be checked for NULL. check_expression can be of any type.

replacement_value

Is the expression to be returned...

Have you looked at mofiying your T-SEL to use Try--Catch

Implements error handling for Transact-SQL that is similar to the exception handling in the Microsoft Visual C# and Microsoft Visual...

jaroho (2/21/2010)

I am not using a single account to authenticate users.

All i want is, no one should modify or run queries from the backend.

All modifications should be done from the...

This will get rid of the function and the need to change the date each time, but it does use a WHILE loop, I have not attempted it to use...

An order by clause means a sort ... a 10 percent sample of a

We are currently taking a small sample from a 12-million...

Mmight I suggest reading:

Limiting Result Sets by Using TABLESAMPLE at:

http://technet.microsoft.com/en-us/library/ms189108(SQL.90).aspx

Note:

When TABLESAMPLE is used against databases that are upgraded to SQL Server 2005, the compatibility level of the database...

First of all you might want to add this site to your bag of tips and how-to's

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

The site has excellent T-SQL procedures easily downloaded to your machine.

Next you could consider...

Since you did not post your table(s) definitions, and your field may be NVARCHAR or VARCHAR please note the character codes for those characters...

JMSM

My posting was intended to have you search for, and remove the non-printing characters in your T-SQL statement, much as you use the LTRIM and RTRIM. Not for the...