|
|
-
|
|
Hi ,
I am not much touch in database programming but have to include trigger for this following table in one of my subprograms so please can anyone suggest a solution for it
as I am days stuck on these for days and not able to get it .
customer(custno...
|
|
-
|
|
Hi Jacob,Thanks for reply in my earlier post.Now the requirement has changed slightly. Need to generate the XML from the single table.Please find the complete explanation for the same @ : http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/...
|
|
-
|
|
Account.
How can i use calculate filed to get min of measure for each members?.
Any help ?
Thanks in advance.
Nidheesh pv
...
|
|
-
|
|
So I have this table that registers inventory transactions that had happened on a particular date.
I need to match the selling articles with ordered price in a fifo order. This should occur for every transaction not as cumulative for the article. I...
|
|
-
6
Replies
| 1
Answers
| 1
Suggested
|
|
Dear All,I have 2 data source one is SQL and other is ORACLE Data source i am fetching data in oracle data source and insert in SQl table then i m running Some validation job for data,in SQl table i have one Error flag column to show error datanow i wan...
|
|
-
|
|
I am trying to use sqlfilestream() in asp.net but I keep on getting "The process cannot access the file specified because it has been opened in another transaction"
Any help is appriciated!!!!
Thanks,
Al-
Error Line 82:
Line 81: //Open ...
|
|
-
|
|
I've the following query: DECLARE @behvName VARCHAR(256)
DECLARE @envName VARCHAR(256)
SET @behvName = 'NewData.BL'
SET @envName = 'dvnt'
SELECT A.* FROM
(
SELECT
ckt.Name ...
|
|
-
|
|
3 classes are there in 3 assembles A,B,C .Out of this B can inherit A but C can't inherit A.Can we achieve this?if YES how?...
|
|
-
|
|
After numerous searches I can't find a query that 'properly' reports the status and execution messages of SQL Server Agent job steps. Many seem to depend on unreliable information like the run_date & run_time for grouping and most don't address the...
|
|
-
|
|
Hi, I have 2 measure in my cube and i need to calculate MEAN and MODE values for those 2 measures.
...
|
|