Topics
Started by
Posts
Last post
I'm looking for suggestions on how to troubleshoot a slow stored procedure call (e.g. exec usp_sp1)…
4 replies
I have a data column called fullname I need to separate the first and last name. FULLNAMe Astohn, T…
2 replies
Hello, I am looking for SQL logic to pick up rows which have 2 columns with different values while …
2 replies
We have a few views that will be changing in a couple of weeks (column names). Is there a way to g…
2 replies
Table : Company Id Name 1 ABC 2 XYZ Table : Details Id Desc CompanyId 1 p1 …
1 replies
Hi Guys, I got a situation where I need to create a sproc to seed this table whenever we got change…
1 replies
I cannot get this proc to handle dupes. For instance if a user submits two files with the same seq#…
3 replies
Hi I thought this would be really easy but it's much harder than I expected ! I have a table of int…
1 replies
Hey all. I have the following scenario. An Interal Account Transfer stored procedure will recieve f…
2 replies
Hi all, Got an interesting problem here. I have the following data as a basic example: if exists (…
4 replies
Hello All, To give a brief description of the problem. I had configured a "Job" on SQL Serv…
2 replies
I have a question with the columns of a table transpose to rows Customer AM/PM ShopA Shop…
4 replies
I have to pad a field that falls short of 20 bytes. I will need to select all the records that meet…
13 replies
Hello, Can somebody help me with this scenario: I have 2 tables: First one (Lets say TableA) has on…
3 replies
Hello, How can I sum columns from 3 other transactional tables? Example pseudocode For every item i…
3 replies
Viewing 15 topics - 5,251 through 5,265 (of 12,234 total)
You must be logged in to create new topics.