Topics
Started by
Posts
Last post
Hey all, I have a stored proc. It does what i want it to - but it seems over complex and a little …
5 replies
hi All, I am learning sql server optimization, declare @p1 int set @p1 = 1 SELECT ProductID, SalesO…
4 replies
Hi, I have stored procedure having one input parameter . ALTER PROCEDURE [dbo].[CMT_RoomDelete] @…
1 replies
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
Viewing 15 topics - 5,386 through 5,400 (of 10,647 total)
You must be logged in to create new topics.