Topics
Started by
Posts
Last post
Hi, I have been reading links relating to the fact that instead of using table variables, then I s…
14 replies
I am doing a left join and I'd like to update a Boolean column in the left table based on whether a…
8 replies
Hello, I'm not sure how to implement this, I have a Sybase DB 15.4 but I guess if I found the logic…
4 replies
I have a list of items in different locations. They may have different suppliers but only one suppl…
5 replies
I have nvarchar data that looks like XXXXXX-XX-XX where X can be a character or a number. The prob…
7 replies
I want to create a Comprehensive Data Dictionary. Is Erwin the preferred method for generating exte…
3 replies
Please help me in adding dynamic pivot dates based on @fromdate and @enddate Declare @temp TABLE(s…
10 replies
Hi All, I am having a hard time importing a text file that was given to me that is delimited by 3 p…
5 replies
Create Stored procedure with input year and month which should calculate working days of dayshift,N…
31 replies
Hi, I am thinking about using memory optimization, but my biggest worry is the system running out o…
1 replies
Run the following sql: DECLARE @results TABLE(r INT, d DECIMAL(38,37)) DECLARE @X DECIMAL(3,2) = 1.…
7 replies
Hi I have a structure below: /****** Object: Table [dbo].[OrderDetails] Script Date: 20/06/20…
5 replies
When importing a flat file I receive the following error - [Flat File Source [2]] Error: The column…
2 replies
Hi, I have a pretty simple update statement: UPDATE eligibility SET primary_plan = 0 FROM temp_…
26 replies
we have started new team of datawarehouse in our company. Team started working on SQL Server 2014 …
4 replies
Viewing 15 topics - 2,011 through 2,025 (of 3,067 total)
You must be logged in to create new topics.