|
What exaclty you want to achieve ? What shud the @query expects to hold?
try and explain your problem rather then telling the moto
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
Mubashir,
I have to execute a query and the query would get a value from the from end i.e. a string of ids, using this ids i would form a query and execute it, the outcome would be one row with 2 columns.
Now the values which resulted on the execution of the query should be assigned to two seperate variables
Hope you got my point?
Gautham
|
|
|
|
|
Got it,
use the following as a sample
<br />
declare @val1 varchar(10)<br />
declare @val2 varchar(10)<br />
<br />
select @val1 = YourCOL1, @val2 = YOURCOL2 from YourTable<br />
WHERE ....<br />
YourCOL1 and YOURCol2 are the columns from YourTable. This query will be executed and the reselt from the YourCOL1 will be assigned to @val1 and so on.
Hope it helps
Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.
|
|
|
|
|
I know that but the problem rises when iam trying to form a dynamic query for the same!
i.e. i have a condition to check and that value to be checked is a dynamic value!
Gautham
|
|
|
|
|
as per the code written, should display the select query as it is.
for getting the result by fetching data from table.
set @query = (select convert(nvarchar(10),@mainofficeid) from tblorders where orderid in (109, 110, 111) group by lccofficeid, ordersource)
Regards
KP
|
|
|
|
|
while i am trying to connect a database table in SQL server 2005. i get this Exception.
Under defaul settings SQL server 2005 doesnot allow remote connections.
|
|
|
|
|
Go to the "SQL Server Configuration Manager" and ensure that TCP/IP is turned on for your SQL Server in "SQL Server 2005 Network Configuration"
|
|
|
|
|
do it require administrator previlege to enable TCP/IP
|
|
|
|
|
Hello ALL!
i should write some little app for connection mssql+mysql. i should take data from mysql and put it into mssql. how can i do it? i guess i should use some additional components or dll but i'm not sure.
help me plz and explain how can i decide this task?
thax a lot!
--
"Success is simple. Do what's right, the right way, at the right time."
best regards,
tradakad
|
|
|
|
|
If you need to copy data from MySQL into SQL Server, then I suggest you write this as a SSIS (DTS in SQL Server 2000) job in SQL Server and run it from there.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
can you explain more details? and how can I just connect to mysql server?
thanx!
--
"Success is simple. Do what's right, the right way, at the right time."
best regards,
tradakad
|
|
|
|
|
|
may be it is a stupid question - but where can I download SSIS? can i use it if i have MS SQL EXpress edititon?
thanx
--
"Success is simple. Do what's right, the right way, at the right time."
best regards,
tradakad
|
|
|
|
|
Hi all,
i have one table, it does n't have identity column,primary key,foriegn key,unique key and no constraints.
Now i want to delete duplicate records.
ex: table : sample (before deletion)
cno cname salry
10 xxx 1000
10 xxx 1000
10 xxx 1000
20 yyy 2000
20 yyy 2000
i want the result like this after deletion:
cno cname salary
10 xxx 1000
20 yyy 2000
Please help me.
|
|
|
|
|
Take a look at this:
http://www.databasejournal.com/features/mssql/article.php/1438651
Gautham
|
|
|
|
|
Hi gautham,
Thanx for your response.
|
|
|
|
|
No probs! You are welcome.
Gautham
|
|
|
|
|
|
Hi!
I wrote before but i want to refrase my quastion, i created a function that returns a CLOB object that contains a where clause.
I am doing a select command and in the where i put the function, i get an error, but if i print the content of the object(hard coded) to the where i get the answer, can you please tell me why?
Thanks
|
|
|
|
|
i have a gridview and bind it to datasource. gridview has a bounded boolean column. i want if grid to be not editable expect those cells in the boolean column where value is false.
in other words:
all columns are readonly expect the boolean column not readonly.
if the value of the cell in boolean column
1- true: the cell is readonly
2- false: the cell is not readonly
i tried this code but i do not know why it does not work.
For Each x As DataGridViewRow In DataGridView1.Rows
If x.Cells("DeductionAdded").Value.ToString.ToLower = "true" Then
x.Cells("DeductionAdded").ReadOnly = True
End If
Next
|
|
|
|
|
Dear Team,
While Running the Sync PAckage through SQL 2005, i am getting this error message , please help if any one has faced this issue before :
- Copying to [DWH].[dbo].[DW_IP_ACTIVITY] (Error)
Messages
Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.
(SQL Server Import and Export Wizard)
Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid column value from bcp client for colid 19.".
(SQL Server Import and Export Wizard)
Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.
(SQL Server Import and Export Wizard)
Error 0xc0047022: Data Flow Task: The ProcessInput method on component "Destination - DW_IP_ACTIVITY" (73) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0202009.
(SQL Server Import and Export Wizard)
Jayaraman B
|
|
|
|
|
how we can change db from sql server 2000 to sqlserver 2005.
Jes M George.
|
|
|
|
|
1. take backup from SQL Server 2000
2. create new database in SQL Server 2005
3. restore the backup on to the new database.
OR
Detach the data base from SQL Server 2000 and Attach to SQL Server 2005 (this option i've not tried)
Regards
KP
|
|
|
|
|
U Can use DTS in SQL 2000.
Regards,
Arun Kumar.A
|
|
|
|
|
Hi all,
I want to get all the sundays between 2 dates in sql.
Please help..
Thanks and regards,
CST
|
|
|
|