Topics
Started by
Posts
Last post
Hi I would like to populate a bill of materials (#bom) type table from another table (#tree) that h…
14 replies
Hello, I have a column of julian dates YYYYJJJ that I need to compare to a column of YYYYMMDD to fi…
7 replies
I am attempting to create a view using the select statement below. As I piece it together, all wor…
8 replies
Hi, I’ve got this query: SELECT * FROM [MyDB].[MySchema].[GetHashTable] ( 'SomeValue' ,1) ru…
13 replies
Hi All - I am trying to understand a perhaps basic issue. I have a requirement to run a stored proc…
3 replies
When an email failure notification is sent (Outlook) is it stored somewhere on sql server? Thanks
7 replies
I have a store procedure that contains a subquery in the WHERE clause, and returns the results that…
8 replies
Hello, I'm trying to create a trigger on a table that is truncated then we insert all the records f…
7 replies
When I use sp_send_dbmail like this: EXEC msdb.dbo.sp_send_dbmail @profile_name='DBS03',@recipient…
4 replies
I have proc which picks date from a table where it has fixed date as 1st day of the month say ' 03/…
2 replies
I've got to be missing something pretty basic here because it doesn't seem this complicated. :w00…
5 replies
Hi. I have 2 tables I wish to compare. Products ProductHistory The current record in Products is wr…
18 replies
Hi All, Racking my brain trying to find a way to return the earliest date from 3 different date fie…
15 replies
Trying to update one of several fields by examining each in order and updating the first that meets…
8 replies
Hi all I am having a hard time figuring out how to write query: Data is like this: 1stname2ndName …
7 replies
Viewing 15 topics - 4,051 through 4,065 (of 12,230 total)
You must be logged in to create new topics.