Topics
Started by
Posts
Last post
I have a view, which shows Invoice Details table. This view is used to print invoices to the custom…
4 replies
Hi,There's this table with 300000000 rows and about 40 columns the pk consists of three fields…
4 replies
Hi all, Trying to delete some white spacebar as follows... /****** Objec…
5 replies
I'm working with one of the developers, he has an application which logs the "path" taken by a proc…
16 replies
What's the correct syntax?CREATE TABLE Title2 AS SELECT * FROM TitleMsg 156, Level 15, State 1, Li…
7 replies
Hi Everyone, Does anyone know or suggest a way to extract column information from the Json array. W…
9 replies
Is there any kind of general rule or guidance on which kind of update is faster? I'm tr…
1 replies
Occasionally, I see a query submitted from Entity Framework with 'Dummy_VAL' in the where clause, l…
4 replies
Hi Have an app that saves its internal reports (the SQL) in a table tblReports.I would like t…
5 replies
Hi all, SELECT DATENAME (MONTH, [Date]) AS 'MONTH'-- , Replace([notes], 'Attended - ','…
12 replies
We have orders with at least one code assigned to them. I need to find out all possible variations …
3 replies
Hi, I need to write a query (or a series of queries) that will allow me to find when two clien…
2 replies
Which approach should I generally take? In this example, I'm keeping it simple, but imagine 20…
3 replies
I have a table defined as follows: CREATE TABLE [TestTable]( Col1 INT IDENTITY PRIMARY KEY,&…
4 replies
Hello there, I've attempted to find some information on the XML path and after a few modifica…
4 replies
Viewing 15 topics - 886 through 900 (of 3,067 total)
You must be logged in to create new topics.