Viewing 15 posts - 166 through 180 (of 5,111 total)
Syntax like FORMAT(tab1.g, 'yyyy-MM-dd') suggests that you are "rounding" a date and time value to just the date; you would therefore be much better off just casting/converting the value to...
June 22, 2022 at 8:22 am
Presumably this is within a ForEach loop container, so seems that setting the Propagate property to False of said Container is what you need; then when the data flow for...
June 20, 2022 at 4:09 pm
Do all the linked servers definitely have the table dbo.qc in the database w? Are all these objects exactly the same definition? Do you have have to use UNION (which...
June 20, 2022 at 1:25 pm
But I have many tables, many querys, this is only a short part of code, the code have more than 450 lines, I need to do a report, I...
June 15, 2022 at 2:25 pm
Why do you mean by a "txt file"? As in the file has a .txt extension? You define the name of the file with the @query_attachment_filename parameter; so you could...
June 15, 2022 at 10:13 am
any help in how I can do the date format change?
What was wrong with the wealth of replies above about using CONVERT with a style code (or combined with...
June 15, 2022 at 9:53 am
I must admit, the lack of support for table type parameters in SSRS is frustrating. Though, I also feel like the opposite syntax that SSRS allows (SomeColumn IN (@Variable) )...
June 13, 2022 at 12:46 pm
I have a (bad) habit of putting the SQL into the reports when building, but I do think that Procs are actually better; I just end up not always migrating...
June 10, 2022 at 8:29 am
Did they actually build the project in VS 2015? Could they have used a newer version? If you have a copy of their original solution file 9not one you have...
May 31, 2022 at 1:48 pm
On a side note, I am also putting forward tomorrow we actually consider delaying the migration (as we're so far behind schedule) and wait for 2022 at this point. We...
May 30, 2022 at 1:38 pm
A little bit off topic, if you good folks don't mind... I am curious about good experiences in SSIS (and, no... not being ironic there... they made the tool...
May 30, 2022 at 1:26 pm
Doesn't SSIS allow you to run a CMD Task where you could issue the following simple DIR command and capture the output to a table? It'll give you the...
May 30, 2022 at 8:35 am
Sorry, I was wrong with what my needed output should be, I needed this, in other words keeping those with just one date:
123548, '2022-02-21'
985254, '2022-03-19'
774589, '2022-01-17'
754512, '2022-04-04'
All the information...
May 27, 2022 at 8:20 am
The standard approach for this is to use a CTE and ROW_NUMBER to get the "top 1" in each group. You can also use a windowed COUNT to allow you...
May 26, 2022 at 4:09 pm
Then it seems that what you want, as I mentioned, is a Foreach Loop container; that can loop on the contents (including subfolders) of D:/Employees and you can filter to...
May 26, 2022 at 8:38 am
Viewing 15 posts - 166 through 180 (of 5,111 total)