Topics
Started by
Posts
Last post
I have a table of values by date. I have a requirement to group and sum them by month (to use to pl…
12 replies
Hello All, I have a question behind the logic of Try and Catch. I'm using Try Catch in a complex st…
7 replies
All I have a column that stores data in a varchar column. The data is easily converted to xml but …
5 replies
I have a dataset similar to the following: AccountDate Amt 111120090228200.00 …
6 replies
Hi, Source: multiple text file Requirement: 1. Define age columns as small integer. 2. Convert gros…
3 replies
Hai friends , i ve the table like travel_request create table travel_request ( request_id int ide…
4 replies
Hi, I have a scenario in which I have to find a column with varchar or nvarchar datatype in all tab…
7 replies
I am trying to create a date, that I can put in a where statement to filter for the last 3 months o…
6 replies
DECLARE @t Table ( AreaID int, AreaName nvarchar(100), Responsible nvarchar(100) ) Insert Into @…
5 replies
Hi, I have table structure as shown in the below image. I have attached script for the table with s…
8 replies
I want to split the Comma Separated Values into rows DECLARE @t Table ( AreaID int, AreaName nvar…
2 replies
CREATE TABLE [dbo].[dp]( [nr] [char](12) NOT NULL, [type] [char](12) NOT NULL, [DT] [int] NOT NU…
7 replies
Hi, Please see the below sample data: create table TargetTable (Uarn INT, BACode INT, VO_Ref INT, F…
11 replies
I am creating a table by using the SELECT column1, column2 INTO NewTable FROM OldTable method. Is t…
5 replies
I have a table representing parent-child relationship and NoOfBooks for that relationship. Each chi…
3 replies
Viewing 15 topics - 3,241 through 3,255 (of 10,647 total)
You must be logged in to create new topics.