Viewing 15 posts - 3,151 through 3,165 (of 6,036 total)
REPLACE(STR(quantity, 4), ' ', '0')
_____________
Code for TallyGenerator
January 29, 2008 at 5:44 am
SQL Server will always take as much memory as you allow it to take.
It uses it to cache execution plans, returned resultsets, derived tables, etc.
It does not erase it until...
_____________
Code for TallyGenerator
January 28, 2008 at 4:31 pm
I am hoping to rewrite all this into 1 stored procedure using derived tables.
Any reason for this?
_____________
Code for TallyGenerator
January 28, 2008 at 3:52 pm
Just in case @TblName has space or another special charachter:
exec('Select * from ' + QUOTENAME(@TblName) )
_____________
Code for TallyGenerator
January 26, 2008 at 4:35 am
Chirag (1/25/2008)
what about using transactions ? then you can use GOTO .
OP already answered this question/
"If quit command GO, I can't use DDL commands, like ALTER FUNCTION and others."
CREATE...
_____________
Code for TallyGenerator
January 25, 2008 at 5:24 am
You must have missed parameter -b.
_____________
Code for TallyGenerator
January 25, 2008 at 5:07 am
When you run same query second time SQL Server does not actually execute it, it uses resultset stored in cache.
Try to run
DBCC FREEPROCCACHE
after 1st execution and run query...
_____________
Code for TallyGenerator
January 24, 2008 at 3:12 pm
Yes, I understand it must be time SQL Agent needs to record job/steps history.
But isn't it too long?
On none of other servers it takes more than 1 second, even on...
_____________
Code for TallyGenerator
January 24, 2008 at 2:11 pm
DECLARE
@KOD_1 SMALLINT,
@KOD_2 SMALLINT,
@KOD_3 SMALLINT,
@KOD_4 SMALLINT
SELECT
Field1 ,
Field2 ,
Field3 ,
Field5,
Field6,
Field7,
Field8,
Field12,
DBO.Fn_Get_something(Field4,Field9,Field10,Field11)
FROM table1 DBG WITH (NOLOCK)
JOIN table2 POL WITH (NOLOCK)
ON Field3 = table2.someField1 AND DBG.teudat_zeut = table2.someField2
AND table1.someField3 = table2.someField3
AND table2.someField4 =...
_____________
Code for TallyGenerator
January 24, 2008 at 12:48 pm
Did you try to run scripts from osql?
_____________
Code for TallyGenerator
January 24, 2008 at 12:38 pm
Backup database and if error happens during deployment restore the copy from backup.
_____________
Code for TallyGenerator
January 24, 2008 at 3:39 am
Loner (1/23/2008)
You can use global temp table ##temp. However you will need to delete it after you are done, otherwise it will stay in tempdb.
Problem is OP needs
a table...
_____________
Code for TallyGenerator
January 23, 2008 at 4:42 pm
I don't see what's your problem.
As soon as you allow users to shift the columns you don't care about datatypes. They all gonna be displayed as strings anyway.
Then nothing stops...
_____________
Code for TallyGenerator
January 23, 2008 at 2:29 pm
Jeff Moden (1/18/2008)
Delimiter of "," (including the quotes) is perfect for "real" CSV instead of "comedy separated values".
Delimiter of "," is as good as '[' + @TableName + ']'.
Works almost...
_____________
Code for TallyGenerator
January 23, 2008 at 2:15 pm
lucky (1/23/2008)
Hello Brett,Instead of writing a stored procedure why don't you convert the same to a function and return the count of downloads.
Because it will do 2 queries against...
_____________
Code for TallyGenerator
January 23, 2008 at 7:01 am
Viewing 15 posts - 3,151 through 3,165 (of 6,036 total)