Topics
Started by
Posts
Last post
Hello, I am trying to see all records, even those which do not have a match on table b. I tried ful…
6 replies
If yes, any links to instructions would be great. I am often times asked to search for parts, and t…
2 replies
I would like to update the EmailAddress column of a database table with emails from a list . So bas…
3 replies
I have legacy databases that stores all data in U.S. Central Standard Time. Some servers are on…
3 replies
Hi there, I have around 12 views and that works perfect if I execute them individually but when I c…
20 replies
Hi, I am experimenting with triggers on SQL 2014. When the column Processed is updated I want to up…
2 replies
Everything worked great until i added this snippet. I want a column that tells me what "ID" matched…
2 replies
My parameter can be a combination of formats and it can be in two different columns . . dashed/no d…
3 replies
i am using the below code: I tried using PD_ID IN (@Part) but SSRS still bombs. @Part can be mult…
1 replies
Hi, I'm using SSIS ScriptTask for file transferring purposes and inside of the code I have a little…
1 replies
We have a scalar-valued function that returns a product based on a series of criteria passed to it …
1 replies
I have a need to use a SQL Cursor in order to delete data from a table, one row at a time (to preve…
11 replies
Hi all I have the following SQL SELECT Account, LogDateTime, RowId, Cell, lag(LogDateTim…
2 replies
By: Thom A
I have table workingDates that has 3 columns wd:(type int ) This column has all working dates in in…
1 replies
Hi everyone I'm using the code below to take someone's title, the first letter of their firstname, …
7 replies
Viewing 15 topics - 16 through 30 (of 2,529 total)
You must be logged in to create new topics.