Viewing 15 posts - 1,021 through 1,035 (of 5,111 total)
On a different note, I'm really happy that they fixed the "code wrapping" and indentation issues on this forum but, unless they limit the vertical height of the code...
May 7, 2019 at 2:45 pm
In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/
I admit I haven't read too far into it, but I...
May 7, 2019 at 1:05 pm
Are you familiar with the book mentioned? I need to import data from MySQL db. Database n table is created as you can view in ssis screenshot. I cant...
May 7, 2019 at 10:28 am
What you're after here is SQL Server Agent. The documentation will likely tell you everything you need to know. I suggest having a read and a go yourself first,...
May 7, 2019 at 10:21 am
Testing some other words, in case it's the fact that it's the word user
Table:
My Column: [My Column]
[My Column]
Values: [values]
[values]
Edit: Looks...
May 7, 2019 at 10:09 am
I'm surprised that select * from user is even working. USER is a Reserved Keyword in SQL Server, and (Ideally) shouldn't be used for object names. If you have...
May 7, 2019 at 9:30 am
I didn't see the need to add a comment. The other answer is shown as accepted with multiple positive votes. The bad answer has now 2 negative votes (one...
May 7, 2019 at 8:04 am
Like the article. I'd like to point to the fact that "PRINT @sql;" is limited to 4000 characters, therefore I use "SELECT CAST('<root><![CDATA[' + @sql + ']]></root>' AS XML)".
I...
May 7, 2019 at 7:55 am
Ahh, if that's the format and requirement, then this is a more "complete" solution (assumes that the ID column will always be called Id) that inserts the data into the...
May 3, 2019 at 8:42 am
So, assuming I understand correctly, your data looks like this:
CREATE TABLE dbo.ETLData (ROW_NUM int,
...
May 3, 2019 at 8:16 am
Hello, Data are in a sql Server table. I used excel just for illustrate my issue.
So the data is stored in a delimited format in your Table? This sounds...
May 2, 2019 at 9:15 pm
They must also be pre-Windows 7. I believe that's when the snipping tool was first included in the OS.
I hope not, anyone me older than Windows 7 is...
May 2, 2019 at 8:43 pm
Your data looks like a odd mix of an excel file and a CSV. If you were sticking to one technology this would actually be easier. Phil raises some good...
May 2, 2019 at 6:45 pm
Coalesce() with two arguments is equivalent to IsNull() ... might as well save yourself some typing
Actually, Phil, I feel I need to correct you on that one. ISNULL and...
May 2, 2019 at 4:15 pm
Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me? I'm working on a...
May 2, 2019 at 2:32 pm
Viewing 15 posts - 1,021 through 1,035 (of 5,111 total)