What version of SQL Server are you connecting to?

geert.de.vylder (3/4/2013)

---

Hi ChrisM@Work,

Thank you for your reply. In attachment you will find the executionplan. The Tussen_Tickets table has at this moment 31779 records.

The query is almost correct. I only had...

prakashr.r7 (3/4/2013)

---

ChrisM@Work (3/4/2013)

---

prakashr.r7 (3/4/2013)

---

...

Yes...i am restricted, Chris 🙁 . This is how my functionality works. So i have to stick with it. no other option. Have to generate unique random...

Checking...

They're not guaranteed to be unique! Run this

declare @result...

Have you looked at alternative means of populating @result and @VendorCode in the following,

with a view to making the entire process set-based?

INSERT INTO SrcCodeMap (JurisID, CodeID, SrcCodeValueRef, SrcCodeValue, SrcCodeDescr,

PnxCodeValue,...

No, but you can cheat:

DECLARE @X TINYINT = 0

;WITH SampleTable AS (

SELECT SOMECOLUMNS = 'SOMECOLUMNS', COLUMN1 = 'COLUMN1', COLUMN2 = 'COLUMN2', COLUMN3 = 'COLUMN3',

COLUMN4 = 'COLUMN4', COLUMN5 = 'COLUMN5', COLUMN6...

SQL Mad Rafi (3/4/2013)

---

I have a view.

I made some changes (included few CASEs in SELECT list for a business requirement)

i did a relative cost check between these old and...

SELECT RIGHT('Feb 18 2013 3:35PM',7)

winmansoft (3/4/2013)

---

...

If i have table with 1000 rows and say 10th row date is '03-01-12' and all other 100 dates are above '03-01-12' and 101th row date is...

Right now by accident or in the future by design?

...

2. One Software will be used in multiple computers and one computer...

wafw1971 (3/1/2013)

---

Thanks Chris, I have figured it out now:

Declare @From Datetime

Declare @To Datetime

Set @From = '07 Jan 2013'

Set @To = '18 Mar 2013'

SELECT Datediff(Week, dateadd(dd, CASE WHEN...

Post the actual execution plan...

What happens if your initial FROMdate or TOdate happen to be a sunday? This batch shows solutions either way:

-- Recalculating startdate

;WITH SampleData AS (

SELECT TheDate = CAST('06 Jan 2013' AS...

BSavoie (2/28/2013)

---

Thanks all for the great advice. Rewriting the sproc is not an option at this time. Since this is just a wrapper around the real work horse, I guess...