Topics
Started by
Posts
Last post
Hi, I have read Jeff Moden's series on converting rows to columns but can't see how to do what I ne…
7 replies
Hi I am newbie in the T-SQL Programming. Please anyone can explain to me when and where i should us…
5 replies
For example I create some fake data about database files and retrieve only the databases with more …
7 replies
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
Viewing 15 topics - 5,356 through 5,370 (of 10,647 total)
You must be logged in to create new topics.