No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
4 Posted Topics
can you please post a comment maybe per line? about what each line does so that beginners, like me, could understand.. :) hehehe.. thanks.
Hi guys, I'm new here. I have a problem though. I can perform a bulk insert from .csv file to MS SQL Server 2005. My problem here is that there are foreign tables in the .csv file. What I want to happen is that these data should be replaced with …
[QUOTE=cgyrob;945028]The first question I have is why are you using a cursor just to fill a temp table when you can simply fill the temp table with your select statement. [code=sql] Select emplid, name, division, payroll_sect Into #tableMain FROM tblRecords a WHERE ((Finalized = 0) or (Finalized = 1 and …
[QUOTE=oddvalue;893380]I don't have that option in my menus. I'm using Microsoft SQL Server Management Studio Express 2005. Any other suggestions?[/QUOTE] In the object explorer click the (+) beside the "<Server name>" then the (+) beside the "Databases" then right click the "<name of your database>" select "tasks" then select "Import …
The End.