Topics
Started by
Posts
Last post
Hey guys, I am having trouble with this OVER PARTITION BY... Here is some sample code to test on: C…
8 replies
I'm attempting to store a string of SQL in a varchar field. I want to include the '*'. The purpose …
6 replies
I just found out we have a sql script to create a table. CREATE TABLE [dbo].[DayList]( [DateID] […
21 replies
Hi, I have 2 tables as Table1( Date, Product, Qty ). The data in that table is Date Pro…
5 replies
Hey guys, I have been going nuts over this issue for some time and I am seeking help. I have SQL Se…
3 replies
I have a very challenging TSQL situation. I am dealing with a few million rows and have to modify a…
2 replies
Hey all, I have a stored proc that is supposed to either disable (for ETL) indexes on a table or re…
1 replies
I have a new table. The unique value is PersonID+lateDate, it can be used as primary key. But we wo…
32 replies
How to find the latest used stored procedure.
6 replies
Ii have an urgent problem and I am thankful for any help. I do a query based on user-selected param…
1 replies
Hi all, Suppose i want to perform operations on 2 different server. How would i do it. I am just cu…
5 replies
I need to create a SP which will filter based on none, one or more criteria user selects. I idea is…
2 replies
Hi everyone, I can post DDL and execution plans if desired, but perhaps this question can be answe…
19 replies
I have a requirement to show and count the top 5 records and then they want a count of the remaini…
10 replies
Hello, I’d like to confirm if what I am attempting is possible. I suspect it’s not, but wanted to …
1 replies
Viewing 15 topics - 5,356 through 5,370 (of 10,644 total)
You must be logged in to create new topics.