Topics
Started by
Posts
Last post
Hi All, I would like to insert the 2nd statement to a table. If I copy and paste to SSMS and run it…
3 replies
By: Ed B
Hi All, I am trying to get table row count. Looks like it not not moving to next table. Can anyone …
2 replies
By: Saran
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value …
4 replies
Below is data CREATE TABLE #Containerno(CID INT,Contno VARCHAR(50),ConWeight nvarchar(50),Entrydate…
4 replies
I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate InvDetail…
4 replies
I work on unity csharp . i try to execute multi query on sql sever database using async await threa…
4 replies
Hi all I need help to replace bad characters with space in string. select col1, patindex('%[^ !-~…
1 replies
In batches a certain action is done on each order# following specified sequence. Action is marked a…
6 replies
Hi all I have the following table DECLARE @T table (A int ) insert into @T values (1) ,(0) ,(1) ,(0…
6 replies
Hi , I need to do one of these ghastly pivots again... and looking for some help. Here is my…
8 replies
HI all, The famous SearchAllTables proc failed to find date values I know exist in my (DateTime) co…
10 replies
Hi In my code below the row data are not grouping into month by month name. I want to group row dat…
4 replies
Hey everyone! I have a SQL agent job that deletes data then inserts data into the same table hourly…
11 replies
Hello. We have inherited a system and some code and this has been flagged as a performance issue. I…
13 replies
Hi, Our DB vendor is now implementing a new FK. This new FK is not going in due to duplicates - The…
8 replies
Viewing 15 topics - 16 through 30 (of 3,062 total)
You must be logged in to create new topics.