Topics
Started by
Posts
Last post
Hi there, I need a script to change a TINYINT (not null default 0) TO DECIMAL(6,3). These are my re…
8 replies
Hi, Now a days i am converting my .net code in SP as much as possible. i am converting all sql quer…
1 replies
I know I should do all the create table statements etc, but I'll chop it down to the bare essential…
2 replies
Hi Team, I have a table as mentioned below with sample data CREATE TABLE EMPLOYEE_TEST( EMPID INT, …
4 replies
I am looking for a way to update a column for only one row for each ID based on a predefined rankin…
5 replies
Hi All, Wondered if someone could possibly help me with a pivot question. I am trying to pivot some…
1 replies
Hi All, I am ahving a table which contains around 150 columns and millions of rows. Now I am facing…
1 replies
Hi Everyone I have a field with a mixture of number and letter and I would like to remove all th…
2 replies
In the world of dynamically resizing HTML tables according to the number of elements, I have to bel…
3 replies
Hi All, I need help with returning a week range. I need to pass in week number and year from a sto…
2 replies
I have a select statement in my existing SP, which is not working: select IsNull(St.alternateStud…
7 replies
The cells in an N-dimensional space are modelled with the 2 tables below. A script is needed that t…
23 replies
Hi , I am replicating my problem in otherway . Say , we are tracking record of bus service i.…
20 replies
Hello Everyone I am playing around with Pivot. But I am not sure if this particular instance is a P…
10 replies
Hi, I have a table where each row has an item and the item which superseeds it. There can be many i…
6 replies
Viewing 15 topics - 2,731 through 2,745 (of 10,647 total)
You must be logged in to create new topics.