Topics
Started by
Posts
Last post
I have read the post regarding identifying gaps in dates but it hasn't helped me come up with a sol…
16 replies
I have a query that looks like this (this is a simplified version of the query): select id, …
4 replies
My question is --- is there a limit on number of savepoints that can be created in a single transac…
1 replies
SELECT * FROM ABCD where ColA like '%AB CD EF GH%' or ColA like DE FD FG GH%' and Writt…
5 replies
I need to execute the following script againts each database on a server to capture all the sql use…
6 replies
I've attached two text files. One containing XML that resides in a field in a SQL table, the other…
5 replies
I have a queue set up as follows: CREATE QUEUE [dbo].[SBWorkQueue] WITH STATUS = ON , RETENTIO…
4 replies
I need to run a sql statement to produce NAMEVALUE addr120 Morris Ave addr2NULL or ‘’ addr3…
4 replies
We have a stored procedure that runs when an address is updated. The SP has 4 output variables - ar…
4 replies
How do i calculate the time difference in minutes between these two columns? Is it as....? SELECT D…
2 replies
sql_latin1_general_cp1_ci_as
1 replies
I have billing customers which has multiple shipping addresses. Unfortunately, we did a poor job of…
3 replies
I have this code that calculates a percentage: SELECT (100 / CAST(a.MonthPop AS decimal(10, 2))…
4 replies
I'm building a procedure which will create records of inventory items to be counted over a 2 year p…
9 replies
I was tweaking some queries, and noticed a high cpu usage on some of those. It then occured to me, …
6 replies
Viewing 15 topics - 2,746 through 2,760 (of 12,230 total)
You must be logged in to create new topics.