Solomon Rutzky (6/27/2013)

---

Global Temporary Stored Procedures are very helpful when testing updated code...

i have done a lot of research but none of the standard 'fixes' have worked for me.

mayube it will for you?

http://social.technet.microsoft.com/Forums/sqlserver/en-US/8a753095-28b5-42b9-94ee-f894238ecc40/microsoft-report-viewer-crashes-internet-explorer-10-when-clicking-print-button

http://stackoverflow.com/questions/17031060/reportviewers-print-button-incompatible-with-ie-10

when clicking the print icon on the Report VIewer?

we have experienced this, also.

the column 'CustomerKey' in the subquerys SELECT is being referenced from the outer query DimCustomer_LLF.

could it be this?

http://books.google.co.uk/books?id=B83dXtOATAQC&pg=PA160&lpg=PA160&dq=sql+recasting&source=bl&ots=zDqKjtMqLq&sig=MBpNKa3xUJ65KBczUmT5iSSThpE&hl=en&sa=X&ei=tq-sUc7PLqWo0wWCy4GIDw&ved=0CE8Q6AEwBg#v=onepage&q=sql%20recasting&f=false

'Recasting in this context is the process of changing the data type of a column value from one type to another.'

is it possible, or even considered OK, to put all your different Members tables (Clients, Staff, Managers) into one table called 'Clients', and have a Foreign Key to a Table...

substring reads from Left to Right, not Right to Left as some Languages from non English speaking countries might.

so when you put '3' in to your substring, your asking for...

Mike Dougherty-384281 (4/18/2013)

---

OCTom (4/18/2013)

---

For example, one of the best interview questions I ever heard was: "If I asked you to make me a peanut butter and jelly sandwich, what...

WITH MyCTE(ClaimKey ,ARevDate ,ARowNum,CauseCode) AS

(

SELECT 123456789,20120101 ,1,'Fault'

UNION select 123456789,20120201, 2,NULL

UNION select 123456789,20120301 ,3,NULL

UNION select 123456789,20120401 ,4,NULL

UNION select 123456789,20120501 ,5,'Non-Fault'

UNION select 123456789,20120601 ,6,NULL

UNION select 123456789,20120701 ,7,NULL

UNION select 123456789,20120701 ,8,NULL

UNION SELECT 123456789,20120701...

even easier 😉

DECLARE @table TABLE

(

[Key] VARCHAR(50),

Value VARCHAR(50)

)

INSERT INTO @table

SELECT 'firstname', 'surya'

UNION ALL SELECT 'firstname', 'rakhi'

UNION ALL SELECT 'firstname', 'venkat'

UNION ALL SELECT 'firstname', 'shankar'

UNION ALL SELECT 'firstname', 'dany'

SELECT

[value] AS FirstName

FROM...

this is what i got.

not sure how to pivot the info to how you want it though, as the weekCommencing is not known from the start.

SELECT DISTINCT

--[WeekNumber],

COUNT(weekNumber) OVER (PARTITION BY...

TravisDBA (4/11/2013)

---

Asking an obvious question and expecting a different type of answer. Just read what he posted.

"Describe how you would program an elevator.

I spent the good part of an...

these two parts of your SP:

FETCH NEXT FROM crSystem

INTO @SubId

are doing a FETCH INTO on 1 Parameter, @SubID.

The select statement that your cursor is FOR is bringing back...

mister.magoo (4/9/2013)

---

Excellent, glad you got it working.

I would like to say I understood what you are doing with it and that it looked like a good solution, but I don't,...

hey, thats MUCH easier! and more efficient 😀

thanks

my final code is as follows:

select IndividualCode,RecNum,codeTagPosition,DateReceived from (

select *

, ROW_NUMBER() over (partition by codeTagPosition,RecNum order by DateReceived,codeTagPosition) as myRowNum

from (

select

...