Topics
Started by
Posts
Last post
Hi to all. I haven't posted for a while and it is now time to wear my sql cap again 🙂 I have a quer…
8 replies
CREATE FUNCTION ufntGenerateRandValue ( @minValue int, @maxValue int ) RETURNS int AS BEGIN DECLARE…
15 replies
Hi, i'm trying create on function, but the sql print: Msg 444, Level 16, State 2, Procedure Retorna…
5 replies
Why does this delete all my records, reguardless of company? delete Plant_Master where EXISTS(Selec…
9 replies
Hi All, I have an issue while splitting the data by day in the given period. The Function I am usin…
5 replies
HELP!! I have a deployment script that is building tables and setting default values to a column. …
2 replies
Hi all, I'm having an issue regarding dates that are stored in one format vs another, as far as Day…
5 replies
Hi, I need to create two triggers on my small lookup tables for audit purposes. The triggers are fo…
7 replies
I would like the column PROJECT_LEVEL to consists of the MAX value within the column DASHBOARD_STA…
1 replies
Don't laugh too hard but I'm definitely out of my element and need some help in the form of an exam…
24 replies
Hello - I have a situation where my only means of importing some badly needed data into one of my …
6 replies
My final dynamic @sql would be: Select DocID, Code, Ref, Title, DocType, FileName, InitialSignOffD…
12 replies
Data: declare @t1 table (Id int) insert into @t1 (Id) select 1 union select 2 union select 3 decla…
6 replies
I have a query (shown below) that I have been asked to filter so that only stock activity that has …
3 replies
Hi Everybody 🙂 We ship books - no more than 10 books per box. And Other items (toys, etc.) – no mo…
3 replies
Viewing 15 topics - 856 through 870 (of 12,234 total)
You must be logged in to create new topics.