Topics
Started by
Posts
Last post
NOTE: Due to vendor requirements and not my own preferences I am using SSRS (rdlc type) via VS 2015…
2 replies
DATEDIFF(minute, CONVERT(varchar,[begin_time],8) , CONVERT(varchar,[end_time],8)) as [durati…
25 replies
Dear Group: I need to check if a file exists on our server, and if it does, then execute code. I kn…
4 replies
Hi How do I find a count of a specific value in XML? data.value('count(/SampleXML/Colors/*)', 'int'…
7 replies
This may be a question specifically for Jeff Moden, but does anyone know what license governs the D…
5 replies
Hello DBAs, I am facing some deadlock issue and after investigation from trace flag capture, found …
9 replies
Hi all, Our application has some parameterised dynamic SQL that looks like this; SET NOCOUNT ON; DE…
6 replies
Hi I'm tasked with importing data into SQL thats pretty much JSON but not quite . I've used OPENROW…
8 replies
This feels like an easy problem to solve, but I have not yet been able to find a solution. I have a…
19 replies
Hello, We have implemented a data import system based on an webservice which receives from an exter…
6 replies
I want to update the contents of a variable using a CASE Statement; for example: I declare the vari…
6 replies
Hello Fellow DBA friends, Currently I am working on a project where a system has to be migrated to …
12 replies
Hey guys, I'm trying to capture a JSON output of xp_cmdshell command, and the parse is using OPENJS…
1 replies
I've been tasked with improving the performance of a colleagues stored procedure, and could really …
6 replies
I am wanting to return only one row for continuous employment, what is the indcator is there WORKTY…
1 replies
Viewing 15 topics - 706 through 720 (of 3,091 total)
You must be logged in to create new topics.