|
prithaa wrote: I think there is a version problem with SQL server
Nope the pivot structure is TOTALLY different in SQL Server. Do the following.
1. Get SQL Server
2. Research and create you pivot select statement in SQL Server. There are a number of posts and articles on CP to help with this
3. create a stored proc to execute the pivot select.
4. connect to sql via your DAL and execute the stored proc
5. use the result set returned to bind to a grid for display (C#/VB)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hello,
Thanks for you replies
I will search for the select in SQL server
but one last question.
If the query works in Access and gives the Pivot view then can I make pivot table in a seperate table.
Pritha
|
|
|
|
|
I beleive you can use Select ..... Into NewTableName
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have try to use ado AppendChunk() fucntion in vc++6 to save to a clob data type to oracle database, but when i read back, the data was not save to the oracle database. Anyone know what is the problem?
// BEFORE THIS FUNTION, ORACLE DATABASE WAS CONNECTED
bool ADODBHandler::UpdateMap()
{
AdoNS::_RecordsetPtr rst;
try
{
..........................
rst.CreateInstance("ADODB.Recordset");
rst->CursorType = AdoNS::adOpenKeyset;
rst->LockType = AdoNS::adLockOptimistic;
HRESULT hr = rst->Open("pcmap.WAFERMAP3_PROCESSMAP", _variant_t((IDispatch*)m_cpConnection,true), AdoNS::adOpenKeyset, AdoNS::adLockOptimistic, AdoNS::adCmdTable);
rst->AddNew();
rst->Fields->GetItem("LOTNO")->PutValue(lotno);
rst->Fields->GetItem("WAFERNO")->PutValue(WaferNo);
rst->Fields->GetItem("WAFERID")->PutValue(Waferid);
rst->Fields->GetItem("PROBER_FILE")->PutValue(ProberFile);
rst->Fields->GetItem("ORIENT")->PutValue(Orient);
rst->Fields->GetItem("ROW_COUNT")->PutValue(RowCount);
rst->Fields->GetItem("COL_COUNT")->PutValue(ColCount);
rst->Fields->GetItem("PASS")->PutValue(Pass);
rst->Fields->GetItem("FAIL")->PutValue(Fail);
rst->Fields->GetItem("SOURCE")->PutValue(Source);
rst->Fields->GetItem("ET_TIME")->PutValue(date);
rst->Fields->GetItem("MAP_VER")->PutValue(Ver);
rst->Update();
_variant_t varChunk;
varChunk.bstrVal = _bstr_t(cWafer); // cWafer is a char array about 2500 bytes long
// for some strange reasons, cannot save varChunk to database and no exception error was capture
rst->Fields->GetItem("MAP")->AppendChunk(varChunk);
rst->Update();
}
.........
}
|
|
|
|
|
hi all
how can i convert the code below to sqlserver2000?
USE db1
DECLARE @Definition nvarchar(1000)
SELECT @Definition = definition FROM sys.all_sql_modules INNER JOIN sys.all_objects
ON sys.all_sql_modules.object_id = sys.all_objects.object_id
WHERE sys.all_objects.name = 'YourObjectName'
USE db2
EXEC(@Definition)
|
|
|
|
|
Hi every body,
i have reservation table which contains folowing columns
Reserve_ID, vehicle_Name,ReservestartDatetime,Resetrveenddatetime,purpose
i want to write a query that prints records agains each vehicle for suppose one vehicle is reserved two times in day i want to print those records on a single row .
i know i have to use query and sub query concept but how i wrtie a query for that.
else suggest me a good way to do that .
Reagrds
Rameez
|
|
|
|
|
Take a look at this thread, leo came up with a good result
clickety[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi fellows i am learning about sql in my class and am shacking my head up after recalling about MS SQL 2005 Transaction log files. I have to recover a table that was droped at certain time of inteval from Trans-log file. I opend the file and found out its a binary file you can't really read it easily. How can I reterive a table from Translog file. I remember I ask this in class and my teacher said that look at the time stamp in Transaction log file up to the point you want to recover. Do you fully agree if not any better solution
Thanks
|
|
|
|
|
I need to find the max value and the date it happend in a table that has 3 columns. I can get the MAX value but have not been able to get the corrosponding date from the record.
Table structure is...
ID, UTCDateTime, Value
This is the query I've been using to get MAX value
SELECT MAX(value)As MyValue
FROM Tablename
Can some one point me in the right direction??
THX
meh
|
|
|
|
|
Would be nice to pickup the first record from a sorted view. Something like:
Select Top(1) ID, UTCDateTime, Value
From TableName
OrderBy Value Desc
Syed Mehroz Alam
|
|
|
|
|
if you really want to do it that way you can do
SELECT TOP 1 MAX(value) as MyValue, UTCDateTime
FROM TableName
GROUP BY UTCDateTime
you have to have the top 1 otherwise you will get all of the max values for every dateTime, in descending order..
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Thanks for the replys but....
Both of these examples only return the first record it finds not the largest value
meh
|
|
|
|
|
Post your data how is stored on table and post result which you want to get.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
This seems to work....I jusk stumbling around until this happened.....
SELECT ActualValue, UTCDateTime
FROM dbo.tblActualValueFloat
WHERE (ActualValue = (SELECT MAX(ActualValue) AS Expr1
FROM dbo.tblActualValueFloat AS tblActualValueFloat_1
WHERE (PointSliceID = '782') AND (UTCDateTime - 0.167 > '5/1/2008')
AND (UTCDateTime - 0.167 < '6 / 1 / 2008'))) AND (PointSliceID = '782')
AND (UTCDateTime - 0.167 > '5 / 1 / 2008') AND (UTCDateTime - 0.167 < '6 / 1 / 2008')
I know there are some hard coded test variables but this seems to be working for now.
Thanks to all
meh
|
|
|
|
|
Hi all,
Please help me with the below sql query
I am having 4 tables
SML,SMG,SMS,TKM
I have to retrive records
2 columns from table SML
1 columns from table SMS(the mapping from table SML and SMS is through SMG for eg: using the foreignid of SMG in SML we get the foreignid of SMS in the table SMG, using this i have to get the column from the table SMS)
1 column from table TKM (the mapping is SMS and TKM directly using the foreignid of TKM in the table SML)
Table SML:
ID Name idSMG IDTKM
Table SMG
ID idSMS
Table SMS
ID Name
Table TKM
ID Name
Thanks in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
What have you come up with so far?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi,I am new comer of sql server2005.How can I know the database version through query.Pls help me
|
|
|
|
|
SELECT @@VERSION
Next time i will not give you an Answer, you must First Google before you post here on the Forum.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
I know this query.By this I know the version of sql server.Can I know the version of master database or user create database version.
|
|
|
|
|
hi I dont Understand what you want.
Forum: SQL and Database discussions
Subject: Re: Know the Database version
Sender: Sritanu _ Ghosh
Date: Friday, August 1, 2008 2:46 PM
Does a Database have a Version ?
Am not sure what you want. ok
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Vuyiswa Maseko wrote: Does a Database have a Version ?
I think he wanted to ask the compatibility level(SQL 7.0/2000/2005 etc).
Here's the GUI process:
In the management studio, right click on the db -> select Properties -> click on Options -> the Compatibility Level is displayed along with the collation and recovery model.
But I dont know how to retrieve it using T-SQL.
Syed Mehroz Alam.
|
|
|
|
|
i was Suprised , lets hear if this solves his Problem. 
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Is this what you are looking for ?
SELECT name, compatibility_level FROM sys.databases
Please... SAVE my time by rating the posts that you read!
There are 10 kinds of people in the world: those who understand binary and those who don't.
|
|
|
|
|
Please help...
Is there a way when I use initcap to make any letters displayed after an apostrophe be lowercase?
thanks in advance!
|
|
|
|
|
Please i need help...
Can somebody explain me how can i implement an insertion trigger that inserts in another table.
Like i have one table wich i want to insert a new record but when i insert a record in the first table the same record must be inserted in an another table for security...
By the way im using sql server 2000 in this project.
Thanks
Sorry about the english, i speack portuguese ....
Just learning
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
