Topics
Started by
Posts
Last post
I need some help with pivot. For the following data set: and produce an output like this:
6 replies
hi everyone I am planning on adding a composite key for my tables. I have SPs that are writing to …
4 replies
I have some IT peeps that will run an SSIS package manually from a location on the file system by r…
10 replies
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple tab…
5 replies
hi, we just decided to change over to a tab delimited format in a handful of dw files coming our wa…
5 replies
We have a Production/Live version with up-to-date data and a Test version with older data where we …
2 replies
Hi everyone. I am re-writing a portion of my SSIS logic. My SSIS package downloads daily stock ma…
12 replies
hi i seem to be running in a circle trying to find a db2 connector for windows where my dw sql serv…
20 replies
By: EdVassie
I have data that contains poll results, with the poll_id consistuting a single row of data for each…
9 replies
I'm trying to capture some screen shots of query results for documentation. I'd like to remove the …
9 replies
By: Jahanif
Hi this post is mostly about cross server concepts vs a query being sent to and run on the target s…
8 replies
Hi I have a little big problem. I have a job that uses the Weekday for calculate the two year chang…
6 replies
By: Jeff Moden
Hi all, I have this query where I make a pivot to extract the data segmented by Hours: select ‘Amou…
3 replies
By: Jeff Moden
Hi I am trying to get the first and last days for the following where date_next_compare is less tha…
4 replies
By: drew.allen
We have a third part software and looking at some of their SQL we found this INSERT INTO tblSoftwar…
6 replies
Viewing 15 topics - 151 through 165 (of 1,790 total)
You must be logged in to create new topics.