Topics
Started by
Posts
Last post
Hopefully someone can provide some assistance: What I need to know is when each driver had their fi…
5 replies
Hello: Below is code for a CTE "table" that I have for displaying for one account and one year the …
4 replies
I have a query that I am forced to improve. I can't add indexes or fix the tables in any way. This …
6 replies
Hello All, I just started using SSIS in Visual Studio 2015. http://prntscr.com/b8du7x Overview: a. …
1 replies
Hi Can anyone tell me how to prevent arithmetic overflow on a percentage calc? I know this is prob…
5 replies
I am trying to import xml file to sql table. Any help please! m new with XML, obviously! Sample XML…
5 replies
I'd like to get a count of visits per patient before a specific patient visit date, particularly th…
7 replies
Hello and thanks to all who take the time to read this and help out! I have an issue I'm trying to …
2 replies
Hello, I am wondering some can help me with the solution below. 1. I need to aggregate a report by …
3 replies
I have a table Activity which has a column 'ActivityCode' which is having data type NVARCHAR(100). …
3 replies
I need to find all table names in all databases with data types text, ntext and image. I came up wi…
2 replies
I've one table with one specific integer column containing date as YYYYMMDD format and apart from d…
17 replies
Hi All, I used this query. DELETE OPENQUERY(DB2400_WRITEPROD, 'Select * from PALTEMP.CNTUPDR') then…
11 replies
I’ll try to be as clear as possible with the initial details: 1. I have a view (V_DATA) that is ret…
11 replies
We have an OLAP system where we are assigning 0 value to any uniqueid column if the data is not fo…
1 replies
Viewing 15 topics - 676 through 690 (of 10,647 total)
You must be logged in to create new topics.