Topics
Started by
Posts
Last post
I've created a date range within the WHERE clause: WHERE Date Between CONVERT(DateTime, '01-JAN-200…
10 replies
Hi Folks, I am new to SQL Server particularly STored procedures, functions, SSIS + reporting servic…
2 replies
check if any records match if match ---rec match/not match when used full outer join both tables no…
1 replies
Hi, Need advise on what the best solution would be for the following :- I would like to create a st…
8 replies
Hi, I have 2 tables: a) EntryTable - EntryDateTime - EmpName sample records: 1) Ent…
12 replies
I would like to create a View or Stored Procedure that can include the login id of the user selecti…
2 replies
I am running scripts in Mgmt Studio. I know that you can right click in the query window and select…
16 replies
I have the following Stored Procedure. When I run it, it executes without errors, but it does not …
4 replies
I want to create trigger which fires only when not null value is inserted into perticular column...…
6 replies
I have a TEXT column in a table and it has leading spaces..How do I get rid of it? What sql server …
3 replies
Hello there, I wonder why Stored Procedures in SQL Server always have SET ANSI_NULLS ON. I assume t…
1 replies
i have the following code that should return 1 record per different ConsultantID and the latest eff…
3 replies
Hi I have a table in my database, which contains ID's these are numerical and represent a shop. I …
6 replies
Hello everyone, I was just curious, what is the best practice for passing multiple values into a st…
3 replies
Hi, In the article at the below link, I need to know what is the purpose of SortKey in CTE. In the …
1 replies
Viewing 15 topics - 5,491 through 5,505 (of 12,234 total)
You must be logged in to create new topics.