I have a table that looks like this….
View Complete Post
View Complete Post
I have a requirement to populate sharepoint form field value with query string while uploading document to document library.
While uploading the document to document library, I want to populate claim number available from query string in a pop up page i.e in my case EditForm.aspx, Located at
Any help on this would be greatly appreciated.
Thanking you in advacne.
I am of the opinion that the query below can be written using a windowing function instead of the self join.
Can anyone help with this please.
FROm #hold a
where TransactionDate = (SELECT MAX(TransactionDate) FROM #hold b where b.PersonURN = a.PersonURN and b.DealerID = a.DealerID)
Using SSRS 2008 and SSRS 2008 R2. Found a similar post from a couple years ago but with no satisfactory answer...
It seems to make sense that aggregate functions would be applied only to data that has not been filtered out by a group filter, e.g. if only a portion of the detail or group rows are being displayed because of a filter on that group level, then displaying
an aggregate value for the rows such as a count or sum should only include the data that is included on the report. And the following MSDN documentation seems to state just that:
It states that an aggregate function's scope, when it is a row or column group, "specifies the data after the group expressions and group filters are applied for the parent group and child groups. For the purposes of identifying scope containment, every
parent group contains its child groups."
However, that doesn't seem to be the case. The aggregate function is applied over all of the rows within the grouping expression, including those that have been filtered out, which seems to make the group filter fairly useless, considering that one of the
most common reasons for grouping in the first place is to provide aggregate totals, sums, averages, etc. for the c
I have the query below and I am trying to use historical queries to retrieve the information, I have put something together but running the Original query and my new query does not bring back thesame results, but i think I may be doing something incorrectly.
DECLARE @XML XML
SELECT @XML = '<XML Id="Hello"></XML>'
SELECT c.value('.', 'VARCHAR(MAX)') FROM @XML.nodes('//XML') T(c);
This results in a [XML Reader] and a [XML Reader wuth XPath filter] and the cost is 1.004 for each operator.Running tests show that they are both quick, but I am writing a stored proc for a high transaction system and always try to keep the query plan as low as possible and would not n
i've facing this problem in my program..
Dim a As Integer = 1
Do Until a = 12
Dim con As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim cmd As System.Data.SqlClient.SqlCommand = New SqlCommand
cmd.CommandText = "update it_report set network=(select count(*) from tbl_form_it_service where usercase in ('NETWK') and datepart(year,reportdatetime)= '2010' and datepart(month,reportdatetime) = " & a & ") where year=2010 and month= " & month & ""
cmd.Connection = con
DataGrid1.DataSource = cmd.ExecuteReader()
Catch ex As Exception
Message.Text = "Error! " & ex.ToString
a = a + 1
how can i insert loop statement variable into the query?? and how to insert textfield id in the query also? 2010 will be textfield value.help me, Thanks,
I need to use a variable in a sql query used in a stored proc as follows:
Declare @Src varchar 100
Select * from @Src