Viewing 15 posts - 136 through 150 (of 2,462 total)
declare @tbl table
(
emp int ,
monthyear int,
amount money
)
insert into @tbl
select 1, 102013 ,1000
union all select 2, 102013, 1000
union all select 1, 112013...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 13, 2013 at 6:00 am
polkadot (10/10/2013)
I've also rebooted. Still SPID 54 is there hogging resources and preventing me from updating a table on the Sandbox database.
Did i see notice something here ? or i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 13, 2013 at 5:38 am
can any body help me to populate table variable using dynamic query a i posted above. i had hard time to resolve this .
the above dynamic sql get tablename...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2013 at 12:09 am
One edge for printed book over ebook .. motivational thought " if I had invested money for this boom I should invest time too
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 10:57 am
Now i have modified this.
Please see . its still failing
DECLARE @AdjustmentBatch_ID INT
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 8:30 am
- Win (10/9/2013)
Can anyone please help me, how to fix this issues ?
Any settings to be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 3:53 am
you error shows that multiple recrds are being returned from inner query.
please post the culprit query.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 3:51 am
samalex (10/9/2013)
The tables I'm looking at are all heaps so no indexes.
obviously those tables will be HEAP. but by the way why are not keoing the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 3:49 am
erikd (10/9/2013)
Is there a smart SQL reason for this, or is the network the culprit?
Yes it could be either OR there are many reasons to explain your concern(actually surprise) here.
Couple...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 3:46 am
Quest Spot light. http://www.quest.com/spotlight-on-sql-server-enterprise/?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 2:57 am
writetodnh (10/10/2013)
I'm planning to learn
1. Read articles , blogs.
2. Keeps books handy may be kindle.
3. discuss with peers or other people who have good (new ) knowledge.
4. indulge...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 2:51 am
VickyDBA (10/10/2013)
Here is my update block looks like. It is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 10, 2013 at 2:40 am
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 9:15 am
you probably wont get EXACTLY what you need unless you will provide enough detail
Like table defintion , sample data and expected output.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 8:42 am
nitin.varshney (10/9/2013)
can you please suggest what are functional reason behind that ?
See this http://architects.dzone.com/articles/20-database-design-best
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 8:21 am
Viewing 15 posts - 136 through 150 (of 2,462 total)