Topics
Started by
Posts
Last post
I want to number weeks from April to September for every year, such that week 1 starts 1st of April…
1 replies
Hello Evening please see below code for sample data CREATE TABLE PHONENOS (CustID Varchar(10), Mobi…
3 replies
Hi I have a requirement to calculate the start and end of the working Month, The criteria is that i…
59 replies
Hi All, I want to compare data of current period with previous period. sample table n data is below…
3 replies
Is there a way to populate the email addresses for a sql agent job or do i have to hard code them?
1 replies
Hi, I'm building nonclustered indexes on a table, and the execution plan is showing the sort spilli…
1 replies
Is it good idea to add hint NOLOCK in Sales.SalesPerson for second example. Any references that tel…
29 replies
I need a sort of odd combination of grouping and max. I have a query that works, but it's ugly and …
30 replies
I have a table A with InDate, OuTDate and weight column. I have another table B column which has Ch…
1 replies
Hi: I have semi-colon separated data in one column and I would like to split that in separate colum…
8 replies
I have a select-query using the WITH(NOLOCK) hint to ignore locks. The problem is that when the que…
12 replies
By: averylane
My project contains below TABLES and sample data for it :: CREATE TABLE [DBO].[TBL_Budget] ( Budge…
1 replies
We keep running into issues where life comes to a grinding halt due to tables with INT IDENITY colu…
7 replies
Hi Forumers, I have some data (many tables) that will be mapped to a new SQL Server Database. I nee…
6 replies
Hello, I have a table of data in which I've identified some duplicate records. I need to pull all…
27 replies
Viewing 15 topics - 1 through 15 (of 2,765 total)
You must be logged in to create new topics.