Topics
Started by
Posts
Last post
I was wondering if there is a better, faster way to script the following..... declare @begin_dt dat…
6 replies
I have some tables that are FKed and I turned on Delete cascade. I have two questions. 1) How come…
1 replies
hi, can someone please explain to me what is happening here... CREATE FUNCTION [dbo].[f_ConvertXML]…
5 replies
I have a query that returns 1 to N rows with the following data: BeginDate, EndDate, NumberOfUnits …
3 replies
Hello, I'm trying to build a logic around the following sample records in order to get the deptid b…
5 replies
I am trying to import an XML document into SQL. All the examples I have seen have shown actually ty…
12 replies
There is a table that contains a row for each time a user is allowed to renew an order for another …
2 replies
Have two tables, ptPayments and ptPaymentBatches. Both have column PaymentBatchID and all values in…
2 replies
Hi people Just a question regarding views.. Can i use/reference a view in a stored procedure that u…
3 replies
I built a custom auditing construct where I store the text of the stored procedure I am currently e…
2 replies
Dear all, The following is the procedure that i have created for insert and update .The problem n…
7 replies
Hi, Just trying to better unstand the index usage. Scenario, I have a table; CREATE TABLE dbo.Sampl…
3 replies
Hi Every body How can i delete having reference constraints in a table
3 replies
I am working with SQL Server 2005 and I have a simple table that I create using a simple case state…
2 replies
A simpliefied sample below indicates table CoreItem and table SubItem. I need to return the CoreIte…
6 replies
Viewing 15 topics - 9,301 through 9,315 (of 12,234 total)
You must be logged in to create new topics.