Topics
Started by
Posts
Last post
Hi, At work I have a new data set, where a product can have extras added. The data records a time …
4 replies
3 tables : 1. POS (Material, Customer, day, POS) 2. Material (Material, MATL_TYPE, MATL_GROUP, MKTG…
4 replies
I have the table like the following EmployeeIDEmployeeNameBasic HRA ProcessingMonthPr…
3 replies
Hello, I appeal for help on a sql method to eliminate values considered as "duplicate" on ea…
4 replies
Dear good reference have a consultation with relation to the function of aggregation, in reality PI…
1 replies
Source of the transaction table. How do I build the "Results" column to see the time difference bet…
5 replies
I am trying to get my data into one row. I am trying to pivot this but no luck Here is the start da…
1 replies
How can I avoid a cross join for the following query? SELECT a.Week, a.StartDate, CASE WHEN purchas…
2 replies
Hi, We have run into a unique issue and we are having trouble finding any documentation on how to h…
2 replies
how I can capture an error message returned by a stored procedure, and puts it into a variable. tha…
2 replies
Hi All! I have this table: [dbo].[Login_details]( [login_data_id] [int] IDENTITY(1,1) NOT NULL, […
3 replies
I want to update the value of an attribute in an XML column by using the data returned from a subqu…
3 replies
Hi, Recently I got a task to find for the duplicate records on a table. And I have written the belo…
2 replies
SELECT @battery_included = COALESCE(@battery_included + ';', '') + CONVERT(VARCHAR(200),Item) FROM …
5 replies
Hello, I am very new and using PostgreSQL. I am asked to write a query that gives me new user cou…
2 replies
Viewing 15 topics - 76 through 90 (of 4,155 total)
You must be logged in to create new topics.