Search results for query: *

I have imported some data from excel spreadsheets where a person may pop up multiple times over the years of data I am working with. I want to assign an ID to them by using newid. How do I insert the new column and get SQL to assign the same ID to the same person even though there are different...

I'm taking data from several tables (unlinked) and using union all to combine it all into one massive table. The query runs perfectly now but I cannot save it to a new table because syntax requires into to be placed after SELECT but before FROM. Is there any way to do this using a stored...

I wrote a stored proceedure that selects the top 5 most run reports in our system. The query runs fine in SQL studio and if a co-worker logs in and puts it into a report, everything goes fine. (We are logging on to the same computer. Same version of crystal, etc.) When I try to select the stored...

Does anyone know how to insert a field to show how quickly the report is run? Kind of like what you see on google (this page generated in .003 seconds, etc.)

I'm using a stored proceedure to define a custom set of choices delivered to a dynamic parameter. Works like a charm in standard reports. The problem is when I run it against a report that uses another stored proceedure, it wants me to fill in the parameters for the other proceedure before it...