Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~386 People Reached
Favorite Forums
Favorite Tags
Member Avatar for fcaserio

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 + …

Member Avatar for hollystyles
0
62
Member Avatar for fcaserio

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

Member Avatar for hollystyles
0
118
Member Avatar for fcaserio

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 …

Member Avatar for pty
0
53
Member Avatar for fcaserio

[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 …

0
54
Member Avatar for fcaserio

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

Member Avatar for fcaserio
0
99