Topics
Started by
Posts
Last post
I am having a problem where an Access application executes an adhoc SQL string which generates an e…
7 replies
Hello: I have a table with a FirstName and LastName field, about 85% of which were entered into the…
2 replies
How can I create xml schema definitions for the current database table I have in my database? Thank…
6 replies
Hi, I need to update a table based around the following T-SQL query: UPDATE dbo.LSR_Prepare SET Sam…
1 replies
I came across an article on the forum written by Jeff Moden about using tally tables to split delim…
5 replies
what am i missing... update R set WorkType = case when WorkTypeID in(4,5,6) AND UPPER(OPNumber) L…
5 replies
This is scripts of three tables. USE [Test] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET…
11 replies
Greetings experts, K Cline was kind and generous, and patient enough to assist me with a problem t…
35 replies
Hi, Here a sample of data (separated by pipe |) that I’m working with (TableA and TableB). Basicall…
3 replies
Hi. I am using sp_send_dbmail to run a query and format the output as HTML. The output is fine exce…
1 replies
I have a function that is supposed to get the next maximum value (plus 1) from a table. Here is the…
4 replies
Initially I coded Restore Database in a TRY CATCH BLOCK. The ERROR_MESSAGE() is collecting/showing…
3 replies
Hi there, What I need is a solution for the following: I have a table with data for various regions…
8 replies
Hi! I'm trying to create a query which returns a self referencing table as a product of a join from…
4 replies
Hi, I need to extract the Data pipeline as Column Terminator and : colon as Row terminator... M…
1 replies
Viewing 15 topics - 3,706 through 3,720 (of 12,230 total)
You must be logged in to create new topics.