Comments
Sort by recent activity
Ali wrote:
Hi Jim
Glad to hear you're using the export feature already. You're right, the SQL datetimes are getting exported into Excel as strings.
It is possible to format these cells in bulk without having to click inside each one:
1. In Excel, set that column's data type to "Date" (highlight, right click > Format Cells... > select Date in the Category list).
2. With these cells still highlighted, go to DATA (in the ribbon) > Text to Columns > Finish.
Configuring your preferred date time format and then exporting to Excel as that data type is a reasonably large piece of work. If you'd like to see this functionality in SQL Prompt then please submit a UserVoice request here. This will help us gauge interest and prioritise the work.
Thanks
Ali
Thanks for the reply and info on how to convert the data back to a date.
Sure, I understand that configuring a date time format to my preference will be a bit of work and I will look at posting something at UserVoice on that. But, what about at least formatting the field as "yyyy-mm-dd hh:mm:ss.000" statically (in your code) instead of as text so that it is at least a date time field in Excel and easier for users to change the formatting instead of doing a Text to Columns routine first.
Thanks,
Jim / comments
Ali wrote:
Hi Jim
Glad to hear you're using the export feature already. You're right, the SQL datetimes are getting exported into Excel as strings.
It is possible to format these cells in bulk w...
Thanks! I am installing it right now!
OK, I have a stupid question related to just your forum software, phpBB that I can't seem to figure out. Why do I see your name in Red all of the time and David's in Green all of the time? I have noticed this with others that use phpBB. / comments
Thanks! I am installing it right now!
OK, I have a stupid question related to just your forum software, phpBB that I can't seem to figure out. Why do I see your name in Red all of the time and Davi...
I would prefer the column list. While optional, I think it will be needed more than not.
Thanks,
Jim / comments
I would prefer the column list. While optional, I think it will be needed more than not.
Thanks,
Jim
Thanks Aaron,
I guess I should have phrased my OP a bit differently and just left off the part about the incorrect schema as in this case the names Inserted and Deleted need to be kept.
I hope I wasn't being too confusing there.
Jim / comments
Thanks Aaron,
I guess I should have phrased my OP a bit differently and just left off the part about the incorrect schema as in this case the names Inserted and Deleted need to be kept.
I hope I wa...
Hi Aaron,
Any chance the indent that I mentioned for Iif will be made consistent in 6.4.x though? (Not left justified)
Thanks,
Jim / comments
Hi Aaron,
Any chance the indent that I mentioned for Iif will be made consistent in 6.4.x though? (Not left justified)
Thanks,
Jim
Yup, it is unchecked.
So I poked around a bit more and noticed that it does not always repro, but I can make it do it when the correct conditions are met.
Basically, I need to have another select statement in the query window to make it happen. [image]
As you can see from the image, I have
Select *
From dbo.Committees as c
in my query window. Oh, and you have to type the first "c" to make it show up. Without the query there, it behaves as it should. Hope that helps. / comments
Yup, it is unchecked.
So I poked around a bit more and noticed that it does not always repro, but I can make it do it when the correct conditions are met.
Basically, I need to have another select s...
Aaron Law wrote:
Hi Jim,
I've just uploaded another beta (6.4.0.206) with this as an option (off by default, so you shouldn't need to do anything to keep the old behaviour). Sorry for the inconvenience!
Hey, no problem. Formatting can be such a personal thing--as it is, years ago I used some software that formatted the code differently than SQL Prompt (don't remember the name)--I just got used to the way SQL Prompt formatted after a while... / comments
Aaron Law wrote:
Hi Jim,
I've just uploaded another beta (6.4.0.206) with this as an option (off by default, so you shouldn't need to do anything to keep the old behaviour). Sorry for the inconv...
Aaron Law wrote:
Hi Jim,
This change was intentional - it was requested here. Do you prefer the previous indentation style?
Thanks,
Aaron.
Well, I could live with the change, but what I liked about it was that it made it more obvious to me that the Select was part of the Insert and not a statement on it's own. / comments
Aaron Law wrote:
Hi Jim,
This change was intentional - it was requested here. Do you prefer the previous indentation style?
Thanks,
Aaron.
Well, I could live with the change, but what I liked ...
Wow, that was quick! Yup, that fixed the casing of the "table" data type. But, I also noticed something else.
My code
Insert Into @Committees
( CommitteeId,
IsMasterAccount
)
Select cgca.CommitteeId,
cgca.IsMasterAccount
From dbo.Comm_GetCommitteeAccounts(@CommitteeId) As cgca
became
Insert Into @Committees
( CommitteeId,
IsMasterAccount
)
Select cgca.CommitteeId,
cgca.IsMasterAccount
From dbo.Comm_GetCommitteeAccounts(@CommitteeId) As cgca
The indenting of the Select under the Insert was removed. You used to indent the Select to align with the ")" of the column list. Was that change intentional? / comments
Wow, that was quick! Yup, that fixed the casing of the "table" data type. But, I also noticed something else.
My code
Insert Into @Committees
( CommitteeId,
IsMasterAccount
...
How about any special deals for those of use who have current maintenance on other RedGate products?
In the Announcement FAQ the statement is made:
... but Red Gate has a good track record of offering tools that deliver major benefits at low prices.
Your tools are excellent, but I guess "low prices" is kind of relative. The SQL Prompt bundle at $595USD is a stretch for our organization. I would love a license at home for when I am working at home, but I (nor who I work for) can afford yet another license...
Just say'n / comments
How about any special deals for those of use who have current maintenance on other RedGate products?
In the Announcement FAQ the statement is made:
... but Red Gate has a good track record of off...