Topics
Started by
Posts
Last post
This code works perfectly, SELECT distinct Customer_Number, SUM(Price) As Total FROM Customer_Offer…
5 replies
We've been chasing this issue for a couple weeks now and are ready to call Microsoft.. Our last att…
8 replies
wat is the difference between the following code:- USE EVENT GO DECLARE @CurrentDate datetime SET @…
5 replies
I have a database that I shrank. Looking in the properties of the database I see it has a size of 1…
6 replies
Okay, I've got an access 2007 FE connecting to a SQL 2008 BE. I seen several posts about connectin…
26 replies
Query 1 :update a set lb ,b.Pl*-1 from dctran a ,cont_prof_loss b where a.new_hpano=b.hpa_n…
2 replies
I was poking around and found four sys.dm_db_missing_index columns;details;group_stats;groups DMVs.…
1 replies
Hello, I have a query that's pretty bulky due to dates only, and I'm sure there's a better way. It…
4 replies
I have come accross an interesting database design where some of its tables (not central) have not…
22 replies
Hello, I am testing the first part of an SSIS package and getting stuck on a date column. SELECT &l…
3 replies
I am getting the Errors "Unable to copy file "j:\users\gary\documents\visual studio 2010\Projects\…
3 replies
Desc : Maximum Quota is up to Cust and Basket, If Cust pick goods once time with amount over maximu…
1 replies
SELECT e.Pid, e.ProductName__c AS Last_Evaluation_Product__c FROM Customers.dbo.Lead AS…
2 replies
I've written a SP (sorta...) to retrieve the PO ID I should charge for a given days' work. Here's t…
2 replies
Hello, I'm trying to get my query to compare dates, but it gives me an error stating that Text or V…
13 replies
Viewing 15 topics - 2,911 through 2,925 (of 5,050 total)
You must be logged in to create new topics.