Viewing 15 posts - 61 through 75 (of 88 total)
+1...Exactly... you may want to work on the data set as it is the source of duplicate records... If duplicates are there in source then report is mere medium to...
February 12, 2014 at 11:17 pm
Wouldn't setting HideDuplicates property of the report field work in this case ?
February 12, 2014 at 11:12 pm
I tried to reproduce this but was not able to do so. Though you have mentioned it but could you please confirm once again that it works in SSMS with...
February 12, 2014 at 11:09 pm
You may try this
UPDATE Hosea_tempTable
SET Product_Id = CASE
WHEN @NewProduct_Id <> '' THEN @NewProduct_Id
ELSE NULL
END
,Fund_Id = CASE
WHEN @NewFund_Id <> '' THEN @NewFund_Id
ELSE NULL
END
WHERE Product_Id = @Product_Id
February 12, 2014 at 12:35 am
Take a look at
https://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/
it will give you some clues
February 11, 2014 at 8:24 am
Thank you for that Service pack was applied and got my Inner peace...
February 11, 2014 at 5:56 am
It can be addressed using repair_allow_data_loss.. but you might loose some data ... Please read more on repair_allow_data_loss option that CHECKDB provides here http://technet.microsoft.com/en-us/library/ms176064.aspx
February 11, 2014 at 5:49 am
I'm just throwing this to table so I could be completely wrong here ...experts would be able to put insight ...I think it be done using a batch file .....
February 11, 2014 at 5:43 am
Creating Non-Clustered index might suffice your need...Before removing index from unique column please do think about the queries which are mostly run against the table in the discussion... Please do...
February 11, 2014 at 5:33 am
Exactly... that is what I tried before posting reply... it clearly shows that it should give 8 as an output but I did not get it... am I missing something...
February 10, 2014 at 11:17 pm
@ ChrisM@Work - What you did is actually a easy way out. thanks for bursting my bubble ..This has prompted me to learn how APPLY works.. This is one of...
February 10, 2014 at 11:14 pm
You are welcome.
is the query correct ? I mean is it what you were looking for ? if yes, then the output that it is generating is as per...
February 10, 2014 at 6:13 am
Would something like following do ?
SELECT Customer_Name,SUM(price) as Total_price,MAX(DatePurchased) as DatePurchased FROM #sample
GROUP BY Customer_Name HAVING SUM(price) >= 1000
February 10, 2014 at 5:32 am
That means .. it is the version of a SQL server against which you ran the query.
February 10, 2014 at 4:47 am
I'm sorry but I did not understand the requirement. Could you please explain it further ?
Additionally please try and provide create, insert statements for the sample data and the output...
February 10, 2014 at 4:39 am
Viewing 15 posts - 61 through 75 (of 88 total)