Viewing 15 posts - 181 through 195 (of 670 total)
It was just an example. I used this to get the groupings.
RowNum % 3
You can modify to this: RowNum % 500, I just wasn't going...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 26, 2018 at 7:22 am
Not sure why you would need this, but here is an example of how to put 3 records into comma separated values.
drop table if exists...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 26, 2018 at 6:44 am
That's what I get for guessing 😉 You see the DDL and sample data that I provided. That is what we need along with what you are expecting as a...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 21, 2018 at 7:23 am
https://forums.sqlteam.com/t/sql-query-to-merge-extract-data/14668
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 20, 2018 at 4:48 pm
I'm pretty sure I already responded to this in another forum, but here's what I guessed at based on what you've provided (no DDL, data, etc...)
[code...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 20, 2018 at 3:37 pm
how about posting ddl, data and expected result
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 20, 2018 at 1:51 pm
as long as the data in the AuditDate column is xml, you can try this to see if it works.
drop table if exists #Audit
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 20, 2018 at 1:17 pm
there's alot of things wrong with this. First and foremost is what happens if it fails? You will have records skipped. Second, why? This would probably be better as an...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 20, 2018 at 10:41 am
I'm not sure how you would ever get inner and your data is really bad. here's an example of what I think you want, but again only guessing here For better, quicker answers, click on the following... For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 5, 2018 at 3:10 pm
HappyGeek - Wednesday, December 5, 2018 9:39 AMHomework!!
Slow day 😉
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 5, 2018 at 10:38 am
You can execute the proc into a temp table, then use that to parse the string.
Drop procedure if exists sp_test
go
create proc sp_test...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 5, 2018 at 9:26 am
This looks like it works, although GW's dod is incorrect in sample data
select ( SELECT count(1) N
FROM #President p
WHERE IsNull(p1.DiedDate,'1/1/2020')...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 5, 2018 at 7:15 am
not sure what the issue is. The rowcount variables should be populated once the data flow task runs
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 27, 2018 at 7:08 am
Did you look in Integration Services Catalog?
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 21, 2018 at 10:16 am
declare @t table (TRAID int, POT int, ATTID char(4), WC date, LH_MON int, LH_TUE int, LH_WED int, LH_THU int, LH_FRI int, TOTAL int...
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 17, 2018 at 1:05 pm
Viewing 15 posts - 181 through 195 (of 670 total)