Topics
Started by
Posts
Last post
Hi, I have the folloiwing table: DECLARE @Table TABLE( CMBAmt decimal(18,2) NULL, PDAmt decimal(18,…
3 replies
I'm running a query which returns results fine when run alone but when I try to put it into an XM…
2 replies
Hi, I have a table structure similar to the following code. DECLARE @PatDev TABLE ( PID INT, Vis…
2 replies
Hello, I am trying to sum by GL Account Description when I run the query I do get sum, but broken o…
7 replies
Hi TSQL Gurus, Need small help. Basically, looking of a query which will give me the number of time…
9 replies
Hi, I've run into a tricky issue where I need to create groups based on the combination of location…
3 replies
Trying to convert datetime to varchar(10), typical stuff. Only problem is, it's not working. This f…
2 replies
I have 3 tables A,B,C Here are column and field names A:app_no,app_name,app_add B:b_no, B_code,B_ra…
1 replies
I have a database that was in Access, the amount to SQL Server and there, want to make a query to d…
3 replies
I want to ignore the "Sale" transactions from FIFO processing where no preceding buy transaction is…
8 replies
My assignment is to break down a series of dates into week, month, quarter, and year chunks. The tr…
3 replies
Hello Good Morning, Can you please help me with this phone numbers formatting, create table #myphon…
7 replies
HI Can some one help me in solving this. I have a situation where I have to calculate Employee time…
13 replies
Hello I have the following relatively simple code that's part of a much bigger query: declare @dat…
3 replies
i have a query that gives me the attendance of students in a school the attendance will very in day…
3 replies
Viewing 15 topics - 2,026 through 2,040 (of 4,984 total)
You must be logged in to create new topics.