Viewing 15 posts - 1,981 through 1,995 (of 5,111 total)
"Non-desktop version of Windows"? Do you mean Windows Server? Generally, in a business environment, that's the version of Windows that's going to be installed of; you don't install Windows Professional...
May 31, 2018 at 11:20 am
How wide is this data as well? If it's 187,326 rows, but only 3 columns wide, that's not a lot to do. If, on the other hand, it's 187,326 rows...
May 31, 2018 at 11:15 am
I'm not entirely sure what you mean here. If you're moving server, you'll need to reinstall all the services yes. If it's the same version, however, you can restore the...
May 31, 2018 at 8:44 am
So, where is the data coming from if not SQL Server?
May 31, 2018 at 6:38 am
This is quite a vague question. Have you already done any research on the subject? I'm sure a quick Google, Bing, Ask, etc, would yield some good results.Could you try...
May 31, 2018 at 5:51 am
OK, the image works now. it seems that this would be able to be achieved in the SQL, which would be easier, using COUNT and an May 31, 2018 at 5:29 am
Welcome to SSC
The image in your post is a deadlink, so I literally have no idea what you're asking here. Don't post code as an image; post it as...
May 31, 2018 at 5:21 am
They're back!
AT least reporting 3 got rid of it again, but I hope none of you are still subscribed to the forum they filled...
May 31, 2018 at 2:46 am
Although the service is set to automatic, I have to manually start the service...
May 31, 2018 at 2:43 am
May 30, 2018 at 9:32 am
Ok, firstly, an explanation of what i've done below.
Firstly, I've added the PRINT statement that Steve mentioned; aka your best friend. Printing the value of your dynamic SQL...
May 30, 2018 at 3:12 am
I suggest against string concatenation like that as well, for your dynamic SQL.Personally, i suggest using QUOTENAME and checking for the existence of the column(s) in May 30, 2018 at 2:28 am
May 30, 2018 at 1:51 am
Viewing 15 posts - 1,981 through 1,995 (of 5,111 total)