Topics
Started by
Posts
Last post
I have two tables: one with name tblmonth and another with name tbldate as follows: tblmonth: stdid…
9 replies
I have created the following function: CREATE FUNCTION [dbo].[DailyActivity] ( ) RETURNS @SalesData…
2 replies
declare @tblmonth table(stdid int, code char(1), jan int, feb int, march int, april int, may int) d…
1 replies
Hi, I have integer value column in table. these values are not sequential. Some values may be missi…
5 replies
Hi All, I have situation like below. I have coulmn called currencylocal in table. I am using curren…
11 replies
Hello, I am writing a script to set the permissions for a particular user. While looping through th…
1 replies
I have a large chunk of code that can be run on different columns. Is there any way to do something…
19 replies
Hi Guys, I am getting below error. Ca someone please help me with this. Error: Subquery returned mo…
9 replies
I have a bunch of UDFs in Oracle10g. I wanna use them from SQL Server. Since i have my Oracle linke…
2 replies
Like we have SEQUENCE in Oracle.. We have IDENTITY in SQL SERVER. I am in a situation where I have …
3 replies
Hi, I was actually confused on the behaviour of UID's during comparison using '=' operator, wherein…
15 replies
Hi, I'm tryin to load an excel file with 3 columns into a table. In one column there are country co…
3 replies
Ok, so I wrote this query: SELECT 'HANSEN8', '2010-07-01 00:00:00.000', A.ADDRKEY, ' ', ROW_NUMBER…
2 replies
Hi All, I have a situation to find the duplicate records in a table using the comparing columns. Th…
9 replies
Hi, I need to consult something, Please give any suggestion for improvement or give corrections in …
2 replies
Viewing 15 topics - 9,271 through 9,285 (of 10,635 total)
You must be logged in to create new topics.