Search results

This is an academic question at this point, but I was just wondering.... (I had dozens of these tables to deal with... I was just wondering if there was a less painful way of creating the unpivoted view of the table) I have a table with an absurd number of repeating groups USE [Itchy] GO...

I know there are add-ins that do it (Redgate makes one), but is there an easy way to create semi-random data in SQL Server (or Access?) In my case it's bakery stuff (ingredient costs). I have a sort of "index" for wheat, so I can use that for flours (just set the value for the date I have as...

In theory, it's possible to use the PowerQuery source in SSIS to import PowerQuery results into SQL Server, but so far I haven't gotten it to work. (I wanted to import a single file at a time, because I wanted to be able to handle the failures by moving the file to a "failed" or "imported"...