No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I'm dealing with queries that manages a lot of data consolidation and I'm having to repeat large blocks of code to get the desired result. I'm wondering if that is any way to make it simple. My queries looks like this: [CODE] SELECT (A + B) AS C, (D + … |
|
I can't find any DTS tool on MSSQL 2005 Express Edition Is there any tool that execute DTS tasks? I need to perform 2 tasks: - import a large Access file into MSSQL - deploy database to production environment Any help is welcome. []s |
|
I hava a table that stores payment information, with invoicenumber int and part varchar, where part can be (1/1, 1/2, 2/2, 1/3, 2/3, 3/3, etc) The thing is not all payments are related to invoices, so I have many null value for invoicenumber. Is it posible to create a UNIQUE … |
|
[COLOR=#008000]I have a table with a primarykey ID and a unique key for ID_EMP and OSID When I insert I want to populate the OSID column whth the next int value related to id_emp My trigger works but is returning the error message: Warning: Null value is eliminated by an … |
|
Can a query running a selected database access a table on other database? How do I grant this kind of access? Going further, can a Foreign key be created among diferent databases? I'm running around this doubts for a while. Any help is welcome. []s |