Topics
Started by
Posts
Last post
Hi All, i'm getting error with the below query but i don't now why? please help. Query: SELECT dbo.…
3 replies
I can do a select count from a table, no problem: select BUSINESS_UNIT, ASSET_ID, count(*) from FS.…
6 replies
This is a parameter passed in.... DECLARE @D_production_date_time SQL_VARIANT ---- DECLAR…
9 replies
Hello Experts, Below is the data from table : EmpidDate PA 30001/12/201010 30002/12/2…
12 replies
I know this is an older version of SQL, but I am trying to simplify some year end reporting and nee…
2 replies
Hello, I have a problem in one of my production server database. when i execute following query in…
2 replies
We have SQL SERVER 2000,that some times we receive the following error messages.This happens random…
3 replies
hello My problem is i want to sort only user tables in database only i use SP_tables…
2 replies
I have a job which is is taking almost 4 Hours everyday, This job just gets the data of almost 40 t…
2 replies
Hi I have a transaction table (Invoices) and a CurrencyTable. In Currency table Currency Exchnage…
2 replies
Could you please tell me what kind of queries need temp or table variable table? thanks.
39 replies
I have a list that produces the following (sample data) DetailName …
5 replies
Hi All, I'm try to use the below query but actually it gives "Grouping" error please help what is w…
1 replies
I have the following query: SELECT DISTINCT [ScratchPad5].EmployeeNumber, Sum([ScratchPad5].sumhour…
6 replies
I have the following issue: I have customerID field saved into a #Temp table. There are 128 records…
8 replies
Viewing 15 topics - 751 through 765 (of 17,082 total)
You must be logged in to create new topics.