Topics
Started by
Posts
Last post
I am trying to get unique records for each item_id. Sample data is: Order_no Item_id UOM Date_Creat…
1 replies
I need your help from expert SQL. I have table name tblCalcHeader have about 25000 records count th…
5 replies
I need to solve for the customers last entry in a table and then see if it meets criteria I am tryi…
1 replies
I would like to add records to table AppointmentContact using a subquery as well as pass in a value…
1 replies
Hi All, I have fine tuned a query from 4 hours to 5 minutes. I have execute the same query( fine tu…
11 replies
I'm trying to use the stored procedure below in SQL Server 2000, but I get the following error; Se…
9 replies
I need to select only a part of a text string.... I have the following 3 rows... Provider PraNum="3…
11 replies
While running this query: SELECT DISTINCT Tools.UUCBIM, Tools.JOBNOF, Tools.FITEMF, Tools.ITDSC, T…
5 replies
I subscribe to Sql Server magazine. I've noticed that every articl that Itzec -Bengan writes, he u…
8 replies
I have a query that has a case statement CASE when ((100 * inventory_supplier.cost * 1.1) / (100.00…
6 replies
I have a table that I have no control over the structure of from which I need to pull data. The dat…
7 replies
I have an old web app written in classic asp and the following SHAPE command works perfectly: SUB s…
1 replies
IF OBJECT_ID('TempDB..#tblInv','U') IS NOT NULL DROP TABLE #tblInv CREATE TABLE #tblInv ( ID INT , …
16 replies
Hi, Can any bodyhelp me? I need a Tsql which gives the details of Login and Logout of MSSQL2000 use…
2 replies
There are 10 similarly named tables (in the same database): table01 table02 table03 table04 table05…
16 replies
Viewing 15 topics - 2,026 through 2,040 (of 17,082 total)
You must be logged in to create new topics.