Topics
Started by
Posts
Last post
Hi Folks, I connect to a SQL box in a different timezone. It stores dates in pacific time, but…
3 replies
Hi All, I have a query where I need to ONE row for each say Prod_Id...however there are mult…
2 replies
Does anyone know a way to validate the results of a stored procedure? I have a routine that c…
8 replies
I have an existing proc I need to optimize. It has some redundancy in its variable population…
21 replies
What is the syntax to add a primary key based on both fields to the below. DECLARE @test-2 TABLE( …
8 replies
I have a table (TFI) that contains the column names of another table (T1). I want to do a SEL…
7 replies
This is tough to explain simply, but either we just do not understand SQL, or there's a bug there. …
4 replies
We have an Accounts table that has NO predefined heirarchy. That is to say no UniqueID and ReportsT…
8 replies
I have no idea how to accomplish this. basically, i have a result set in Query Analyzer. …
8 replies
I am trying to take two fields from a table, both defined as varchar(132) and convert them to decim…
3 replies
1. From BOL: "Microsoft® SQL Server™ rejects all values it cannot recognize as dates between 1…
5 replies
I need help in listing all domain users that no longer have access to any user-defined databas…
1 replies
I took some code that used GetDate in a stored procedure and attempted to convert to a User Defined…
6 replies
Hello to all. I wonder if someone had or has worked with BBX, if so I need your help!!!!!!!!!!!!!!!…
9 replies
Hello and thanks in advance for the help. What I am trying to accoomplish in the UPDATE query below…
7 replies
Viewing 15 topics - 11,791 through 11,805 (of 17,082 total)
You must be logged in to create new topics.