Topics
Started by
Posts
Last post
Hi all, i have created a view to calculate with hours (numbers). Whole numbers (1 to 9) is no probl…
2 replies
Hello All!!! I need to take diff of two dates,comapring two other columns,row by row.So,I have used…
5 replies
Here is my scenario. We have an online form that gets filled by vendors and this is how gets stored…
4 replies
I have a table in the following format. ID RecType PKIdentifier RecordData 1 01 acc001…
9 replies
hi guys, i have been working using PIVOT for the first time, i am going to create a view with the f…
3 replies
use [TSQLTestServer] SELECT * INTO ##g_temp FROM OPENQUERY(LocalSQL, ' SELECT * FR…
6 replies
Hi, Suppose i have the following data set. C1 C2 C3 C4 a@…
4 replies
Hello I am having two table Table1 and table2. In table 1 there is a column called errcode which co…
21 replies
Good day, I've created a view witch contains the folowing line: ISNULL([SomeDB].[SomeOwner].[SomeT…
4 replies
I have a set of values in a temp table (stored procedure) I need to dense_rank but I do not have a…
13 replies
i have one table with the following scheema: Table1 ContractorID, OrganizationID, ContactID I have …
3 replies
Hi guys I have a table sitting in a database where I dont have permissions to create or save a tabl…
2 replies
Are there any performance differences between EXCEPT and NOT EXISTS? Currently, I'm using the follo…
10 replies
Hi All, I have created a stored procedure which takes two input parameters. I need the query withi…
8 replies
I have a collection of 5 columns on which I have created a UNIQUE constraint. I should have created…
5 replies
Viewing 15 topics - 8,656 through 8,670 (of 12,234 total)
You must be logged in to create new topics.