Topics
Started by
Posts
Last post
I have searched everywhere and about every forum. I am trying to count the characters in a sting be…
71 replies
I have an XML file about 25MB. When I read it with openrowset it gives me 'System.OutOfMemoryExcep…
7 replies
This is the logic I need to incorporate in to sql if the getdate() < term start date then R if t…
5 replies
It's often said or done that when inserting or updating into a 'large' table that disabling the non…
5 replies
I need a query or procedure which will take FIRST_NAME, MIDDLE_NAME, and LAST_NAME as inputs and pr…
1 replies
I came across this structure today and haven't seen it before: SELECT blablabla FROM T1 FULL OUTER …
15 replies
hello SSC's Friends Today i was doing a query for store procedure and one of the query was this, i …
5 replies
I have two queries that give me the total sales amount for the current year, and the last year. SE…
1 replies
Hello everybody, I have to export the records of a table in a .txt file but in a strange way (in a …
13 replies
Need some help for incremntal load on below data CREATE TABLE [dbo].[Source]( [ID] [char](15) NOT …
9 replies
Hello, I have the following data I need to pivot. CREATE TABLE [dbo].[tmp]( [ID] [int] IDENTITY(1…
13 replies
I want to get data from previous day 1 AM to 1 AM DECLARE @startDate DateTime , @endDate DateTi…
6 replies
Dear All, I am unable to update the data using record by record below scenario. Required output: pa…
5 replies
Hello every Body Is below code is correct or incorrect: DECLARE @DocNo nvarchar(20) DECLARE @inMode…
5 replies
The following is sample data I am dealing with. SELECT * INTO TEMP FROM (SELECT 'AAAAA' AS CATEGORY…
3 replies
Viewing 15 topics - 4,006 through 4,020 (of 4,984 total)
You must be logged in to create new topics.