Topics
Started by
Posts
Last post
i need the output to be sort by serial how can i sort this so after 1.3 , 1.5 shall come and then 1…
16 replies
Hello, I am trying to document the environment I am working at. I want to document our clustered se…
3 replies
Hi all, I have a table like this: CREATE TABLE [dbo].[Task]( [UnitHistoryTaskId] [int] IDENTITY(1…
10 replies
I'm unable to convert a character field to datetime in TSQL. Column: CounterDateTime (char24), not …
22 replies
I have string which sores dates and related text. for example: 2013/12/12: User1: Comment1. 2013/…
3 replies
Hi, I am having a table with SchoolDate column. In this column I need to enters all the dates in th…
7 replies
Hi All, I am having a column StartTime in my table which data looks like below. StartTime 7:00 AM &…
16 replies
I've got a DB that has one table that is currently using about 52GB and I need to free up some spac…
7 replies
Hi all I have been tasked with a requirement to drop around 500,000 tables from a data warehouse. T…
5 replies
Hi Friends, My Table strct: =========== create table show_bus ( id int identity, from_p varchar(100…
5 replies
I am working on triggers for insert,update and delete output of the trigger shows tablename,user an…
7 replies
Hi, Declare @i float = 1223.8899 I want this to be 1,224 Declare @i float = 1234.22 I want this t…
5 replies
Why do we used aggregate function in pivot operator and cross tab queries . Any link to blog or vid…
3 replies
Hi All, I have a simple task to perform: to return all the records, where myColumn field has 'value…
6 replies
I have an table which contains lots of transaction with a column called Validity which is a boolean…
3 replies
Viewing 15 topics - 2,626 through 2,640 (of 10,647 total)
You must be logged in to create new topics.