Viewing 15 posts - 541 through 555 (of 2,894 total)
Since SQL2005 there is a much better way to do so:
CREATE ROLE db_executor
GRANT EXECUTE TO db_executor
The above will create database role which will have rights to execute all procs and...
March 19, 2013 at 9:03 am
ramyours2003 (3/19/2013)
what is query cache plan , list the dmv's to trouble shoot poor performance of a query in sql 2005/2008?
1. Google "what is query cache plan" - first link...
March 19, 2013 at 8:57 am
TheSQLGuru (3/19/2013)
Eugene Elutin (3/19/2013)
2) why aren't you using NEWSEQUENTIALID??
I don't know why OP doesn't, but me...
I don't use it because it's useless! It does not guarantee sequential order after reboot...
March 19, 2013 at 8:53 am
kapil_kk (3/16/2013)
I have solved it..... forget to initialize the IsBookelet variable value ;-):w00t:
You might solve it, but if you did it based on your CURSOR/LOOP solution, then it's just a...
March 19, 2013 at 8:25 am
Create PROCEDURE [dbo].[GetExtractSiteExtractFileBatchPreviousSuccessInd]
@BatchStatusCd NVARCHAR(5)
,@ExtractSiteCd NVARCHAR (10)
,@ExtractAsOfDate DATETIME
AS
BEGIN
SELECT case when @ExtractAsOfDate = isnull(convert(varchar(10),ExtractAsOfDate,120),'1900-01-01') then 0
when @ExtractAsOfDate <> isnull(convert(varchar(10),ExtractAsOfDate,120),'1900-01-01')then 1 else 1 end
as ExtractSiteExtractFileBatchPreviousSuccessInd FROM ExtractSiteExtractFileBatch
WHERE...
March 19, 2013 at 8:16 am
2) why aren't you using NEWSEQUENTIALID??
I don't know why OP doesn't, but me...
I don't use it because it's useless! It does not guarantee sequential order after reboot as it's just...
March 19, 2013 at 8:13 am
sestell1 (3/19/2013)
CapnHector (3/18/2013)
March 19, 2013 at 7:57 am
TheSQLGuru (3/19/2013)
Eugene Elutin (3/18/2013)
SELECT TransactionID, MIN(VoucherNo) , MAX(VoucherNo )FROM yourtable
GROUP BY TransactionID
Just a small point, but this only works as long as the values are fixed width and zero padded....
March 19, 2013 at 7:47 am
...Is it always guaranteed with Identity columns that they will be generated in the same order the rows were inserted?
No it's not. One of example can be this:
CREATE TABLE TestingTheData
(
ID...
March 19, 2013 at 7:43 am
What should your output recordset look like?
Two columns for DAYOFWEEK and SUBJECTS
Or multiple columns like: DAYOFWEEK, SUBJECT1, SUBJECT2, SUBJECT3, ...
If the second is right, is there known maximum number...
March 19, 2013 at 6:13 am
Sergiy (3/18/2013)
Eugene Elutin (3/18/2013)
March 19, 2013 at 4:03 am
Just replace
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL
SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1...
March 18, 2013 at 7:57 pm
skb 44459 (3/18/2013)
Command to runExec Rpt_OrderReport '1/1/2013' , '1/31/2013'
Need a code which will save the output to Text file with headers and column data pipe (|) seperated.
Why not use SSIS?...
March 18, 2013 at 7:44 pm
Jeff Moden (3/18/2013)
SqlServerLover (3/18/2013)
Thanks SSCrazy. Union all does not work in my case as i do not want two rows .........but left join worked.. thanks.
Since you said there was no...
March 18, 2013 at 7:40 pm
Sergiy (3/18/2013)
Eugene Elutin (3/18/2013)
First of all it's not quite polite to put statements in foreign language on English forum without translation. So, here we are:
As you pointed out this proverb...
March 18, 2013 at 7:06 pm
Viewing 15 posts - 541 through 555 (of 2,894 total)