Topics
Started by
Posts
Last post
I am attempting to group a column which represents dates as YYYYMMDDHH as an integer. I want to su…
2 replies
Hello Expert, I would like to select the data base on the DATE and TIME range. For example: Order…
3 replies
How can i use db name as parameter in a store proc? Like create proc test @dbname varchar(30) as us…
7 replies
Hey, Is it possible to create a sql clause with dynamic date filters? Like a datefilter containing …
2 replies
Select jobid As job, CASE WHEN code in ('1','2','3') THEN code ELSE 'Code is wrong' End AS ErrorMes…
1 replies
I have 3 tables. 1 table is the parent table that will create unique IDs. The other two tables wil…
9 replies
I need a quick on line refresher on Indexing, any idea where I can go? I finally have a need …
2 replies
Hi I cannot seem to get a query that works with what I need to do. If I could try and split it down…
6 replies
I have procedure which takes dates in the form of varchar fields, but when I pass the dates as I ge…
2 replies
Invalid syntax near the keyword 'case'. SELECTROW_NUMBER() OVER ( case @sort when 'relevanc…
10 replies
Ok so I've got a table on my database server called DBGrowthRAte which has the following columns...…
4 replies
I have what should be simple, but maybe someone can take me in the right direction. Here is the p…
2 replies
Hi, I've looked at the past postings on exclusion lists, but cannot get my logic to work. The compl…
1 replies
I have a table, TableA, with columns A_Acct, B, C, D....W, A_Date. There are multiple rows per A_Ac…
4 replies
Hi, We have compiled a stored procedure which typically encapsulate a few UNION statements and outp…
2 replies
Viewing 15 topics - 3,571 through 3,585 (of 17,082 total)
You must be logged in to create new topics.