August 4, 2018 at 12:57 pm
Jeff Moden - Saturday, August 4, 2018 11:38 AMHeh.... Except for T-SQL (which has a dash in it), I try to avoid all the 4 letter words in SQL Server, especially SSIS and SSRS.
Well, I think we agree on SSRS, But surely "SSIS" should never be mentioned in polite company in modern times although whatever MS had that (whether called that or instead of that) was quite workable back in 2000 compared to what a mess it has become.
Tom
August 4, 2018 at 1:35 pm
Luis Cazares - Tuesday, July 31, 2018 9:34 AMWhy bother on even looking at the email application?
Just listen for the howling and crying down the hall?
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
August 5, 2018 at 4:19 am
Does this qualify as the longest question https://www.sqlservercentral.com/Forums/1982386/Cursor-object-running-when-FETCHSTATUS-0?
August 5, 2018 at 4:37 am
Jonathan AC Roberts - Sunday, August 5, 2018 4:19 AMDoes this qualify as the longest question https://www.sqlservercentral.com/Forums/1982386/Cursor-object-running-when-FETCHSTATUS-0?
Nah, the initial question is only 1479 lines 😀
😎
August 5, 2018 at 7:13 am
Eirikur Eiriksson - Sunday, August 5, 2018 4:37 AMNah, the initial question is only 1479 lines 😀
😎
a SP with only 1479 lines? that's not big.
August 5, 2018 at 7:39 am
frederico_fonseca - Sunday, August 5, 2018 7:13 AMa SP with only 1479 lines? that's not big.
SQL Crocodile Dundee 😀
😎
August 5, 2018 at 8:50 am
I was more impressed that the forum software managed to format all the lines, when almost every time I past some SQL in I have to trick it into formatting it all...
August 5, 2018 at 9:08 am
andycadley - Sunday, August 5, 2018 8:50 AMI was more impressed that the forum software managed to format all the lines, when almost every time I past some SQL in I have to trick it into formatting it all...
That is derived formatting, nothing to do with the forum software, which messes up any kind of formatting.
😎
SOS and Code are much better than SSMS as the format will be recognized from the former two when pasting it to the forum. That format is inline rather than within the code tags, which makes it render much much faster.😉
August 6, 2018 at 2:29 am
Jeff Moden - Saturday, August 4, 2018 11:38 AMHeh.... Except for T-SQL (which has a dash in it), I try to avoid all the 4 letter words in SQL Server, especially SSIS and SSRS.
Are you saying you don't use SSMS and stick to SOS or SQLCMD then Jeff? 😀 Or maybe you're a fan of mssql-cli? (I actually quite like that tool, apart from it uses double quotes(") instead of brackets ([]) for quoting in the intellisense).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 6, 2018 at 2:32 am
Eirikur Eiriksson - Sunday, August 5, 2018 9:08 AM
SOS and Code are much better than SSMS as the format will be recognized from the former two when pasting it to the forum. That format is inline rather than within the code tags, which makes it render much much faster.😉
I tend to copy from SOS/Code on SSC, because the of the pasting peculiars. Putting the whitespace back in, after the software has removed at least 1 in every 2, is infinitely easier when using a fixed-width font. I can tell where I made them post from depending on what theme I was using in the post then too. :hehe:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 6, 2018 at 5:48 am
Thom A - Monday, August 6, 2018 2:29 AMAre you saying you don't use SSMS and stick to SOS or SQLCMD then Jeff? 😀 Or maybe you're a fan of mssql-cli? (I actually quite like that tool, apart from it uses double quotes(") instead of brackets ([]) for quoting in the intellisense).
SSMS is an unfortunate but necessary evil. I'd love to have a good replacement for SSMS. It's one of the few 4 letter words I use in SQL Server. I wonder what idiot decided on the Icon changes both on the main screen and in the execution plans. The old ones looked a lot better and where a whole lot easier to discern. I wanted to kill when they removed things like the {f4} key functionality back in the 2005 RTM.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2018 at 1:05 pm
TomThomson - Saturday, August 4, 2018 11:12 AMOld joke?
I didn't think it was a joke, just a (sadly rare) instance of a medic who knew what sheer hell SSRS was.I first was bitten by SSRS (SS2000RS to be specific) when a couple of developers, both with PhDs in computer science, both very experienced with RDBMS, who had put in a very long time getting exactly nowhere in generating some reports. I (having joined the company as [the only] systems analyst and become head of research and responsible for licensing and system security almost immediately) had no control over development (and anywhay this pair were working outside of the development group, both being considered senior to the then head of development), but I got involved because they said they needed a license for a certain bunch of report presentation software; I was able to negotiate a free licence for commercial use with certain agreed limits. That didn't get them anywhere, because SSRS was too much of a mess. The CEO decided to get rid of that pair, and asked me to generate some reports for internal use (giving up on reports for sustomer). I had a look at doing it with SSRS. Then I wrote the report genration a mixture of T-SQL, JScript, and HTML, which took me less than a week where I had estimated 6 months to do those limited internal reports using SSRS.
I've looked at SSRS since then, not in SS2005 or in SS2008, but in 2008 R2 and each subsequent version. None of them appears to me to any less painful to understand, to use, or to build reports with than than I found with SS2000. Maybe if I had put some real effort into looking at those later versions the results would be different. Or maybe not. I love MS SQL Server, I think that it's the most developer-friendly and DBA-friendly RDBMS server in existence, and that it has maintained that record at least since the release of SS2000 (Before then it was probably 3rd with both Postgres and Ingres ahead of it) - but SSRS detracts from SQLServer's appearance of friendliness.
I ended up writing a SQL script to generate the appropriate XML for a tablix when given a dataset name and a list of fields and positions. It probably took me about the same amount of time as going through the GUI, but the next report will only take about 30 minutes instead of a day.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
August 7, 2018 at 11:06 am
drew.allen - Monday, August 6, 2018 1:05 PMI ended up writing a SQL script to generate the appropriate XML for a tablix when given a dataset name and a list of fields and positions. It probably took me about the same amount of time as going through the GUI, but the next report will only take about 30 minutes instead of a day.Drew
ooh, we need an article on that
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 7, 2018 at 11:35 am
jonathan.crawford - Tuesday, August 7, 2018 11:06 AMdrew.allen - Monday, August 6, 2018 1:05 PMI ended up writing a SQL script to generate the appropriate XML for a tablix when given a dataset name and a list of fields and positions. It probably took me about the same amount of time as going through the GUI, but the next report will only take about 30 minutes instead of a day.Drew
ooh, we need an article on that
I was having trouble with the XML name spaces appearing in places that I didn't want them, so I used a hack. The solution is not publishable with the hack and rewriting it to use FOR XML EXPLICIT to remove the hack is on my list, but it's rather low on my list.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
August 8, 2018 at 2:30 am
jonathan.crawford - Tuesday, August 7, 2018 11:06 AMooh, we need an article on that
+1
I used to do similar things in the past create code to generate code, saves a huge amount of time.
Recently I had to rewrite 150+ SSIS packages for SQL 2016 and the only difference was the table names (transfer from 3rd party system)
Creating each package one at a time would have been tedious at best :doze:
So I created one, then using text editor removed all column references and changed the table names to @ (purely for future text replace) and then used it as a template.
All I had to do was copy the template to the actual filename required, replace @ with the table name, load the file in SSIS, fix the errors (mappings) and voila a working package in less than a minute 😀
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 61,921 through 61,935 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply