Viewing 15 posts - 1 through 15 (of 13,399 total)
In what form are the 99 serial numbers? Are they in a table?
April 24, 2024 at 8:19 am
Can you craft a SELECT statement which produces the rows you wish to insert? If yes, the rest is easy:
INSERT table (column list)
SELECT column list FROM ...
April 24, 2024 at 8:17 am
Here's an example. Get cutting and pasting and the rest of the columns are done.
DROP TABLE IF EXISTS #UnitProdFinal;
CREATE TABLE #UnitProdFinal
(
YearMonth INT NULL
...
April 23, 2024 at 12:59 pm
i would like to insert transactions at different timestamps of the day randomly , something like
transaction1 - 04/22/2024 9.55am
transaction2 - 04/22/2024 9.59am
transaction3 - 04/22/2024 10.11am
Perhaps 'randomly' is not wholly...
April 23, 2024 at 9:10 am
This should do it:
string fileDate = "2024-03-31";
DateTime someDate = DateTime.ParseExact(fileDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
April 23, 2024 at 9:02 am
Obviously a hierarchy of some sort. What sort of data do the rows in the table represent?
April 23, 2024 at 8:21 am
Did you refresh the Intellisense local cache? CTRL-SHIFT R
Never heard it called Abscess before!
April 23, 2024 at 8:17 am
Please clarify what you mean by this:
incremental time of the transaction day.
What is that, and how does it differ from 'time'?
April 22, 2024 at 8:00 pm
Including the database should ONLY be done IF you are running a cross-database query.
Otherwise it runs the risk of you running the query against the wrong database.
… Or of...
April 22, 2024 at 2:29 pm
I would use the following code to get 'last' Sunday. Seems a bit simpler than the current version.
SELECT DATEADD (wk, DATEDIFF (wk, 0, GETDATE ()), 0) -...
April 15, 2024 at 9:56 am
Duplicated reply!
April 15, 2024 at 9:54 am
Don't know anything about Netsuite, but if there's a REST API, then you can definitely do this in SSIS.
The trickiest part of setting that up will probably configuring the OATH...
April 12, 2024 at 1:22 pm
thx, just the type of feedback i was looking for. i've never seen an ssrs report ingest excel. But i am very familiar with pbi ingesting excel. do you...
April 12, 2024 at 1:03 pm
No doubt you've considered this, but wouldn't a more-streamlined process be to ingest the spreadsheet data in SSRS (or in Power BI) and build the dashboard there?
April 12, 2024 at 11:30 am
I've just tried this, as I have a package structured like that.
They've certainly made it difficult! I can get to the point in debug mode where I can see a...
April 11, 2024 at 4:53 pm
Viewing 15 posts - 1 through 15 (of 13,399 total)