Viewing 15 topics - 21,121 through 21,135 (of 283,992 total)
Topics
Started by
Posts
Last post
I have this code:insert into OPENROWSET('Microsoft.Ace.OLEDB.12.0', 'Excel 12.0;Database=D:\Data\te…
4 replies
Hi,Pasted at the very bottom of this post is the T-SQL I wrote to unpivot, and format, some da…
2 replies
i have table as below:country codeaustralia 55555australia 55555australia checklaterukraine&nb…
6 replies
I am trying to use the SQL below UPDATE WMWHSE1.LOTATTRIBUTE SET LOTTABLE05 = ( SELECT…
5 replies
Dear All, I have a requirement where i need to encrypt all my stored procedures in a existing datab…
7 replies
Hi, I have a variable that shows the date as month and year only. It has data format like 2018-11. …
9 replies
Hi,My report has a drop down selection parameter with the following datasetSELECT [SS-zzRepor…
3 replies
I cant seem to work out a query that returns fully encapsulated shredded xml. This will get me very…
3 replies
When I make changes to the READ_ONLY_ROUTING_URL or READ_ONLY_ROUTING_LIST settings on th…
1 replies
Hello Does any body know if TLS 1.0 is still support on SQL 2016 SP2 CU5?
1 replies
ALTER PROCEDURE [dbo].[GetMachineAttendanceFinal5] AS BEGIN SET NOCOUNT ON; ;WI…
5 replies
I have a SP as follows:CREATE PROCEDURE dbo.MyProcedure @StartDate Datetime, @EndDate Datetime, @Re…
8 replies
I have a table that contains multiple fields:Diagnosis1Diagnosis2Diagnosis3Diagnosis4Diagnosis5Diag…
13 replies
Hello,it would be great if someone could help me with the following problem.I need to write a query…
15 replies
I have DB mirroring configured to DR location from Server A --> B. Also replication configured f…
3 replies
Viewing 15 topics - 21,121 through 21,135 (of 283,992 total)