Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| Cross Joining Queries, Left Joining Queries - I’m trying to add the elapsed time column to a query, but I’m getting several errors regardless if it’s a cte with the declare before the with statement or a subquery join. How should the @Time variable be included? DECLARE @Time1 DATETIME DECLARE @Time2 DATETIME SET @Time1 = GETDATE() SET @Time2 = GETDATE() select […] |
| Status Update 10 Apr 2019 - I wanted to make a status update, and I’ll try to do more of these, as much for my own mental health as to disclose where we are. As of today, there are 104 issues open in Github. A slice of these (6-10) are infrastructure items related to hardware and tuning settings. Most are minor, […] |
| Intra-site links (at least to other forum posts)render incorrectly in the forums - When posting a URL to a forum post from this site, the site reformats the link to be the name of the topic. Great. BUT, the reformatted URL has two problems: the anchor to the specific post is stripped off (i.e. the pound sign and the post_id) any BBCode is processed as if it were […] |
| Blog issues: not syncing changes & missing links for original post and comments - Over the past two days I have updated 2 of my 3 most recent posts (“SSMS Tip #3” and “Differences Between Various Binary Collations”), but the changes aren’t coming though. For the old site I was told that it could take up to 48 hours to sync, but prior to the sync breaking it never […] |
| Using PIVOT - I need to know how can I use PIVOT , my query SELECT A.HIS_STD_OID, B.HIM_SERIES_ID FROM il_cps_conversion.dbo.HEALTH_IMMUNIZATION_SERIES A INNER JOIN il_cps_conversion.dbo.HEALTH_IMMUNIZATION_DEFINITION B ON A.HIS_HIM_OID = B.HIM_OID WHERE 1=1 --AND STDNT.STD_OID = A.HIS_STD_OID AND A.HIS_FIELDB_001 = '0' AND A.HIS_STD_OID = 'std01000001256' AND B.HIM_SERIES_ID <> 'TD' returns following data set with six rows and I need one […] |
| Small Rant MSDB.DBO.Sysschedules - WHY IN THE WORLD IS THE ACTIVE START AND END TIME STORED AS AN INT?! I wanted to create some tlog backups using a script to say make the tlog schedule 15 minutes earlier than the diffs If it was stored as a Time(0) I could simply do a dateadd(minutes,@difftime,-15) but NOOOOOOOOOO I had […] |
| No markdown? - Pity the new forum uses BCC code instead of Markdown formatting. the latter is so pervasive these days. |
| Weird issue with 2012 package and Visual Studio 2017 - In one of the projects I work on, we have several packages that pull from Oracle and write to a SQL Server 2012 database. They’ve been working for years. Recently we got new laptops and we’re running VS 2017 with all the usual plugins and extensions for SSDT-BI projects. While working on one package, we […] |
| A single query to display the result of multiple date selection in month columns - Hi, If I run the following query it gives me a column with the customer prefix and a column with the sum of all the widgets sold for a particular month (in this case January 2019). SELECT customer.prefix, Count(z.id) as ‘Jan19’ FROM (SELECT ID, customer FROM dbo.widgets WHERE timestamp> ‘2019-01-01 00:00:01’ AND timestamp< ‘2019-01-31 23:59:59’ […] |
| Replace a NIC on secondary replica in AlwaysOn - Hi all Hoping I can get some assistance from the AlwaysOn/clustering gurus out there! We have a SQL 2016 availability group (asynchronous) which consists of a primary and secondary replica. The secondary replica has some hardware problems which we are trying to resolve. The hardware support people have recommended replacing one of the NICs. First […] |
| Date to record zero balance for an account version - Hi All, I’m trying to create the last column on the table below which tracks the latest date for a version of an account where the amount is zero, so the date should remain the same as the first time it went to zero until a new version is greater than zero. It the amount […] |
| SSIS Error: "Please Specify Server Password" - ProtectLevel = EncryptSensitiveWithPassword And I entered the password in the properties box, but get the error when running the scheduled job. In the scheduled job, the @COMMAND value is: @command=N'/FILE "\"C:\SSIS_Packages\MyPackageName.dtsx\"" /DECRYPT "\"MyPassword\"" /CHECKPOINTING OFF /REPORTING E', I would really prefer to not have passwords at all, but can’t seem to get around […] |
| How can I null out all but the most recent records in this table? - I have an old table that contains a sort of history tracking of clients & their info that we’ve imported. I now need to null out a field named “RecordType” of all prior records for each client EXCEPT the most recent record for that client, but I’m not sure how to do this. In the […] |
| Trying to avoid granting Sysadmin to SSIS Proxy account - We have an ETL process involves a couple of packages – one that receives a Database backup from and external organisation and restores it to a staging server (this database obviously doesn’t contain any users mapped to logins or accounts in our organisation) – and a second package that queries that tables on that restored […] |
| Software dev best practices test? - Years ago I remember reading this manifesto almost about how a company should approach software dev and it was originally on this guy’s blog then it became well known and people referred to it as his first name. It was a list of things that healthy dev shops did and you could count up how […] |
