Topics
Started by
Posts
Last post
I am trying to replace a value from my select if the value from this column 'date' is equal to '000…
8 replies
Is there anyway to replace a NULL with 0 when using the PIVOT operator? Or is there some other way …
6 replies
I use MSAccess as my front end. We may move to VB.Net but that is down the road. When using a tabl…
5 replies
I am trying to capture an email address from the below message..whats the best possible way to do i…
7 replies
Calculating Difference between ClockIn and ClockOut by Job. Table : JobTran Job# ClockIn …
1 replies
Hi Everyone, Hope all is well. We can store date and time separately in 2008,but when we are using …
1 replies
i have a SP with where condition as where id=@id and month=@month and Eid=@Eid wht i need is if @Ei…
7 replies
I have some SQL I'm going to put in a stored procedure which will insert records into a temp table.…
11 replies
I have a crystal report that groups by provider alphabetically. For each provider, we have procedur…
2 replies
I have written a large complex stored procedure which produces a dataset of 39 items or so per reco…
4 replies
There may be a function in there already but I use only the barest minimum of the features. So Ple…
1 replies
I need to get the last modified value for each project and each owner -- SAMPLE DATA DECLARE @Audit…
2 replies
Hi, We have a number of SQL db environments for our CRM system, e.g. LIVE, TEST, DEVELOP, etc. and …
7 replies
Hi, I have a problem I would like to solve that I believe is possible with SQL query although I don…
7 replies
SELECT CONVERT(varchar,C.SCHED_DTTM,101) as DATE,C.INV_ITEM_ID ,SUM(C.QTY_REQUESTED) AS QTY FROM PS…
2 replies
Viewing 15 topics - 541 through 555 (of 12,234 total)
You must be logged in to create new topics.