Topics
Started by
Posts
Last post
I would like to write a stored procedure that use the date range for the different sum and count fu…
18 replies
Hello Experts I want to look at the various characteristics of the tables in which a column with a …
5 replies
Hi there, I have a db table with over 800 lines representing pathways. Each pathway contains a popu…
3 replies
This code:SELECT '1) Total non-employees terminated' AS DESCRIPTION, COUNT(*) AS AUGUSTFROM v_xyz_…
4 replies
Taking AdventureWorks as example 1. Create New Table CREATE TABLE Insert1&nb…
3 replies
I want to write a query to calculate the year to date value for a given date:Example: If the given …
8 replies
hii am using sql 2005.table 1 structurefk_id, line_number, mtr_value_100, mtr_value_102,mtr_value_2…
5 replies
How can I join all the results of the below query into a single result set?Thanks exec master..sp_M…
6 replies
I would like to get year to date of total qty and total value fields for the current and for the pr…
3 replies
Hello comunityI will some help to modify my CTE for working on SQL Server 2008, this is my CTE: DEC…
6 replies
I've got an interesting one with a date in a query. The first where clause in the query runs in 30 …
5 replies
Hi I have an Update trigger using binary_checksum to determine differences in many fields.&nbs…
6 replies
By: Sue_H
We have a very silly weekly process toto do the Full Load of 5 year data in to Qlikview Application…
12 replies
Good morning,I have written a query that returns up to 4 rows of a distinct result;Results 1.…
11 replies
By: mbrady5
I want to get the financial Year for a date. I have this: (Year(DateAdd("m",-3,[MyDate]))) + ' - ' …
3 replies
Viewing 15 topics - 286 through 300 (of 10,647 total)
You must be logged in to create new topics.