Topics
Started by
Posts
Last post
Hi, I want to merge two tables both has the same fields. For e.g. I have two tables Table A and Tab…
4 replies
Problem-1 I want to create an indexed view by using the following query : Create view View1 with …
7 replies
Hi, Is there a better way to write following query ? select i.csuflxideb,i.csddedcode,…
4 replies
I am triying ot pass a List like 'A', 'B', 'C', 'D' Like one argument for a Store Procedure like th…
9 replies
I am doing some investigations to find out if inserts happen in a more efficient way using XML. It …
17 replies
One of my developers is having issues pulling over a text field from a linkedserver. Can this be d…
2 replies
The query runs fine if no joins are used, but when the aliased column is used as a join "ON" c…
6 replies
Can I use a table variable to pass several similar values into the Stored Procedure? What do I pass…
4 replies
running this statement INSERT INTO PS_JWI_GENRPT_TMP1 select R.BUSINESS_UNIT, R.PROJECT_ID, R.EMPLI…
3 replies
HI Is it possible to pass table datatype to stored procedure as parameter?? Thanks &…
6 replies
Dear i want to have a query which fetches all records which are inserted in last 7 days inc…
9 replies
How do I convert a datetime value into just the 4 digit year?
2 replies
Hey all, Is it possible to have a loop in a select statement or do I have to use cursors? Suppose I…
3 replies
I'm rather new to t-sql - i've an existing table of postal address tblAddr and i've decided to…
4 replies
I'm having trouble calling a function within a SELECT statement. To start off with this works (simp…
4 replies
Viewing 15 topics - 6,841 through 6,855 (of 17,082 total)
You must be logged in to create new topics.