Topics
Started by
Posts
Last post
Can I get some advice on deploying SSIS/SSRS solutions (SQL Server 2014) from Visual Studio? If mem…
13 replies
What is wrong with this Statement? ALTER TABLE tblCall ADD CONSTRAINT DF_ReinspectTag DEFAULT (RAN…
9 replies
Hi There is a table which has one field with some duplicate values. we can not drop or update these…
3 replies
Hi, I use SQL Express 2014. I have a table with approx 45.000 rows. I use a Stored Procedure to sel…
7 replies
The requirement for report was to display the Policy as per below logic. PROCEDURE [dbo].[spExcept…
9 replies
I Need help in optimizing the query , Could you please throw some techniques or any valid query for…
3 replies
I have an SSIS package that appears to be stopping after a ForEach Loop container. The container p…
1 replies
I have a simple logic but i am missing something in below query. For all the records with Max(colu…
19 replies
I have TABLES products1 and products2 CREATE TABLE products1 ( product_id INT PRIMARY KEY, produ…
6 replies
hi, I have a table that contains one column that is has an xml And it has come to my attention that…
11 replies
I have a table 'Actions' like this. CREATE TABLE Actions ( Action_Id varchar(25) NOT NULL PRIMARY…
1 replies
I have a code that execute this steps in some table: 1 - Update 5000 rows with will be to extract,…
3 replies
Since windowing functions make a big deal of the OVER ... ORDER BY clause, how can that be reconcil…
3 replies
After trying it a few times in the past, again I was hoping to make SQL Server search in PDF-files …
1 replies
An annoyance for me is that a CTE doesn't seem to allow me to highlight-a-section-and-execute as I …
4 replies
Viewing 15 topics - 2,131 through 2,145 (of 3,067 total)
You must be logged in to create new topics.