Topics
Started by
Posts
Last post
Hi I have set of hundreds of business rules that I need to executed based on certain criteria. Just…
1 replies
Hi, using Merge I can sync table A with Table B at ROW level. However 'how to update only specific …
1 replies
Hi, I want a range of values between a start number and end number say 10000 to 50000 using SQL, bu…
3 replies
I tried many different ways and built a function to basically go character by character checking th…
2 replies
Hi all, I need your help. I need passing variable into xp_cmdshell. This is my code : DECLARE @cmd…
6 replies
I know that this is a long article, so, I totally understand if there are no replies. This seemed l…
3 replies
In the attached Stored Procedure, the yellow-highlighted code causes major blocking, especially whe…
21 replies
Hi, I want to add a new column to the table. Eg Table A ID 1 2 3 Desire Output …
1 replies
Hi, From the following script, I am able to choose one column rows from #TableB to columns Headers …
4 replies
Hello I've created a temporal table and can record changes. With temporal tables, it writes …
1 replies
Hi all. I've got a query that pulls data from a Progressor database. I need to get the customer and…
7 replies
Hi, declare @table varchar(500) ='person' Select 'select count(*), count(distinct('+ STRING_AGG( na…
2 replies
All, I'm trying to get the average number of relatedpostid counts per postid. The following achieve…
6 replies
Hi , I have a query that uses a where clause to return records today. however it seems at 6:00pm…
9 replies
I cannot think of an easy way Two Tables Table 1 PROJECT Project_ID , Client ID Data …
6 replies
Viewing 15 topics - 1,081 through 1,095 (of 3,091 total)
You must be logged in to create new topics.