Viewing 15 posts - 2,071 through 2,085 (of 3,221 total)
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...
February 26, 2010 at 3:15 pm
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...
February 26, 2010 at 1:27 pm
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...
February 25, 2010 at 6:01 am
kazim.raza
1) I have an Execute SQL task that executes a sql and gets result.
From the extremely limited amount of information you have posted, have you thought of using your first...
February 25, 2010 at 4:52 am
there is talk of either ending that practice or requiring the dev sql servers to meet production security standards. This will start a big fight
Are you concerned about the "big...
February 24, 2010 at 3:24 pm
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.
February 24, 2010 at 1:46 pm
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...
February 23, 2010 at 3:23 pm
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...
February 23, 2010 at 9:01 am
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...
February 22, 2010 at 6:02 pm
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...
February 22, 2010 at 5:37 pm
ChrisM@home
Surely...ORDER BY NEWID()
would be faster
An order by clause means a sort ... a 10 percent sample of a
We are currently taking a small sample from a 12-million...
February 22, 2010 at 4:47 pm
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...
February 22, 2010 at 2:36 pm
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...
February 22, 2010 at 1:44 pm
I'll look again the link
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...
February 22, 2010 at 12:14 pm
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...
February 22, 2010 at 8:58 am
Viewing 15 posts - 2,071 through 2,085 (of 3,221 total)