Topics
Started by
Posts
Last post
I am trying to write a SQL statement to pad numbers with 0's. The number string has a . delimiter …
5 replies
Hi, I have a little problem where my Database stores Dates in 'yy/mm/dd' format. I want to retrieve…
13 replies
Hi Guys, Hope you're all doing well! I have a problem and will provide an abstraction (extremely si…
6 replies
A column that accepts null values but has a unique constraint can only have a single row with a nul…
29 replies
I am trying to write a stored procedure that cursors through all databases and cursors through each…
3 replies
Hi All, I've a question regarding a problem that I’m facing. I need to get the orders that were pla…
13 replies
Hi All, I've a question regarding a problem that I’m facing. I need to get the orders that were pla…
1 replies
Hi, Please find the below query INSERT INTO tbl_employee (EmpNo,CompanyID,MngrID,DateOfFiled,DateO…
4 replies
Hi, I am a newbie in sql server.I have came across various article on internet which shows how to i…
11 replies
DISCLAIMER I did not write this code Assume that #InstitutionChild is just a temp lookup table file…
12 replies
select run_date, server_name, database_name, table_name, rows from table_rows as a where run_date &…
2 replies
I have a simple SPoc: ALTER PROCEDURE [dbo].[TestSPR] @P1 int AS BEGIN SET NOCOUNT ON; DECLAR…
11 replies
Hey, Can you please provide some on idea on group the common word? Example: Code Desc A1 …
13 replies
I've been having a look at a project that is underperforming when selecting from a view, and notice…
4 replies
Hi All, I'd like to perform a rolling monthly analysis. Let's say I have a sales table and if a cli…
10 replies
Viewing 15 topics - 5,386 through 5,400 (of 10,644 total)
You must be logged in to create new topics.