Topics
Started by
Posts
Last post
Problem How to make query Substract AmountDue For Invoice from Customer Balance Balance Customer qu…
3 replies
dear Friends, Kindly help me, I want to make a syntax that compares if the number of rows in table …
13 replies
Hi , Please help in writing the query to get the below result i have a Requested details table whic…
4 replies
Hello everyone! First time posting and i'm sure this is going to be an easy one as i'm not a SQL de…
6 replies
I create a store procedure with Begin and Rollback transaction with Being Try and Catch and GOTO st…
6 replies
I have a pivot query as below. This pivots the data in ev as column and calculates count. Some…
3 replies
Hi,I've got a fairly simple data flow that loads from a flat file to a sql server table. According …
6 replies
0 Sign in to vote …
7 replies
Same sql in prod runs in 23 min and in QA/test it is 11 min.Since the QA db is refreshed from prod …
6 replies
Hi, Does anyone know how to create a set of date ranges from existing ranges to create a uniq…
1 replies
Good morning, I have a "insert into select" script that copies records from a database I…
5 replies
We have production and development environment both support. I want to configure SQL Server to noti…
4 replies
I have a sample table and its data as below: CREATE TABLE [dbo].[ProductBMRate]( &…
2 replies
Hi all!I have this query:SELECT Per.per_personal_id,EMP.vacation_model FROM dbo.personal PERJOIN db…
3 replies
Hi, I would like to store the first "select" result into a variable to be able to declare it within…
4 replies
Viewing 15 topics - 556 through 570 (of 4,984 total)
You must be logged in to create new topics.