Viewing 15 posts - 16 through 30 (of 451 total)
June 13, 2017 at 5:58 am
June 7, 2017 at 5:44 am
Hello,
I passed my exam 70-467 and I had this question, please do you...
June 6, 2017 at 9:56 am
1. Users drops in a CSV file to a...
June 5, 2017 at 9:22 am
June 5, 2017 at 9:05 am
No, from your error ( "Can't convert Unicode to Non-unicode data type".) your data is not varchar/non-Unicode, but it is the double wide nvarchar/Unicode. Which is why I recommended...
June 5, 2017 at 7:57 am
June 1, 2017 at 10:12 am
Didn't know that off the top of my head, but
https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server
explains it quite clearly.
Good question,
Rob
June 1, 2017 at 9:35 am
June 1, 2017 at 9:29 am
Not exactly sure what your (homework?) question is? Show records that have NULL or 'Periodic' in the type field?
What have you tried?
Take a look at ISNULL()...
June 1, 2017 at 6:38 am
Glad you figured it out. As you noticed, you need a tablix or a list to show multiple records. If you just put a textbox, it'll only show the value...
June 1, 2017 at 6:32 am
Kind of a klugey idea, but what if you wrote to a table that uses nvarchar() (or Unicode aware) fields. Then SELECT from the table, and write to your Excel...
June 1, 2017 at 6:29 am
What happens when you take the TOP 10000000 query from your OLE_DB source and just run it in SSMS? Is tempdb fine in that scenario? What if you insert same...
May 31, 2017 at 6:35 am
May 31, 2017 at 6:30 am
May 31, 2017 at 6:27 am
Viewing 15 posts - 16 through 30 (of 451 total)