Topics
Started by
Posts
Last post
I hae to update the tableA. Server names are same in both tables but in tableB we have more Appname…
3 replies
I have a table that tracks all changes to employee Roles. Here is the table with sample data CREAT…
5 replies
#1)Here is the piece of code DECLARE @P XML SET @P = '<Movie> <MovieName&g…
4 replies
Hi there people, I'm writting a T-SQL procedure to get a running total over a certain period, the d…
7 replies
I search for Date functions for finding the max of the 2 dates. But such function does not exits. I…
20 replies
Hi people, I am creating a function to be used in a specific application that a user can insert any…
9 replies
I have a need to update numeric values in a table column so that they are unique and sequencial, th…
4 replies
hi i want to add column with no check constraint like alter table emp with nocheck add column1 not…
4 replies
Hi Dear, What is different between two query? query 1: SELECT dbo.Person.Code FROM …
6 replies
Hi all, I was trying to split the values using DENSE RANK but I faced some issues... here is the pr…
2 replies
You are only given the transaction date in your transactions table and your client requires you to …
4 replies
Hi friends, I have sql server 2008 R2 enterprise database. I have compressed tables and then create…
4 replies
Hi All, In a table (sale.person) I have more than 9 lacs row. I have only three columns. I need to …
8 replies
Hi All, I have two tables as described below: CREATE TABLE [dbo].[Batch]( [BatchID] [int] IDENTITY…
3 replies
Hi, I am trying to create a table with a grouping based on a merged column. Best to explain with SQ…
2 replies
Viewing 15 topics - 3,406 through 3,420 (of 10,647 total)
You must be logged in to create new topics.