Topics
Started by
Posts
Last post
So I have the ODBC connection set up and working fine between the SQL server and my AS/400. I can …
1 replies
I am quite new to SQL and programming languages. What I am trying to solve with this sproc is to in…
4 replies
Does anyone know why this sql query doesnt work: incorrect synthax near group by SELECTS.SubSectio…
8 replies
I am in an urgent need of some help I have a database named timetable on server1(domain 1) and have…
2 replies
We have a table called ptInsurancePlans. It has columns named MRN (Medical Record Number), CarrierI…
3 replies
I have a table that I have no control over the structure of from which I need to pull data. The dat…
6 replies
Can someone direct me to some help on where to find out how to pass the results of one query to ano…
4 replies
Hello Experts, Is there something like an Identity that resets for each group? In the sample table …
3 replies
--This part of the query returns incidents that were created between 6:30am and 6pm for a range of …
5 replies
use tempdb go create table totalsum (untiprice money null, productoption int null) insert into …
1 replies
I have a query that I wrote to find the user names in a login table that have been inactive for mor…
2 replies
Hi, I'm trying to figure out how to "conditionally" require a couple of input parameters. Based on…
6 replies
ALTER PROC prodTool.CalculateTaxablePrice --@productId int, --@taxablePrice decimal = 0 AS --IF(EXI…
3 replies
Im using the WITH(INDEX(indexName)) syntax to help me reproduce execution plans purposfully, so as …
4 replies
I have a query SELECT A.SOLD_TO_CUST_ID, C.NAME1, DATEDIFF(DAY, (CONVERT(CHAR(10),B.STATUS_DT,121))…
7 replies
Viewing 15 topics - 7,801 through 7,815 (of 12,230 total)
You must be logged in to create new topics.