October 2007 Entries
Need to dump a large amount of data into sql server? Have I got some tools for you! Recently I needed to, from a stored procedure, copy a large amount of data from a text file on the disk into my sql server. This is nice an easy with SQL Server 2005. You can write a simple INSERT INTO statement that will copy the data out of the flat file into your table. Instead of providing a table name in the from part of your insert just use the OPENROWSET option with the BULK keyword and poof your data is...
Whenever I boot up my Windows XP SP 2 machine it hangs on the “Applying Computer Settings” screen for about 5 minutes. I found out that this might be due to the “Network Location Awareness (NLA)” service. After disabling this service in the Computer Management console everything went back to normal. Instructions: Right click on “My Computer” and select “Manage”. Open up the “Services and Applications” node then the “Services” node. Find “Network Location Awareness (NLA)” in the list and right click and select properties. Change the startup type to “Disabled” and then press ok. Reboot your computer and see...
Question: How do you create a green-bar (zebra stripe) report using groups in reporting services?
Answer: I have seen many examples of creating green-bar reports where each record alternated colors. All one has to do is add a row_number field to their query and use the following expression in the Background color property of the Table Row.
=iif(Fields!row.Value Mod 2 = 0,"Green","White")
But when doing groups and you want each group to alternate colors it is a little more complex, but the trick is still the same. Following the same principal I needed a way to get row numbers for each Group...
A great article by Don XML on the differences between .NET 1.1, 2.0, 3.0, and 3.5
Great to explain to your boss what each version of the .NET framework can do!
Here you can download my presentations from the CFL Tech Fair.