Topics
Started by
Posts
Last post
In a table, I have a field (text format) which contains sometimes 2 or 3 consecutive empty lines of…
2 replies
Create TABLE #TableA ( TaskNameA nvarchar(100), GovernA bit, ToolTypeA nvarchar(10), ResourceNa…
5 replies
Hi all, 99% sure the answer to this question is "it is not possible", but figured I'd check anyway.…
4 replies
DECLARE @JsonData NVARCHAR(MAX) =N'[{"preview":true,"offset":0,"result":{"pkid":"3e1900e5-e997-4ae2…
1 replies
Dear Group: I am not sure if this is a T-SQL / SSMS issue, or Excel, so if this is off-topic please…
11 replies
Hi, I have a table of sites where the there are multiple site names with different site managers. S…
4 replies
-- EXEC SP_DROP ##XXX -- For older versions of SQLserver DROP TABLE IF EXISTS ##XXX select t…
8 replies
I have fine tune the query to great extent but these nested loops are something that eat up most in…
3 replies
Dear Group: This is my first attempt at using the xp_cmdshell command, but right now, I am trying t…
5 replies
I have a set of reports - with user defined criteria. And an optional set of statistics which are…
3 replies
Any ideas to fix this proc. I have optimised it much but CPU is still high CREATE PROCEDURE […
9 replies
I hope you are well. I need your help and advice on a repetitive task that I would like to automate…
10 replies
Hi guys, I have a column StartDate in datetime format and another one called SessionDate in the for…
10 replies
First off, I didn't write this query. It's created dynamically in code I inherited. It works 99.999…
14 replies
Dear Group: I have a requirement to create a SQL Job that exports a query to a Pipe / Vertical bar …
5 replies
By: ZZartin
Viewing 15 topics - 1 through 15 (of 1,208 total)
You must be logged in to create new topics.