Topics
Started by
Posts
Last post
Hi guys, If i am putting count(any integer) like count (5) . It will count all the rows of table an…
6 replies
I have to run this query for each @partId. It gives me a list of testers who didn't test a certain …
8 replies
I have a table of tests where I have data in the tabular format: English 8:30 9:00 9:30…
3 replies
The objective is to determine, for each customer, the latest contract for each customer. I am a bit…
8 replies
I have this complex delete statement. I was wondering if there's a way to simply it? I tried forma…
4 replies
I have a table that contains rowdata column. I need to get row_number result set based on when valu…
9 replies
Hi Guys, I have a table that records a certain event happening several times a day for most days ov…
9 replies
Hi there, I have to generate a database as an "almost" copy of another one. So for most objects, I…
5 replies
SELECT @@version Microsoft SQL Server 2012 - 11.0.5058.0 (X64) Developer Edition (64-bit) on Wind…
5 replies
Hi all, I have a requirement to calculate an average attendance figure based on 28 day periods inst…
15 replies
why does DECLARE @phi DECIMAL = (SQRT(5)+1)/2 SELECT @phi; return 2 and not 1.618 You're all fa…
11 replies
hi - is there way to create an user login that has access (read/write) to all databases except one …
8 replies
I have this table type CREATE TYPE [dbo].[ty_custom] AS TABLE ( cl_buffer INT NOT NULL, cl_serie…
10 replies
I have a table showing assets. A payment file is produced every month showing all assets, regardles…
10 replies
Hello, Ok so I have this project that exploded more into what it was, but I may be over thinking it…
5 replies
Viewing 15 topics - 2,446 through 2,460 (of 4,984 total)
You must be logged in to create new topics.