T-SQL (SS2K5)
-
Topics
-
What makes stored procedure results not bookmarkable
I am working with an application that imports data from tables or stored procedures that return rec…
-
updatetext help
I have searched around the forum and tried a few times on my own, but we have a need to quickly mak…
-
Trying to Calculate Date Differences Between Same Records in the Same Tables.
I have a table with items and their order dates. I am trying to calculate the differences betweeen …
-
PIVOT & TRANSPOSE
All, I am working on a different requirement (according to me
) to transpose the dynamic column i… -
Running Stored Procedure from Access
Hi, I have not used Stored Procedures before so am unfamiliar with the syntax. I would like to run …
-
Nested Set Model and Bill of Materials
Hello everyone. Can someone point me to a decent tutorial on how to create Bill of materials using …
-
Filter returned records based on MAX/Last date found
Hi, My original query contains many table joins where I need to filter on the returned values. This…
-
Hierarchical Dataset using a Self-Referencing Table
Hi All, I have a question that I've seen some various posts on but none quite getting what I want. …
-
Need to Extract Data From a Column
I have a table that looks like this: flowname UPDATE: PurchaseOrderLines 104142-2-0 UPDATE: Purchas…
-
need help
I have a table as below (Table1) State City KA Bang KA …
-
Help/Solution - "Sum( CASE( DateDiff" calculations
Hi all, I am trying to do something quite simple - but am having trouble and not sure if it is a pr…
-
How to find previous value and display per row
Hi all, I have a following table CREATE TABLE #Records ( [ID] INT, [Date] DATETIME…
-
Help needed with query where matching or last date found
Hi, I have the following SQL query with 2 issues: SET DATEFORMAT YMD SELECT * FROM AX4KWT_LIVE..Pu…
-
Help Resolving This: Msg 130, Level 15, State 1, Line 3 Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
Any idea how to resolve this? select count(distinct d.sn) as quantity, sum((l.labor) / 1000) as la…
-
How to show Opening Stock of previous day
I have separate table of transaction like purchase, sale, receive, transfer and master table where …
Viewing 15 topics - 1,651 through 1,665 (of 12,234 total)
You must be logged in to create new topics.