Here's a post from Erland Sommarskog...

passing parameter to stored procedure in bcp command

then all you'd have to do is loop over the list of values to pass into the stored...

use BCP OUT with a parameterized stored procedure to get the data you want?

See Example G on this page: bcp Utility - SQL Server | Microsoft Docs

You could filter on TaqIndex... something like

WHERE TaqIndex % 30 = 0, and then you'd only pull a small fraction of the records. Instead of 30, try a larger number......

• This reply was modified 3 years, 8 months ago by pietlinden.

Why are you even setting the IDENTITY property on a temporary table that you're inserting data into that already has a PK? Are you going to insert data from another...

Are you basically trying to find the largest islands you can (contiguous sets of dates)? (Basically where you find the start date and end date for each "island".)

that's a Gaps...

Oh, you've GOT to be kidding. I'm not downloading that. Post your CREATE TABLE statements, and maybe a handful of INSERTs for each table to show the relationship. Foreign keys...

What I want to do is to exit the while loop after it finds the top record for each tank.

How would one determine that programmatically? TOP doesn't mean anything without...

Different how? Different filters? different columns?

IF @Selection = 1

BEGIN

SELECT...

END

IF @Selection = 2

BEGIN

<other> SELECT...

END

Different filters would be a whole lot easier. Maybe use COALESCE() to ignore some empty parameter values and...

Why not put all the views you want to expose in a single schema, and then just grant rights to the schema?

Sorry for the roundabout answer, but I'd check with Chrissy LeMaire and Rob Sewell, because they literally wrote a book about manipulating SQL Server objects with PowerShell.

Learn DBATools in...

I don't think you can use the * wildcard with UNION or UNION ALL. You need to explicitly list the columns.

You don't really need to store the duration at all. Well, unless you really want to for some reason. (I guess it's okay, because once a duration is calculated, it's...

Ouch! Not exactly a rookie question! Since you're brand new, I created a simple table...

use tempdb;
go

CREATE TABLE deviceActivity (
deviceID int not null,
EventName CHAR(3) not null,
EventTime datetime not...

Some consumable data (CREATE TABLE and INSERT scripts) would be really nice.

If the On/Off events are in pairs (so you can't two "On" events in a row for the same...

How are you using your data warehouse data? If you're using PowerBI or Excel, there's a USERELATIONSHIP() function, where you can have multiple relationships between two tables (like Sales fact...