Topics
Started by
Posts
Last post
Hi, With some googling, I learnt that SQL Server doesn't have persisted column names (like Netezza …
5 replies
Hi My tables are partitioned on business date. My requirement is to add 365 partitions for next yea…
3 replies
I am trying to create columns by a time frame where column a would be from 8am to 10am, column b wo…
2 replies
Hi Every one, I have a issue that I couldn't create SSISDB catalog under the Integration Servi…
2 replies
Hi guys, I have loads of stored procs that gather data but need an option to be inserted into diffe…
8 replies
My work machine died last week, so I got issued with a replacement. It's still Win 7 image, so I ca…
2 replies
Hello, I’m new to SQL and need some help please. This is such a mind bender for me. I am looki…
6 replies
I create a SSIS web service to retrieve data from remote server, Server connection is good, but get…
2 replies
I have simple query:SELECT (select ISNULL(SUM(TOTAL_PAYMENTS),0) from Orders where ST_ID IN(SELECT …
5 replies
tl;dr1) Should I use MERGE, or not??? https://www.mssqltips.com/sqlservertip/3074/use-ca…
1 replies
USE [iMIS_Prod]GO /****** Object: Table [dbo].[BM_OnlinePass_Subscription_Archive] Script Da…
10 replies
Hi All, So I'm faced with the need to optimize a pretty hefty query, as it's beentaking extremely l…
25 replies
I'm having an issue in SSMS 2014 where I'm trying to debug a sql script and everytime I try to add …
7 replies
Can anyone give an example of TSQL to redirect error rows similar to the functionality in an SSIS d…
1 replies
CREATE TABLE birthdays( cust_id INTEGER NOT NULL PRIMARY KEY ,cust_fname NVARCHAR(50)…
37 replies
Viewing 15 topics - 1,141 through 1,155 (of 3,067 total)
You must be logged in to create new topics.