Topics
Started by
Posts
Last post
Hi, I have to create a view to query a GL table and consolidate amounts based on periods. The table…
6 replies
I've table and data as following, CREATE TABLE [dbo].[t_A1]( [idx] [int] NULL, [batch_Id] [uniqu…
1 replies
SELECT COALESCE(sum(A.AmountGiven),0) AS AmountGiven , A.YearToDate, A.EndDate FROM (SELECT (SELECT…
4 replies
I have a table with Million plus records. Thanks to the help of the Running Totals article and some…
7 replies
I have set Report From & To date parameter in my SSRS report to default values. When previewed…
1 replies
The stored procedure accepts a TVP table as a parameter. Will something like this work? BEGIN …
5 replies
Hi All, Need one help with the query. Consider the below query CREATE TABLE #TEMP (PlayerName varc…
13 replies
Hi everyone Hope some one can offer some advise on this one. Know what I want to do but don't unfor…
12 replies
Hi, Stuck with a problem and need help in resolving it. I have a column with the following infor…
5 replies
Hi Folks, I am trying to optimize a report and will try to keep my question very simple. I have a t…
12 replies
Good afternoon! I'm writing a query that will be used in Jasper Ireports, but prefer to have the v…
1 replies
My table and data as follow, GO /****** Object: Table [dbo].[process_ApplyJob_1] Script Date: …
19 replies
How can I get the data retrieved from the exec function below into Excel DECLARE @columns NVARCHA…
5 replies
Hi all, I've a request: I've a table with a date column and an if numeric data type. I've to check …
1 replies
I was wondering if there was a more simple way to accomplish the following. Currently I have a sta…
3 replies
Viewing 15 topics - 1,831 through 1,845 (of 10,647 total)
You must be logged in to create new topics.