Topics
Started by
Posts
Last post
how can i convert this to a sql function Function GetPrefixForCustomer(CurrentValue) Option Explic…
2 replies
Hello Peers, I need some help in framing a self join query. The requirement is such that I need to …
6 replies
Hi Guys, First time poster long time reader. I'm trying to come up with a solution on amalgamatin…
3 replies
I have a query SELECT mst.CICS_DIM.CUST_KEY FROM mst.CICS_DIM , stg.STG_CUSTOMER_INTEG , SOUR…
9 replies
I have contact and contact_log tables. They can be joined via contactid. As you can imagine it is 1…
6 replies
I am currently going through some of my predecesors code and came across something that does not ma…
3 replies
I've tried several approaches to this including an older one that cursored through the tables to di…
5 replies
can DISTINCT keyword be replaced with " IN" for better performance in some scenarios?
6 replies
I have a select query where I do 7 sums The total number of rows in the query is not more than 150 …
3 replies
hi experts, i have two databases one is live the other is test db, on the test db i've created a vi…
4 replies
Dear All, I wish to create a stored procedure whereby I will retrieve either all the lastNames if t…
5 replies
I have written a fairly complex query but I got the last part and it fails with the old "Msg 4104, …
2 replies
I have a table that stores address information. All of the columns are varchars. When I execute t…
15 replies
Simplified, but the source table is like: [inc_id] player -------------- 1 Ned 1 Bob 1 Steve…
3 replies
Hello, Was wondering - if someone has any suggestions - whereby which we can add time durations. Ex…
3 replies
Viewing 15 topics - 7,441 through 7,455 (of 12,234 total)
You must be logged in to create new topics.