Topics
Started by
Posts
Last post
(SQL Server 2008 R2 SP1) Hi all, I have an SSIS package that dynamically builds a set of SQL statem…
14 replies
I have a script that I use after some amount of data massaging (not shown). I would like to be abl…
6 replies
Hi all, I'm going around in circles trying to visualise what's happening in this code, declare @Re…
1 replies
Hi, I have two columns which needs to repeat based on ID and number of distinct rows in that ID. I…
3 replies
How can I make the following a little more error proof where I check the Table and Schema Name? IF …
19 replies
How can I calculate and return the previous Date at 18:00 Hours? Here is a miserable attempt: DECL…
9 replies
Sample Data MemberID Codes 00000123 012|222|123|333 00000233 012|222|332 00000244 012|211 00000332 …
6 replies
I am struggling trying to clean some data and identify duplicate records. I used fuzzy grouping in…
2 replies
I've put together a trace script and I'm getting a confusing error. After the sp_trace_setevent's,…
4 replies
Hello, I'm trying to write a query and I'm receiving an error and I'm not sure how to get around it…
23 replies
Hello all, I am trying to find out a way to pass an array of pbaseid's to a function. I have a func…
1 replies
I am trying to construct a query to parse out the Date in a string, then convert that result to a D…
3 replies
I have a script that retrieves Job Scheduling information. I want to order by Date and Time. Here i…
3 replies
I have 2 CTE . I want to use value from 1st and 2nd CTE in my 3rd CTE . Is it possible ? With CTE1 …
5 replies
In a sql server 2008 r2 database, I am trying to take the results of the cte called sProgram and jo…
5 replies
Viewing 15 topics - 2,356 through 2,370 (of 10,635 total)
You must be logged in to create new topics.