Viewing 15 posts - 1,201 through 1,215 (of 3,489 total)
Nobody's going to download files that can damage his computer. Can you just post the contents of the spreadsheet here?
October 30, 2018 at 9:48 am
ROFL. SEND MONEY.
Seriously though - that's not how this place works. It's not a "please do my work for me" site. If you're looking for that, then you're going...
October 23, 2018 at 11:24 pm
In a nutshell, you're trying to do a fuzzy match between two columns of data? What version of SQL 2008 are you using? (I think fuzzy lookups in SSIS are...
October 23, 2018 at 8:52 pm
Do you get error messages? Can you post some code or something? There's just about zero to go on to help you figure this out. Did you change something in...
October 23, 2018 at 5:53 pm
October 23, 2018 at 5:52 pm
October 23, 2018 at 2:35 pm
Thanks for the sample data. The only thing missing now is an explanation of what you really want - like a sample result that you're trying to return..??
October 19, 2018 at 11:48 am
October 18, 2018 at 8:43 pm
Please please please don't post pictures of your database. Those are worthless. I can't copy & paste into SSMS and run it. So since I don't have real tables, I'll...
October 18, 2018 at 7:45 pm
Oh fun!
This sounds like it's the end part of some dynamic SQL statement, so you need to track down exactly what query is being built, so you know the...
October 15, 2018 at 2:41 pm
the other option is to OUTER join to your Calendar table.
...
FROM Calendar c LEFT JOIN Sales s
ON c.CalendarDate = s.SaleDate
because that forces a value...
October 12, 2018 at 1:42 pm
September 26, 2018 at 9:07 am
Take this with a grain of salt, because I'm a SQL Server dummy, but I'd probably create a cursor to loop over the tables in your database that you want...
September 25, 2018 at 11:56 pm
SELECT TOP 2 PERCENT :<column list>
FROM ...
September 25, 2018 at 8:18 am
Viewing 15 posts - 1,201 through 1,215 (of 3,489 total)