Topics
Started by
Posts
Last post
I have a table with items that are versioned. The version numbers are stored as varchar with three …
2 replies
table1 Id Name mobileno 1 abc 9123456789 2 xyz 9876543210 3 qwe 54321…
5 replies
Hi , In my production server i created sql server user for limited permission.Now i want de…
1 replies
Hello comunity On a new project i need to create possible ranges between a specific interval, let m…
7 replies
I would like to know if it is possible to build one SP to perform all the functions (Add, Update, d…
8 replies
I have two tables - one with sales and another with payments against those. The payment may not ma…
5 replies
Hello, the subject pretty much says it all. I have the following result set but I want to stack or …
3 replies
I'm trying to figure out how to include row values as columns in my select query. I have a table t…
2 replies
Hi, I have a table with a datetime field (named "lnDateDone") and an integer field (named "PlannedH…
4 replies
Over the past year I have heard some folks around here talk about a "set based loop". What's that a…
11 replies
Is there a Microsoft published document for SQL database coding standards and guidelines/T-SQL codi…
7 replies
Hello, on my development server I have a table that has over 200 million records. CREATE TABLE [dbo…
6 replies
Hi Suppose a table being Create table myTable (ID int, col1 int, col2 int) I know how to make a com…
22 replies
Hi, We are getting data feed from Oracle database in our project. Everyday we will need to track if…
1 replies
Hi, I am trying to calculate percentile in SQL server exactly similar to MS-excel Percentile functi…
8 replies
Viewing 15 topics - 1,246 through 1,260 (of 10,647 total)
You must be logged in to create new topics.